Excel Pivot Table
Course
Online
Description
-
Type
Course
-
Level
Beginner
-
Methodology
Online
-
Duration
Flexible
In this bundle course you will have three courses
Course 1: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Course 2: Excel PowerQuery and PowerPivot
Course 3: Excel Pivot Table Basic
Curriculum:
Building basic maths
Managing the Field List
Changing the Calculation type with Value Field Settings
Growing your Pivot Table with Multiple Fields
Formatting the Pivot Table
Sorting and Filtering the Pivot Table
Creating a Dashboard with Slicers, Timelines and Pivot Charts
Reporting by day, month, qtr, or year within the Pivot Table
Refreshing the Pivot Data with new data
Adding your own calculations into the Pivot Table
The power of the Filter Section in the Pivot Table
PowerQuery
PowerPivot
26 videos on Excel PowerQuery and PowerPivot
28 videos on basic PivotTable
About this course
No prior knowledge or experience required
Reviews
Subjects
- Excel
- Microsoft Excel
- Microsoft excel training
- MS Excel
- Excel for Accounting
- Excel Sheet
- Excel Formula
Teachers and trainers (1)
Frontier Education
Education
Course programme
Microsoft Excel PivotTable is powerful tool to analyse, manipulate and visualise data.
Excel can feel complex-particularly PivotTable function, which is widely used in business and not easily explained.
It is a tool to automatically sort data from one table and put in another, PivotTable.
Excel PivotTable used almost all type of real life applications from entry level jobs or most senior roles.
Excel Pivot Table