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