Microsoft Excel for Data Analysts, 1-Day Online Training Course

* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course Code: EXLDAT

Duration: 1 Day

Overview

This Excel for Data Analysis course is suitable for participants who already have advanced knowledge of Microsoft Excel and wish to implement Business Intelligence components into their workbooks and use visualisation tools.

The course will cover Power Query from the Get and Transform in Excel and Power Pivot to model the data. Students will learn to obtain data from Access, Text Files, the Web, and Excel files and tables and then transform the tables by renaming, removing, splitting, and merging table columns. We will also cover various filtering techniques, such as aggregating values, calculating columns, unpivoting rows, and merging queries.

This one-day course covers aspects of Microsoft Excel that goes well beyond building basic workbooks, including workbook automation and productivity features. Participants will learn advanced Excel techniques in a range of areas such as worksheet and workbook consolidation, data validation, PivotTables and Pivot Charts, Lookup and Reference Functions, Linking Data, Financial Functions, Recorded Macros and much more.

Audience

This course will also introduce participants to Data Analysis Expression (DAX) language and bring together Text Based Visualisation with Pivot Tables using Cards and the Matrix views to see the results of DAX functions.

Prerequisites

This Data Analysis course is suitable for participants who want to extend their advanced Excel skills and be able to implement Business Intelligence within their Excel workbooks.

Module List

• Module 1: Get and Transform Introduction
• Module 2: Accessing Data Types from Query
• Module 3: Transforming Data in Query
• Module 4: Importing Data into PowerPivot
• Module 5: Data Model Relationships
• Module 6: Transforming Data in PowerPivot
• Module 7: PowerPivot vs Query
• Module 8: DAX Measures for Columns
• Module 9: DAX Measures and Metrics
• Module 10: DAX Time Intelligences Calculations
• Module 11: Text Based Calculations
• Module 12: Power Maps

Click here for the full 'Excel for Data Analysts' course outline