No fluff here, just skills!
Unlike other courses, we will not get into the history of PivotTables, instead we just start learning right away.
Have you been using Excel regularly for over 1 year? Jump right in - you are ready to take your data analysis/reporting to the next level!
If you have ever been in any of these situations, then PivotTable reports are just the thing for you.
We just get right into it here.
Ready. Set. Go!
Don't Get Mad...Get Skills!
Feel free to watch the Lecture 1: Introduction before taking this quiz. However, I recommend you go for it now, and watch the lecture after you complete this quiz. Test your knowledge, you can always re-take it.
This quiz will help you solidify some important basic PivotTable skills.
In this lecture you will learn how to use the Value Field Settings to view PivotTable data from one value field in two separate ways. One column will display the Total Sales in a currency format, and another column will display the same data as a Percentage of the sales Grand Total.
By learning how to use your Value Field settings you will be able to use custom calculations to better analyze your data.
There are many custom calculations available within your Value Field Settings dialogue box, so be sure to download the additional resource detailing them.
Keep on learning!
Ensure that you have learned about advanced PivotTable Data Management tools.
As a Microsoft Certified Trainer, Billy Wigley is a Microsoft Office Expert in Excel. He actively travels throughout the USA, and other countries leading public seminars teaching Excel skills. In just five years, he has personally trained more than 45,000 professionals in over 100 cities. Wigley also consults with emergent business owners on their plans and projects to ensure success. With over 25 years of leadership experience, and from having resided in various cities worldwide, Wigley is well-known around the world. With his strong USA and Colombian heritage, Wigley takes pride in his multi-cultural background, and being able to reach English, and Spanish speakers around the globe.
Billy Wigley always says: "Don't Get Mad…Get Skills!"