Microsoft Excel 101
2 Day Course
Bundle Special $250
This course takes a novice user to expert data analyst in just 2 days! Students learn the most powerful features including data analysis techniques, complex formula creation, and automation using Macros and VBA. By the end of the course, students will be able to create ad-hoc, dashboard, and pivot enabled reporting.
Key Topics
-
Advanced data analysis with PivotTables and PivotCharts
-
Complex formulas and array functions
-
Advanced conditional formatting
-
Data modeling and Power Query
-
Advanced charting techniques
-
Introduction to Power Pivot
-
Automating tasks with Macros and VBA
-
Dashboard creation and data visualization
Day One
Explore data analysis through custom formula builds, pivot table creation, and descriptive statistics application.
Day Two
Take Excel to the next level through VBA, Macros, automation, and Dashboard creation.
