Excel tips and tricks for business - Session 5 - Using Power Query

Excel tips and tricks for business - Using Power Query forms the fifth part of our six-course series that covers the essentials of using Excel in a business context.

Power Query has completely changed the way that people perform regular reporting tasks. If you want to save hours, days each day/week/month that you perform reports, this session is for you!

• What is Power Query
• Connecting to data sources
• Transforming data and recording your steps
• Merge, append and combine different data sources

In the 'Excel tips and tricks for business' series we look at the core functions and features in Excel that help people build up spreadsheets and solve problems in a manner that is consistent, robust, flexible and transparent.

You can find more information about the other five sessions in the 'Agenda' tab.