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

Funding

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 vet@nbmc.nsw.edu.au to check eligibility or for further information.