“This course is available for delivery in one day!If you had the knowledge, you could accomplish tasks you never imagined macros could complete in seconds. You might have macros that do the job, but maintaining the VBA code current is a constant task. No one knows how to update it.
Mynda Treacy – My Online Training Hub – The Excel Power Query Course
Do you do repetitive data cleansing tasks like:
- Removing rows, columns or blanks
- Filtering out data you don’t need
- Modifying the layout to make it work in a PivotTable
- Text splitting or joining columns
- Remove special characters and spaces from your data
- Combine text/CSV files and worksheets
- Extracting data from an external database
- Incorporating the next month’s data to an existing report
- ….and all the other laborious repetitive tasks that put you to sleep and give you RSI
If you had the knowledge, you could accomplish tasks you never imagined macros could complete in seconds. Maybe you already have macros that do it all, but updating the VBA code is a constant task.
The Good News
If you are a Excel 2010. Power Query To automate the following tasks:
Get your data from almost anywhere
Cleansing and reformatting data to make it work in PivotTables, etc.
You can update your reports. Power Query Updates to existing or new Tables, PivotTables and other information. Power Pivot models
—————
“NOTE: The content above has been rewritten by our library.”
“To read more original content please visit here. Powered by Mynda Treacy .”
Course Features
- Lectures 0
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 78
- Assessments Yes
