Analyzing Data with Excel

  • Course Code: MS20779
  • Course Location: Columbia, SC
  • $1500
  • Get Started

Schedule

  • Class Date: 08-10-2020
  • Class Length: 3 Days
  • Format: Classroom Live, Day Class
  • Location: Columbia, SC
$1500
Register

Audience

This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques

Objective

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Outline

Module 1: Data Analysis in Excel Module 2: The Excel Data Model Module 3: Importing Data from Files Module 4: Importing Data from Databases Module 5: Importing Data from Excel Reports Module 6: Creating and Formatting Measures Module 7: Visualizing Data in Excel Module 8: Using Excel with Power BI