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).


If you have been impacted by the COVID-19 lockdown OR meet other eligibility criteria, this course may be fully funded under the NSW Government's Adult & Community Education funding. "See ACE Community Service Obligation Funding page":/cso_funding for details or contact Susan Wilkinson on 9970 1000 or email to check eligibility or for further information.

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