Full-Stack Developer Salary: Your 2025 Guide
January 6, 2025
Article
This course is part of Excel Skills for Data Analytics and Visualization Specialization
Instructors: Nicky Bull
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
65,051 already enrolled
Included with
(1,181 reviews)
Recommended experience
Intermediate level
We expect that you have some background with Excel. You can move around the interface and create basic formulas.
(1,181 reviews)
Recommended experience
Intermediate level
We expect that you have some background with Excel. You can move around the interface and create basic formulas.
Add to your LinkedIn profile
28 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data.
Excel's ease and flexibility have long made it a tool of choice for doing data analysis, but it does have some inherent limitations: for one, truly "big" data simply does not fit in a spreadsheet and for another, the process of importing and cleaning data can be a repetitive, time-consuming and error-prone. Over the last few years, Microsoft have worked on transforming the end-to-end experience for analysts, and Excel has undergone a major upgrade with the inclusion of Power Query and Power Pivot. In this course, we will learn how to use Power Query to automate the process of importing and preparing data for analysis. We will see how Power Pivot revolutionises the actual analysis process by providing us with an analytical database inside the Excel workbook, capable of storing millions of rows, and a powerful modelling language called DAX which allows us to perform advanced analytics on our data. We will finish off by venturing out of Excel and introducing Power BI, which also uses the Power Query and Power BI architecture but allows us to create stunning interactive reports and dashboards. This is the third course in our Specialization on Data Analytics and Visualization. The previous courses: Excel Fundamentals for Data Analysis and Data Visualization in Excel, cover data preparation, cleaning, visualisation, and creating dashboards. To get the most out of this course we would recommend you do the previous courses or have experience with these topics. In this course we focus on Excel Power Tools, join us for this exciting journey. Please note that Power Query, Power Pivot and Power BI Desktop are only available on the Windows platform, so Mac users will require Bootcamp running Windows or a Virtual machine with a Window O/S. While Power Query is available as an add-in Excel 2010 and 2013, the tools have changed significantly, and this course has only been designed and tested for Excel 2016 and later. For an optimal experience, we recommend Office 365.
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.
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.
9 videos4 readings8 assignments
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.
7 videos4 readings6 assignments
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.
7 videos3 readings7 assignments
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.
7 videos3 readings7 assignments
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
Specialization
Knowledge Accelerators
Course
Macquarie University
Specialization
1,181 reviews
88.17%
10.21%
1.26%
0.08%
0.25%
Showing 3 of 1181
Reviewed on Dec 31, 2024
This is a very comprehensive and easy to follow course. The contents include many useful tips and interesting information on how to utilize Excel.
Reviewed on Aug 17, 2021
Enjoyed the course and the specialization, the instructors are the best, they facilitate the information. I've learned new skills. and the course is highly recommended. thank you
Reviewed on 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.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
This course teaches the Power Query tools available in recent versions of Excel for Windows. We encourage learners to use Excel in the Office 365 suite to get access to these great new features. Most features are available in Excel 2016, and we have provided alternative ways of performing the tasks in this version. Excel 2013, while still supported by Microsoft, has not been tested for this course and is not supported by us. Excel 2010 and prior versions are no longer supported by Microsoft and do not have the necessary features for this course.
Power Query is not available for any version of Excel for Mac.
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.