Excel 2016 for Mac 3: Pivot Tables Intro & Masterclass
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779Description
This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.
It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.
After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.
After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.
By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.
It will assist with the Visualize Data section of the Microsoft exam 70-779 "Analysing and Visualizing Data with Microsoft Excel".
Requirements
- 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.
Pivot Tables, Power Pivot Tables, Power Query & Power BI
- 4.7
-
![]()
![]()
![]()
![]()
![]()
5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query & Power BI (Excel 2007-2019, O365) ---------------------------------------- "This course is tremendously comprehensive....
Excel 2016 for Mac 3: Pivot Tables Intro & Masterclass
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779 We'll also add a chart as well in that time....
