Description
In this course, you will :
- Get up & running with Excel's game changing data modeling & business intelligence tools
- Learn how to use Power Query, Power Pivot & DAX to absolutely revolutionize your workflow in Excel
- Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
- Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
- Get LIFETIME access to project files, quizzes and homework exercises, and 1-on-1 expert support
- Build pro-quality business intelligence solutions to blend and analyze data from multiple sources
Syllabus :
- Intro to “Power Excel"
- Connecting & Transforming Data with Power Query in Excel
- Building Table Relationships with Excel's Data Model
- Analyzing Data with Power Pivot & DAX
- Common DAX Formulas & Functions