Thanks for adding:

Proceed to Checkout

Continue browsing


Excel 2019 PowerQuery for Managing Data

Course Outline

Do you spend too much time on the repetitive tasks of importing, cleaning and/or preparing data? Excel’s data analysis capabilities have come a long way but are not well known or widely utilised. In this half day course we will look at a powerful tool called Power Query (Get and Transform) that will allow us to connect to a wide range of data sources and build simple queries to append, merge and clean our data with minimal effort and no repetition. Topics Covered • Understand Power Query • Use Power Query to Get data from Excel • Get data from other sources (csv, txt, database, online) • Use Append queries to combine data from multiple sources • Use Merge queries to link data sets • Clean Data • Transform Data • Unpivot Data • Pivot Data in the Query Editor • Create Calculated and Custom Columns This course is suitable for intermediate/advanced Excel users who are comfortable modifying spreadsheets and working with a range of calculations in Excel. Power Query is currently only available for Windows (not Mac).

This course has no current classes. Please the waiting list.

Contact us

Narrabeen Annex: 1525 Pittwater Road,
North Narrabeen NSW 2101
Office Hours: 8.30am to 4.30pm, Mon to Fri

Brookvale Campus: Level 1, 14 William St, Brookvale NSW 2100
Office Hours: 8.30am to 4.30pm, Mon to Thur

Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113