Analyzing Data with Excel

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


Sorry No Events


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


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.


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