Problems logging in? Try a hard refresh by holding CTRL and pushing R
More info

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

What is your MS Excel Skill Level?

Take Our Test

Which MS Excel course is for you?

Find Out More

Next MS Excel Training Dates

Cape Town-7-9 Oct 2019, JHB- 14-18 Oct 2019

View Calendar

Home
About Us
Consulting
- Excel Consulting
- Client Testimonials
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 2019

Home
Sitemap
Privacy Policy
Terms & Conditions
Support
Email Us