Updating your reports - Power Query will update new or existing Tables, PivotTables or Power Pivot models.
Cleaning and reformatting your data - so it works in PivotTables etc.
Getting your data - from almost anywhere.
If you have Excel 2010, or later, you can use Power Query to automate the tasks of: Or maybe you have some macros that handle it all but keeping the VBA code up to date is constant task and no one else knows how to update it. Tasks you imagine macros could do in seconds, if only you knew how.
….and all the other laborious repetitive tasks that put you to sleep and give you RSI.
Incorporating the next month’s data to an existing report.
Extracting data from an external database.
Merging worksheets, text/CSV files together.
Removing spaces and special characters from your data.
Fixing the layout so it will work in a PivotTable.
Excel for Decision Making Under Uncertainty Courseĭo you spend time each month cleaning and transforming data into the right format before you can even begin to analyse it or incorporate it into your reports?ĭo you perform repetitive data cleansing tasks like:.
0 kommentar(er)
