Skip main navigation

Welcome to this course

Watch now as Paula explains what to expect in this course.
Hey, and welcome to the third and final course in this expert track. In this final course, we’re going to explore dashboard creating with pivot tables and with pivot charts. My name is Paula. And I will be your instructor. If you’ve not already connected with me on LinkedIn or YouTube, I really hope that you will. You’ll find my social profile attached in the links.
This course is broken down over two weeks It’s very practical hands-on course with loads for you to do. One thing I’ll say about learning excel is if you do not use it, you will lose it So, practice is key. As with the older courses, you’ll find workbooks so you can work along with me. So, what are we going to cover in this course? Well, we will first learn some basic and advanced pivot table tricks. After which, you should be confident pivoting data and creating basic pivot charts. We then move on to the dashboard creation with pivots. Some of which require advanced pivot table knowledge combined with some of the advanced charting techniques we learned in the previous course.
At the end of this course, you will be able to summarize data with pivot tables and with pivot charts. You’ll be able to create basic dashboard with pivoted data. And you’ll be able to create advanced dashboard utilizing get pivot data.
Be prepared to spend one to two hours on each week of this course. There’s articles to read, videos to watch, discussions to be had and workbooks to be downloaded so you can practice alone. Make sure you can replicate the steps before you move on. There’s also the community. This course is going be very much peer-driven. By sharing your experiences, your pains and your celebrations, not only will get you the most out of this course, but you will also you be helping each other. So, if you are ready, let’s get stuck in! [END]
This article is from the free online

How to Use Pivot Tables to Analyse Data in Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education