What You Need to Know Before
You Start
Starts 30 June 2025 05:52
Ends 30 June 2025
Excel Power Tools for Data Analysis
Macquarie University
20 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
