Excel Essentials

Excel Essentials covers both desktop Excel and Microsoft 365 online. Module 1: Interface, workbook management, formatting. Module 2: Formulas (SUMIFS, XLOOKUP, INDEX/MATCH, nested IFs, array formulas). Module 3: Data tools — Sort, Filter, Remove Duplicates, Text to Columns, Flash Fill. Module 4: PivotTables and PivotCharts. Module 5: Power Query — import, transform, merge data from multiple sources. Module 6: Macros and VBA basics — record, edit, button triggers. 26 lessons. 20 practice files. 6 projects (financial model, HR dashboard, sales report, inventory tracker, expense report, project timeline). From $136.80.