Advanced Pivot Tables in Excel
In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.
In this course you will learn:
- How to do a basic Pivot Table (a quick refresher)
- How to combine data from multiple worksheets for a Pivot Table
- Grouping, ungrouping and dealing with errors in a Pivot Table
- How to format a Pivot Table, including adjusting styles
- How to use Value Field Settings in a Pivot Table
- How to use Slicers, Timelines on multiple tables
- How to create and use a Calculated Field in a Pivot Table
- The GETPIVOTDATA function
- How to create a Pivot Chart and add sparklines and slicers
- How to create 3D Maps from a PivotTable
- How to update your data in a Pivot Table and Pivot Chart
- How to use Conditional Formatting in a PivotTable
- How to create a basic macro to refresh Pivot Table data
+ Syllabus
About the author
For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.
If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.
In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.
In this course you will learn:
- How to do a basic Pivot Table (a quick refresher)
- How to combine data from multiple worksheets for a Pivot Table
- Grouping, ungrouping and dealing with errors in a Pivot Table
- How to format a Pivot Table, including adjusting styles
- How to use Value Field Settings in a Pivot Table
- How to use Slicers, Timelines on multiple tables
- How to create and use a Calculated Field in a Pivot Table
- The GETPIVOTDATA function
- How to create a Pivot Chart and add sparklines and slicers
- How to create 3D Maps from a PivotTable
- How to update your data in a Pivot Table and Pivot Chart
- How to use Conditional Formatting in a PivotTable
- How to create a basic macro to refresh Pivot Table data
+ Syllabus
About the author
For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.
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.