Excel Mastery
Excel Mastery
19 900 Ft
From VLOOKUP to Power Query. Pivot tables to macros. The complete Excel course for professionals who want to stop wasting time and start impressing their managers.
From VLOOKUP to Power Query. Pivot tables to macros. The complete Excel course for professionals who want to stop wasting time and start impressing their managers.
Excel Mastery covers everything from intermediate to advanced. You will learn: VLOOKUP, XLOOKUP, INDEX/MATCH, nested IF statements, SUMIFS/COUNTIFS, pivot tables (including calculated fields), conditional formatting, data validation, Power Query (get and transform data), Power Pivot (data modelling), basic VBA macros, dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE), named ranges, sparklines, and dashboard creation. 42 hours of video. 80+ practice files. Real business scenarios: financial modelling, sales reporting, inventory management, HR tracking. Certificate on completion. From 19,900 Ft.
Online now