Excel Spreadsheet Basics Class 1– Foundation Introduction to spreadsheets, general formatting, simple calculations, everyday functions, and printing options. Excel Spreadsheet Basics Class 2– Useful Tools Conditional formatting, introduction to charts & graphs, table tools, sort & filter data, and multiple worksheet management. Excel Formulas, Functions, & Data Analysis Class 3– Powerful Functions IF, AND, OR nested function, VLOOKUP, HLOOKUP, INDEX, MATCH, conditional functions, and date and text functions Excel Formulas, Functions, & Data Analysis Class 4– Analyzing Data Importing data from various source, summarizing data with functions & tools, advanced filters, and database functions Excel Formulas, Functions, & Data Analysis Class 5– Complex Data Analysis PivotTables and PivotCharts, PowerPivot & data models, CUBE functions, and goal seek analysis Excel Efficiency Tools & Decision Making Class 6– Decision Making What-if analysis, managing scenarios, optimizing results, importing data Excel Efficiency Tools & Decision Making Class 7– Problem-Solving Data validation, restricting editing, troubleshooting formulas, macros, and multiple worksheet management Excel Efficiency Tools & Decision Making Class 8– Tools for Market Analysis Advanced charts, statistical function, financial functions (IRR, YIELD), building dashboards, another look at logical functions Excel Process Automation Class 9– Intro to VBA & Macros Create macros, using macros with button control, introduction to the VBA interface & modifying code, and basic functions in VBA Excel Process Automation Class 10– VBA- Practical Applications PivotTables and VBA, showing and hiding information using VBA, generating multiple PDF reports using VBA, use VBA to consolidate multiple workbooks Excel Process Automation Class 11– Advanced VBA User form basics, linking to databases from Excel, using variables & more in VBA, and understanding loops and writing VBA code