Microsoft Excel Training - Power Pivot, Power Query & DAX

Unlock Advanced Excel Data Analysis with Power Pivot, Power Query & DAX

Take your Excel skills to the next level with this comprehensive course focused on advanced Excel features! Learn to efficiently manipulate, analyze, and evaluate large datasets – millions of rows – from Excel and other databases. This course is perfect if you need Excel to work with data at scale.

What you'll master:

• Power Query: Learn to connect Excel to multiple workbooks, get data from the web, and merge and append queries for seamless data integration.
• Power Pivot: Understand the Power Pivot window and build powerful data models by setting up and managing relationships between tables.
• DAX (Data Analysis Expressions): Perform sophisticated calculations on your data model using functions like CALCULATE, DIVIDE, and DATESYTD. Learn to create calculated columns and unlock deeper insights.
• PivotTables & PivotCharts: Effectively display your data from the Power Pivot data model using dynamic PivotTables and insightful PivotCharts.
• Data Visualization: Utilize slicers to easily adjust and filter the data you display, gaining a more granular understanding.

Course Highlights:

• Lifetime Access: Enjoy continuous learning and updates.
• 3+ Hours of Video Tutorials: In-depth instruction for effective learning.
• 44 Individual Video Lectures: Easy-to-follow, bite-sized lessons.
• Exercise Files: Practice what you learn with hands-on exercises.
• Certificate of Completion: Demonstrate your new skills.
• Recorded using Excel from Office 365, compatible with recent versions of Microsoft Excel.

This course will help you:

• Data Manipulation: Clean, transform, and prepare data for analysis.
• Data Modeling: Build robust data models for complex reporting.
• Advanced Calculations: Perform intricate calculations with DAX.
• Data Visualization: Create compelling PivotTables and PivotCharts.
• Data Analysis at Scale: Handle and analyze large datasets efficiently.

Student Testimonials:

"The instructor speaks with a great deal of clarity and breaks down the concept in a simple manner. Enjoying the course so far! :-)" - Kamal Yusuf

"It's been an amazing experience! Worth to try it... There are so many things I didn't know about, and it's a good opportunity to remind some basic steps. EXCELLENT WORK !!! HIGHLY RECOMMEND IT!!!" - Andriana

Explore More from Simon Sez IT:

Simon Sez IT offers training in a wide range of software, including:

• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Word
• Microsoft Project
• Microsoft Outlook
• QuickBooks
• Photoshop Elements
• Web Development Languages
• ...and much more!