Outline:
Part 1. Advanced MS Excel Functions (includes review of Basic Functions)
-Combining Texts using CONCATENATE
-Changing Case of Texts
-Other Accessory Text Functions (FIND, SUBSTITUTE, etc.)
-Basic IF Statements
-Nested and Series IF Statements
-Using AND and OR to Combine Logic
-Combining IF with Other Functions
-Math and Date Functions
-Conditional Math Functions (SUMIF, COUNTIF, AVERAGEIFS, etc.)
-Using Wildcards with Math Functions
-Shortening Long Formulas with Arrays
-Basic and Other Uses of VLOOKUP
-Other Lookup Functions: XLOOKUP, INDEX, and MATCH
Part 2. Exploring the Data Tab Tools
-Basic Conditional Formatting
-Creating own Rules in Conditional Formatting
-Creating Basic Dropdown Menus and Cell Validation
-Advanced Dropdown Menu
-Subtotal Tool
Part 3. Analyzing Data Using PivotTables
-Basic PivotTable Features
-Grouping Data
-Using Slicers
-Calculated Fields
-PivotCharts
-Connecting PivotCharts with Slicers
Part 4. Introduction to Macros
-Macro Recording
-Understanding Macros
-Assigning Macros to Buttons