(08) 9383 8000
Excel - Power Query
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.
Half-day
Overview
The Excel - Power Query course will enable you to understand how to connect to a variety of data sources and extract data, group and summarise data and transpose and unpivot complex data. After completion of this course you will be able to understand basic Power Query formulas and the M language.
Content
- Import data from databases and text files
- Aggregate Excel worksheets
- Group and summarise data
- Transpose and unpivot complex data
- Automate refreshing
- Introduce Power Query formulas and the M language.
Learning Outcomes
Participants should be able to:
- Connect to a variety of data sources and extract data
- Clean and load the data into PowerPivot
- Understand basic Power Query formulas.
Well-designed documents represent and showcase your organisation and can have a great impact. This course introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements.
If you have attended Power BI Desktop - Level 1, this course will build on your existing knowledge and introduce you to more advanced DAX (Data Analysis Expressions).
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!