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

Exciting & New Features in Excel! (Advanced)

So many Exciting & New Excel features are included in this lab!
Here are just a few:

• Exploring the advantages of XLOOKUP over VLOOKUP
• Optimizing IF statements with IFS
• Dependent (Dynamic) drop-down lists that change depending on the option that was chosen in an associated drop-down list
• Adding checkboxes to cells without additional programming
• Improved Image handling (inserting images into cells)

Also included is a specially curated list of the very best exciting & new Excel features online instructional videos!