advanced excel

A complete 30-hour path that takes you from beginner to advanced on Excel, mastering the tool end to end. You start with solid foundations — essential formulas, data management, structured tables — then step up: pivot tables, advanced formulas and dynamic arrays (XLOOKUP, FILTER, UNIQUE), Power Query to combine multiple sources, the data model and Power Pivot, what-if analysis and financial functions, and dynamic dashboards driven by slicers. The second half of the path is about automation: VBA programming, macros, user forms, custom business tools and connections to external databases. Every module ends with a hands-on workshop. The course closes with a final project that brings every skill together, followed by full preparation for the official Microsoft MOS certification (Excel Associate & Expert): a PDF of corrected questions taken from the exam and a timed mock exam in real conditions.