What You Need to Know Before
You Start

Starts 6 June 2025 22:14

Ends 6 June 2025

00 days
00 hours
00 minutes
00 seconds
course image
Macquarie University

Excel Power Tools for Data Analysis

Unlock the full potential of Excel for data analysis with Excel Power Tools for Data Analysis, a comprehensive four-week course offered by Macquarie University on Coursera. Dive deep into the advanced features of Excel including Power Query, Power Pivot, and Power BI, designed to enhance your data transformation, analysis, and presentation capabili.
Macquarie University via Coursera

Macquarie University

19 Courses


Macquarie University is a top-tier university located in Sydney, Australia, with more than 40,000 students. It offers degrees in a broad array of disciplines from humanities to science and engineering. It is dedicated to research excellence, maintaining an active student life, and fostering industry collaborations.

Not Specified

Optional upgrade avallable

All Levels

Progress at your own speed

Free

Optional upgrade avallable

Overview

Unlock the full potential of Excel for data analysis with Excel Power Tools for Data Analysis, a comprehensive four-week course offered by Macquarie University on Coursera. Dive deep into the advanced features of Excel including Power Query, Power Pivot, and Power BI, designed to enhance your data transformation, analysis, and presentation capabilities.

Excel's upgrade to include these tools addresses its limitations with handling "big" data and streamlines data importing and cleaning processes.

Throughout this course, participants will master the automation of data preparation with Power Query, harness the analytical power of Power Pivot for complex data analysis within Excel, and explore Power BI for creating interactive reports and dashboards. These tools, available exclusively on the Windows platform, bring a revolutionary edge to data handling, making it essential for participants to have access to Windows through Bootcamp or a Virtual Machine if using a Mac.

This course is the third installment in our specialization series on Data Analytics and Visualization, building upon the fundamentals covered in previous courses such as Excel Fundamentals for Data Analysis and Data Visualization in Excel.

It is ideal for learners who have completed these foundational courses or possess similar experience in data preparation, visualization, and dashboard creation.

Note:

Power Query and Power BI Desktop are compatible with Excel 2016 and later versions, including Office 365, to ensure participants gain the most current and optimized learning experience. Join us at Macquarie University and Coursera for this exciting journey into Excel Power Tools for Data Analysis and elevate your data analysis skills to new heights.

Categories:

Data Analysis Courses, Data Visualization Courses, Microsoft Excel Courses.


Taught by

Nicky Bull and Dr Prashan S. M. Karunaratne


Subjects

australia