Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only T&Cs apply

Find out more

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

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now