Name: Excel Power Tools for Data Analysis
Brand: Macquarie University
Availability: OnlineOnly
Rating: 4.9 (349 reviews)

Back to Excel Power Tools for Data Analysis

Learner reviews & feedback for Excel Power Tools for Data Analysis

4.91,323 reviews

About this course

Unlock the full potential of Excel for advanced data analysis with this four-week course. Designed for aspiring data analysts and business professionals, you'll master Microsoft's powerful tools: Power Query, Power Pivot, and Power BI. This program will transform your ability to handle, analyze, and visualize large datasets, moving beyond traditional spreadsheet limitations.

By the end of this course, you will be able to: * Automate data import and transformation using Power Query. * Perform advanced data modeling and analytics with Power Pivot and DAX. * Create dynamic, interactive reports and dashboards in Power BI. * Efficiently manage and analyze millions of rows of data within Excel. To succeed, we recommend prior experience with Excel fundamentals and data visualization, ideally from our 'Data Analytics and Visualization' Specialization. This course is designed for Excel 2016 and later, with Office 365 recommended for optimal experience. Please note: Power Query, Power Pivot, and Power BI Desktop are Windows-only.

Featured reviews

5.0Reviewed Feb 1, 2022

It was a good experience of learning on course era which helped me a lot to improve my technical skills and also I would like to learn more courses on course era in future.

5.0Reviewed Oct 7, 2021

Very nice course. Learnt a lot. The instructors Nicky Bull and Dr Prashan S. M. Karunaratne were good. Helped me to develop my knowledge on excel.Thank YouMahesh Gokhale

4.0Reviewed May 28, 2024

The course seems good for learning Power Query, but it doesn't cover data modeling in enough depth. One video wasn't sufficient at all. There's also not enough coverage of DAX.

5.0Reviewed Jan 26, 2022

This course was well-organized and well-paced, with reasonable assignments and assessments, and I was immediately able to apply what I learned to my job.

5.0Reviewed Jun 2, 2023

Great explanation of every detail throughout the course. But I thought I'd let you know that there is a typo in the answer for the achieved % target in the Week 2 Practice challenge.

4.0Reviewed Mar 28, 2024

The course content was excellent however the rushed pace of the videos made it loose spontaneity and flow with constant stopping and rewinding non conducive to learning.

5.0Reviewed Nov 13, 2021

Excellent training on Power BI, even though its only compressed into one course. Looking forward to more data analytics related courses by Macquarie University.

5.0Reviewed Jan 6, 2025

This course was very informative, Nicky is very good instructor, she explains things in a very comprehensive manner, I would suggest you should make a complete course on Power BI.

5.0Reviewed Feb 25, 2025

Just excellent, everything the practice challenge, the way of teaching, everything. Great for anyone who wants to learn Data Modelling and Power BI.

4.0Reviewed Jun 22, 2023

Very useful systematic teaching approach from pivot table->Power Query->Power Pivot->PowerBi. Step by step guidance with good explanation. Worth it.

4.0Reviewed Jul 12, 2021

Pertinent content, well laid out and competent and engaging instructor(s). Some hiccups with accessing the data files. All in all, I highly recommend.

5.0Reviewed Apr 25, 2021

Great training with powerful video illustration. The course material (excel spreadsheet, data sets, PowerBI templates) are also very well articulated and prepared. Thanks very.