Macquarie University

Excel Power Tools for Data Analysis

This course is part of Excel Skills for Data Analytics and Visualization Specialization

Taught in English

Some content may not be translated

Nicky Bull
Dr Prashan S. M. Karunaratne

Instructors: Nicky Bull

51,234 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.9

(993 reviews)

|

98%

Intermediate level

Recommended experience

15 hours (approximately)
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

28 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.9

(993 reviews)

|

98%

Intermediate level

Recommended experience

15 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Excel Skills for Data Analytics and Visualization Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 5 modules in this course

Welcome to Excel Power Tools for Data Analysis. In this course, you will learn about importing and transforming data with Power Query, working with huge datasets in Power Pivot, and creating interactive reports with Power BI. This introductory material will help orient you into the course. We encourage you to think about your goals for the course and share them with your fellow learners.

What's included

3 readings1 discussion prompt

Often the first steps when analysing data are to import the data and combine different datasets together. In Excel, you can use Get and Transform, previously known as Power Query, to help with this. In this module, you will learn how to import data from various sources and the different ways to combine datasets depending on your requirements.

What's included

9 videos4 readings8 quizzes

Once your data is imported and combined, you then move on to transforming it. A common operation is to pivot data between wide and long formats. You can group data and split a column into multiple columns. Power Query has a few extra options that a normal PivotTable doesn't have.

What's included

7 videos4 readings6 quizzes

An Excel workbook can handle up to 1 million rows, which sounds like a lot but sometimes you have more data than that. The Data Model in Excel is only limited by the amount of memory your computer has. You can also define database-like relationships between tables. Then you can visualise your data using Power Pivot and cube functions, and create PivotTables.

What's included

7 videos3 readings7 quizzes

We are moving out of Excel with this module. Power BI is Microsoft's Business Intelligence tool. You can put into practice the skills that you have learned in Power Query, M, and DAX, to create dynamic and interactive reports and dashboards in Power BI. Once you have the report looking how you want, share it with others.

What's included

7 videos3 readings7 quizzes

Instructors

Instructor ratings
4.9 (372 ratings)
Nicky Bull
Macquarie University
25 Courses1,248,291 learners
Dr Prashan S. M. Karunaratne
Macquarie University
28 Courses1,254,391 learners

Offered by

Recommended if you're interested in Business Essentials

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 993

4.9

993 reviews

  • 5 stars

    88.05%

  • 4 stars

    10.34%

  • 3 stars

    1.30%

  • 2 stars

    0.10%

  • 1 star

    0.20%

JM
5

Reviewed on Apr 12, 2023

AS
4

Reviewed on Oct 4, 2022

MR
5

Reviewed on Nov 13, 2021

New to Business Essentials? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions