Analyzing and Visualizing Data with Microsoft Excel Certification Course (70-799)


Analyzing Data with Excel Certification Training Course Overview

The main purpose of Analyzing Data with Excel 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.

Audience:
  • Students who are experienced with analyzing data with Excel and who wish to add BI techniques.
  • SQL Server report creators who are interested in alternative methods of presenting data.

Analyzing and Visualizing Data with Microsoft Excel Certification Course (70-799) (Duration : 24 Hours) Download Course Contents

Instructor - Led Online Training Fee For Both Group Training & 1-on-1 Training 1050
Group Training

03,04,05 May
09:00 AM - 05:00 PM CST
(8 Hours/Day)
07,08,09 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)
GTR=Guaranteed to Run
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End


Start Time : At any time

12 AM
12 PM

Classroom training is available in select Cities
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Course Modules

  • Data Analysis in Excel
  • Contents:
  • Module Overview 1-1
  • Lesson 1: Classic Data Analysis with Excel 1-2
  • Lesson 2: Excel PivotTables 1-7
  • Lesson 3: Limitations of Classic Data Analysis 1-10
  • Lab: Building a Classic Excel Dashboard 1-12
  • Module Review and Takeaways
  • The Excel Data Model
  • Contents:
  • Module Overview 2-1
  • Lesson 1: Using an Excel Data Model 2-2
  • Lesson 2: DAX 2-7
  • Lab: Explore an Excel Data Model 2-15
  • Module Review and Takeaways
  • Importing Data from Files
  • Contents:
  • Module Overview 3-1
  • Lesson 1: Importing Data into Excel 3-2
  • Lesson 2: Shaping and Transforming Data 3-7
  • Lesson 3: Loading Data 3-13
  • Lab: Importing Data 3-17
  • Module Review and Takeaways
  • Importing Data from Databases
  • Contents:
  • Module Overview 4-1
  • Lesson 1: Available Data Sources 4-2
  • Lesson 2: Previewing, Shaping, and Transforming Data 4-5
  • Lesson 3: Loading Data 4-10
  • Lesson 4: Table Relationships and Hierarchies 4-14
  • Lab: Importing Data from Multiple Sources 4-18
  • Module Review and Takeaways
  • Importing Data from Excel Reports
  • Contents:
  • Module Overview 5-1
  • Lesson 1: Importing Data from Excel Reports 5-2
  • Lesson 2: Transforming Excel Report Data 5-9
  • Lab: Importing Data from a Report 5-17
  • Module Review and Takeaways
  • Creating and Formatting Measures
  • Contents:
  • Module Overview 6-1
  • Lesson 1: Data Analysis Expressions 6-2
  • Lesson 2: Measures 6-6
  • Lesson 3: Advanced DAX Functions 6-11
  • Lab: Creating Measures by Using Advanced DAX Functions 6-17
  • Module Review and Takeaways
  • Visualizing Data in Excel
  • Contents:
  • Module Overview 7-1
  • Lesson 1: Using PivotCharts 7-2
  • Lesson 2: Using Cube Functions 7-12
  • Lesson 3: Creating Charts for Cube Functions 7-20
  • Lab: Data Visualizations in Excel 7-30
  • Module Review and Takeaways
  • Using Excel with Power BI
  • Contents:
  • Module Overview 8-1
  • Lesson 1: Power BI 8-2
  • Lesson 2: Using Excel As a Data Source in Power BI 8-7
  • Lesson 3: Power BI Mobile App 8-12
  • Lab: Creating a Power BI Dashboard with Excel 8-15
Download Course Contents

Request More Information

Course Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.


Upon Completion of this Course, you will accomplish following:-

  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel

FAQ's

No, the published fee includes all applicable taxes.