No-Cost Microsoft Excel Training

Four Different Lab Topics!

No-Cost Virtual Learning Lab Dates and Times

Note: These labs will be held on Mondays.

  • Basic Excel - Monday, February 19th, 10:00 AM - Noon
  • Basic Excel - Monday, February 19th, 1:30 - 3:30 PM

  • Intermediate Excel - Monday, February 26th, 10:00 AM - Noon
  • Intermediate Excel - Monday, February 26th, 1:30 - 3:30 PM

  • Advanced Formulas in Excel - Monday, March 4th, 10:00 AM - Noon

  • Pivot Tables in Excel- Monday, March 4th, 1:30 - 3:30 PM

(Scroll down for additional lab topic information for each lab.)

Provided by:

"Helping the Tulsa Area United Way and its Partner Agencies make the most of technology."

In these virtual hands-on labs, you will get acquainted with navigating the changes that come with recent versions and learn plenty of helpful tips and tricks to make the most of Microsoft Excel.

Basic Excel

  • Excel Math Basics - formulas & functions
  • Autofill, AutoComplete
  • Formatting Text
  • Formatting Numbers
  • Borders and Fill Colors
  • Conditional Formatting
  • Using Styles and Themes
  • Sorting and Filtering Data
  • Printing Worksheets and Sharing Workbooks

Intermediate Excel

  • Managing Your Data - Rows to Columns, Checking for Duplicates, Data Validation
  • Troubleshooting Formulas and Tracing Their Components
  • Transpose Data from Rows to Columns
  • Grouping and Subtotals
  • Mastering Macros
  • Creating and Customizing Charts

Advanced Formulas

  • Relative vs. Absolute References
  • Nested Functions
  • 3D Formulas and referencing cells on other worksheets
  • Using Names in Formulas
  • Common and Not-So-Common Functions
  • Concatenate - joining data from multiple cells
  • Changing the case of text
  • Comparing columns of data
  • Removing extra spaces
  • IF Functions
  • VLOOKUP
  • Using Tables
  • Timesaving Tips

Pivot Tables

  • Managing Pivot Table Data
    • Transposing Data from Rows to Columns
    • Using the Text to Columns Feature
    • Data Validation
    • Consolidating Data
  • Grouping and Outlining Data
  • Creating Pivot Tables
    • Inserting a Pivot Table
    • Applying Styles to Pivot Tables
  • Creating a Pivot Chart

No-Cost Microsoft Excel Training

Four Different Lab Topics!

No-Cost Virtual Learning Lab Dates and Times

Note: These labs will be held on Mondays.

  • Basic Excel - Monday, February 19th, 10:00 AM - Noon
  • Basic Excel - Monday, February 19th, 1:30 - 3:30 PM

  • Intermediate Excel - Monday, February 26th, 10:00 AM - Noon
  • Intermediate Excel - Monday, February 26th, 1:30 - 3:30 PM

  • Advanced Formulas in Excel - Monday, March 4th, 10:00 AM - Noon

  • Pivot Tables in Excel- Monday, March 4th, 1:30 - 3:30 PM

(Scroll down for additional lab topic information for each lab.)

Provided by:

"Helping the Tulsa Area United Way and its Partner Agencies make the most of technology."

In these virtual hands-on labs, you will get acquainted with navigating the changes that come with recent versions and learn plenty of helpful tips and tricks to make the most of Microsoft Excel.

Basic Excel

  • Excel Math Basics - formulas & functions
  • Autofill, AutoComplete
  • Formatting Text
  • Formatting Numbers
  • Borders and Fill Colors
  • Conditional Formatting
  • Using Styles and Themes
  • Sorting and Filtering Data
  • Printing Worksheets and Sharing Workbooks

Intermediate Excel

  • Managing Your Data - Rows to Columns, Checking for Duplicates, Data Validation
  • Troubleshooting Formulas and Tracing Their Components
  • Transpose Data from Rows to Columns
  • Grouping and Subtotals
  • Mastering Macros
  • Creating and Customizing Charts

Advanced Formulas

  • Relative vs. Absolute References
  • Nested Functions
  • 3D Formulas and referencing cells on other worksheets
  • Using Names in Formulas
  • Common and Not-So-Common Functions
  • Concatenate - joining data from multiple cells
  • Changing the case of text
  • Comparing columns of data
  • Removing extra spaces
  • IF Functions
  • VLOOKUP
  • Using Tables
  • Timesaving Tips

Pivot Tables

  • Managing Pivot Table Data
    • Transposing Data from Rows to Columns
    • Using the Text to Columns Feature
    • Data Validation
    • Consolidating Data
  • Grouping and Outlining Data
  • Creating Pivot Tables
    • Inserting a Pivot Table
    • Applying Styles to Pivot Tables
  • Creating a Pivot Chart