Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with PowerPivot. What is PowerPivot? It is an extremely powerful tool in Excel. What exactly does it do? It very quickly builds up PivotTables from huge amounts of data. And even more amazing: the data does not all need to come from the same source!
This course explains how to seamlessly merge an Excel list with an Access database. Or with a table originating from an SQL server. Did you know that a normal Excel table is limited to 1,048,576 rows? PowerPivot manages to break down this barrier too. And not only that, this rock-solid tool has masses of new features that enable you to analyse table data even better.
Need to compile complex business reports? Sign up now for the course ‘Excel PowerPivot - Introduction’. And make it all very easy for yourself!
Would you like to see with your own eyes what PowerPivot has to offer? Then sign up for our course ‘Excel PowerPivot’ and find out how to effortlessly:
This course is for anyone already familiar with PivotTables, but who would like to find out about an even more powerful analysing tool.
You need to be familiar with entering functions without using the function wizard (which is not available in PowerPivot). Furthermore, you must be familiar with the basic PivotTables operations, such as: what are the different sections used for (Filter, Columns, Rows and Values); how do you change a calculation in a PivotTable from Sum into Average, how do you show the value as a percentage relative to the total.
Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.