Welcome to 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]