The Microsoft Excel Power Query Online Course introduces you to connecting to data from a variety of sources and pulling that data into Excel for transformation. Power Query is the query engine in Excel and Power BI that connects to a variety of data sources, shows the data in real-time in Excel and allows you to transform that data into a data model for reporting. This course includes best practices and loads of shortcuts and tips to make using Excel actually enjoyable.
The online course includes videos that you can watch and rewind to learn techniques, step-by-step instructions to follow, and loads of exercises and quizzes to reinforce your learning. The course comes with a tutor who you can call, email or meet via MS Teams if you need that extra bit of support.
At the completion of the course, you will be issued with a Certificate of Completion.
Register and join us today!
Comprehensive coverage of:
- connecting and getting data from a variety of locations
- best practices with renaming queries, columns and values
- transformation including query management
- merging, splitting, renaming, moving, pivoting, unpivoting, filling and more with columns
- replacing, removing, using as headers and more with rows
- transforming data
- calculations and data modelling
This Online Course is ideal, if you struggle to find time to attend a course, and you want to learn in the privacy of your own home, during the hours that you find the most convenient. Learn at your own speed and in your own time and don't deal with the pressure of trying to learn in a group classroom setting. Your online classroom does not expire, so you can take your time and you have access to your own personal tutor via phone, email or MS Teams.
Microsoft Excel - Power Query Online Course (Level 4)
An understanding of formulas and functions, working with large sets of data, pivoting data and manipulating data is required.