dvanced Excel Pro teaches practical, job-ready Excel skills for real-world data work. Starting from complex formulas (INDEX-MATCH, array formulas, dynamic arrays) you’ll move to PivotTables & PivotCharts, Power Query for ETL, Power Pivot and DAX basics for data modeling, professional charting, interactive dashboards, and automation with VBA/macros. The course is project-based — build portfolio-ready dashboards and automation scripts you can use immediately at work.
What you’ll learn
-
Advanced formulas: INDEX/MATCH, XLOOKUP, SUMIFS, dynamic arrays, LET, FILTER.
-
PivotTables & PivotCharts: multi-level analysis, slicers, calculated fields.
-
Power Query (Get & Transform): clean, merge, and shape data from multiple sources.
-
Power Pivot & Data Model: relationships, measures, and DAX basics.
-
Dashboard design: KPI cards, interactive charts, slicers and presentation best practices.
-
VBA & Macros: automate repetitive tasks, create user forms, and write reusable scripts.
-
Real projects: sales dashboard, expense analyzer, automated report generator.
Who this is for
Students, accountants, business analysts, HR professionals, marketers — anyone who works with data and wants to save time and improve insights.
Duration & format
40 hours (recommended) — instructor-led + practical exercises + downloadable templates. Flexible weekend batches and weekday evening classes available.
Outcome & certification
Receive a Zeevi Certificate of Completion and a portfolio project you can show employers. Expect to cut reporting time drastically and deliver more compelling data stories.
Reviews
There are no reviews yet.