Target Audience
If you are an experienced Excel user, you will know that you spend a good chunk of your time re-organising and re-formatting data. What if there was a way within Excel to automate this? Meet Power Query...
Outline
In this short course you will learn:
- What is Power Query and why should you care?
- Text clean up.
- File clean up.
- Combining folder contents automatically.
Methodology
- Delivered virtually via Zoom.
- GiraffePad will be the platform used to hold the Zoom link/training materials/recording.
Instructor
Anne Walsh
Anne Walsh has been an IT trainer since Excel came on Windows 95. She has been a freelance IT trainer since the mid-90s. She is a MOS Master Instructor. She is also the author of “Your Excel Survival Kit: Your guide to surviving and thriving in an Excel world” which has been receiving consistent 5 star reviews on Amazon. She blogs regularly at www.the-excel-expert.com.
You can read testimonials for her work at http://www.the-excel-expert.com/training-2/testimonials/.
Outcomes
- Learn tips on how to perform data cleansing tasks using Power Query.
Fees
| €50 | Nonprofit Organisation |
| €40 | Carmichael Resident Organisation |
| €60 | Statutory Organisation |
| €60 | Corporate Organisation |
Testimonials
The lecturer, Anne made the who experience very enjoyable.
Great facilitator with a lot of experience, knowledge and an enjoyable style of teaching.