Power Pivot & Power Query & DAX in Excel
In this Excel course, we look at three crucial advanced Excel features - Power Pivot, Power Query, and DAX. These functions allow you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. Learn how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between data tables and building out a data model. We then look at performing calculations on a data model using DAX, and finally, displaying an analysis using PivotTables and PivotCharts.
4.8 (5 Reviews)
789 student views
Course Goal
- How to use Power Query to manipulate and organize your data
- How to use Power Pivot to perform detailed analysis on millions of rows of data
- All about creating Pivot Charts and PivotTables and using your data model
- How to set up and manage relationships in a data model
- How to merge and append queries using Power Query
Who This Training Is For
- All
Exam/Certificate
- Certificate of Completion (more certification info)
- Upon successful completion of this course, receive your Power Pivot & Power Query & DAX in Excel certificate
This Course is In the Following Learning Paths:
Take this learning path to increase your skills from a spreadsheet novice to an Excel Master. After you complete this pa...
Learn the skills to manipulate, merge, analyze, and evaluate millions of rows of data from Excel or other databases whil...
Instructor
4.7 Average Rating
133 Reviews
955 Students
24 Courses
Teaching Business Software
The IT in Simon Sez IT stands for Information Technology. In a nutshell: We make business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design, and QuickBooks. Self-paced, affordable software training is what Simon Sez IT is all about. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you're new to a certain technology or just technology shy in general. Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.
Student Feedback
4.8
Average Rating