One of the most powerful aspects of Microsoft Excel is its ability to analyse and present data quickly and easily using PivotTables.
Excel can feel daunting – in particular the infamous PivotTable™ function, which is widely spoken about and little understood.
In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.
But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.
In this course you will learn:
- The primary uses of pivot tables
- How to identify the best and worst datasets
- To filter, sort and group PivotTable™ data to maximise its usefulness
- How to present your data clearly using PivotCharts and Conditional Formatting
+ SECTION 1 | PIVOTTABLES - 19 MODULES
Unit 1 | Introduction and Basics
1. Uses and Benefits of PivotTables
2. Basics of PivotTables
3. Manipulating PivotTable Data
Unit 2 | Filter and Group to Compare and Contrast
2. Sorting and Grouping
Unit 3 | Presentation – Clarity and Impact
1. Layout and Formatting
3. Conditional Formatting in PivotTables
Unit 4 | Calculations – Adding Value to Values
1. Value Field Settings
2. Calculated Fields and Values
Unit 5 | Your Data Your Way – Flexible Reporting
1. Using PivotTables As Management Report Engines
2. Cube Values
Unit 6 | Power to the User – Interactivity
1. Understand Data With Slicers and Timelines
+ SECTION 2 | PIVOTTABLES FOR DATA ANALYSIS - 18 MODULES
Unit 7 | Dominate Your Data
1. Understanding Data Structures
2. The Power Query Add-In
Unit 8 | Power Pivot and Big Data
1. Introduction to Power Pivot
2. Power Pivot Data Tools
Unit 9 | Make Your Data Work Harder
1. Basic Data Analysis Expressions (DAX) Introduction
2. Advanced Data Analysis Expressions (DAX)
3. Time Intelligence Functions
Unit 10 | From Data to Decisions
2. Additional Features
4. Cube Functions
5. Creating a Dashboard
Unit 11 | Present Data Analysis With Impact
1. What Makes a Good Chart?
2. Advanced Charts
3. Waterfall Chart
Unit 12 | Give Me More Power
1. Power View
2. Power Map
About the author
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.
If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.
Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.