Course details
One the most powerful aspects of Microsoft Excel is its ability to analyse and present data quickly and easily using PivotTables.
In this course you will learn:
- The primary uses of PivotTables
- How to identify the best and worst data sets
- To filter, sort and group PivotTable data to maximise it's usefulness
- How to present your data clearly using PivotCharts and Conditional Formatting
- To create great looking management reports using a PivotTable
Your data analysis will never be the same after unlocking the full power of PivotTables.
The PivotTable is one of the most useful, powerful and misunderstood features in Excel. PivotTables are not just about big data and large companies. Although PivotTables can work with large data sets, they are just as useful for micro businesses trying to understand where their sales opportunities lie, or for individuals working on their household finances.
Updated on 24 September, 2018About Skillsology
Skillsology was founded in 2013 as a brand of the Excel with Business Ltd. group of brands. Based in Shoreditch and part of London’s expanding tech scene, the team is driven by producing quality, curated online courses that help people fulfil their career or personal goals.
See all Skillsology courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Data Analysis and Forecasting in Excel NextGen LearningUSD 12Duration: Upto 5 Hours
- Excel 2013 for Beginners eduCBAUSD 21
USD 105Duration: Upto 5 Hours
