LARA MELLOR TRAINING & CONSULTANCY
Microsoft Excel: Power Query
Do you spend ages tidying up your data before you can even do anything with it? Do you have to do this every week, month or quarter?
Power Query is going to change your life!! You can get your data from almost anywhere and Power Query can clean and reformat your data without the need of macros and VBA code.
The ‘Power Query’ module of Lara Mellor Training and Consultancy’s Microsoft Excel training courses is designed to help you learn how to efficiently get your data in the format you require with minimal effort and manual intervention.
You will learn:
- What is Power Query?
- How to get data from different sources
- Appending and merging data
- Transforming and cleaning data
- Loading and refreshing
Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and learn valuable skills that they will be able to use within your business straight away.
BROWSE ALL EXCEL MODULES
Ready to get started?
Get in touch today to book your Microsoft Excel training.
Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and can learn valuable skills that they’ll be able to use within your business straight away.
INTERESTED IN MULTIPLE COURSES?
If you’re looking to book courses in Word, Excel, PowerPoint or other Microsoft programmes, please get in touch via our general training enquiry form here.