No-Cost Microsoft Excel Training
Four Different Lab Topics!
No-Cost Virtual Learning Lab Dates and Times
Note: These labs will be held on Wednesdays.
- Basic Excel - Wednesday, October 29th, 10:00 AM - Noon
- Basic Excel - Wednesday, October 29th, 1:30 - 3:30 PM
- Intermediate Excel - Wednesday, November 5th, 10:00 AM - Noon
- Intermediate Excel - Wednesday, November 5th, 1:30 - 3:30 PM
- Advanced Formulas in Excel - Wednesday, November 12th, 10:00 AM - Noon
- Advanced Formulas in Excel - Wednesday, November 12th, 1:30 - 3:30 PM
- Pivot Tables in Excel - Wednesday, November 19th, 10:00 AM - Noon
- Pivot Tables in Excel - Wednesday, November 19th, 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."
"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 & XLOOKUP
- 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 Charts