You often have to re-edit the data you enter into PowerPivot: splitting up the text into different columns, converting text to upper case, adding extra columns with certain calculations, filling up blank cells and much more.
This means that you can't use certain sources straight away, because you first need to delete unnecessary information. Or because that information has a different layout. With the aid of Power Query you can get round these problems without difficulty. You input the data, define what is to be done and then enter the optimised data, in Excel, or in the PowerPivot data model. And this without programming in VBA!
Anyone who ends up having to re-edit data before it can be used in Excel or in PowerPivot .
A solid knowledge of Excel is required. Knowledge of PowerPivot is not required.
Would you like to organize this training course for your employees? At your offices and/or with adapted content? We transform your requirements into the perfect solution.