Login problems? Try a hard refresh on the page (CTRL + R)
More info

Call +27 (0) 81 044 2984
info@auditexcel.co.za

Next MS Excel Training Dates

2020: 10-14 Feb, 9-13 Mar (JHB), 2-4 Mar (CT)

View Calendar

What is your MS Excel Skill Level?

Take Our Test

What are you looking for?

Search the Site

Home
About Us
Consulting
- MS Excel Consulting
- Client Reviews
Live Training
Online Excel Courses
Excel Tips, Tools & Videos
Online Shop
- Online Courses Shop
- Excel Tools/ Add Ins Shop
Contact Us

Pivot Charts in Excel

Please purchase the course before starting the lesson.

Pivot Charts in Excel

Back to: Intermediate Excel Course > Pivot Tables

Select Your Currency

Intermediate Excel Course

Previous
Next

Pivot Tables
Required data format for Pivot tables
Create a Pivot Table- Step by Step
Inserting Values into a Pivot Table
Enhancing the values e.g. percentage of another column
Show the details of a number in the Pivot Table
Pivot Examples: SUM, COUNT, AVERAGE, Percentage of
Laying out the Pivot Report in completely separate columns
Working with the rows in a Pivot Table- dropdown
Working with the rows in a Pivot Table- field settings
Normalize Pivot Reports to use elsewhere as a copy paste
Pivot Examples: rows in a pivot table
Working with the Columns in a Pivot Table
Pivot Examples: values, rows and columns
Working with the Filter in a Pivot Table
Automatically duplicate your Pivot Tables with different selections
Slicers in a Pivot Table
Control all Pivot Tables and Charts at once
Timelines in a Pivot Table
Grouping Dates into days, months, quarters and years in a Pivot Table
Grouping Dates into weeks in a Pivot Table
Grouping Text in a Pivot Table
Grouping Numbers in a Pivot Table
Pivot Charts in Excel
Problems with grouping in Pivot Tables
Pivot Examples: All features learnt so far
Pivot Examples: Business Intelligence 1
Pivot Examples: Business Intelligence 2

My Active Courses

Online MS Excel Super Bundle
7 Lessons
$749
Online Corporate Financial Modelling Course
3 Lessons
$399
Advanced MS Excel for Auditors and Consultants
4 Lessons
$339
Intermediate to Advanced Excel Course
2 Lessons
$199
Excel Functions and Formulas
105 Lessons
$139

Training Courses

Online Training
Live Training
Skills Assessment
Presenters

Useful Links

Video Tutorials
Blog & Excel Tips
Online Shop
About AuditExcel

Give us a call +27 (0) 81 044 2984
Email: info@auditexcel.co.za

All content copyright AuditExcel 2020

Home
Sitemap
Privacy Policy
Terms & Conditions
Support
Email Us