Excel for Mac 3: Pivot Tables Intro & Masterclass

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779

Created by: Phillip Burton • 880000+ students so far
Best Selling Instructor - over 880,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I Learn?

• Create Pivot Tables with a just a few clicks, simply and quickly.
• Maintain and expand Pivot Tables.
• Update data sources, and maintain formatting during refreshes.
• Create Pivot Charts in a few simple clicks.
• Know and use about the more advanced features, and create advanced Pivot Tables.
• Find out how much powerful it is, and how quickly it can improve your data analysis.

Requirements

• You should be able to open and save Microsoft spreadsheets. You should also be able to enter data.
• That's it! We'll create our first Pivot Table in just a couple of minutes - that's all.

Target audience

• This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.
• This is also for you if you use PivotTables, and want to go deeper. Much deeper. 🙂
• We'll also go into the more advanced functions, and create charts as well, quickly and easily.