You need to get answers to questions and you need them quickly. How many people buy a certain product? In which month should we discount that product? If you've yet to embrace Pivot Tables, then you won't know how quickly you can get answers. Not only that but you can within minutes create effective summary tables and charts to be used in presentations and reports.
This course is designed specifically to look at Pivot Tables. You will learn how to correctly structure data, learning various Excel formulas and functions to enable you to do this. We will also take a look at the PowerPivot plugin in Excel, giving you an opportunity to use DAX with multiple data sources.
Previous Excel experience such as writing simple formulas, along with a basic understanding of how to add rows and columns would be beneficial.
Course Duration: 1 Day
1 - 8 Students
£250 + VAT - 3hrs (bespoke)
£500 + VAT - 6hrs (full day*)
* Full training days can be split into 2 sessions
If you are interested in this classroom based course but want to know the price beforehand then use the the following form to calculate how much.
Although this course is designed with Excel 2013 in mind, the principles used could be applied to 2010 & 2016 as well.
You may also be interested in the following courses:
Or the following training courses may be of interest: