Excel Mastery

Complete Excel training from absolute beginner to advanced power user. Module 1: Foundation (navigation, formatting, basic formulas — SUM, AVERAGE, COUNT, IF, cell references). Module 2: Data Management (sorting, filtering, tables, data validation, named ranges, conditional formatting rules). Module 3: Advanced Formulas (VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP, nested IFs, SUMIFS, COUNTIFS, text functions, date functions, error handling with IFERROR). Module 4: PivotTables and PivotCharts (creation, grouping, calculated fields, slicers, timelines, dashboards, refreshing from external data). Module 5: Power Query (importing data from multiple sources, transforming columns, merging tables, appending queries, automating data cleanup workflows). Module 6: VBA Basics (recording macros, editing in the VBA editor, loops, If/Then logic, UserForms, automating repetitive tasks like report generation and email sending). 30 video lessons (8-12 min each). 30 practice exercises with answer keys. 5 capstone projects: personal budget tracker, sales dashboard, inventory management system, expense report generator, and automated monthly report. All practice files included. From $143.70.