Overview
On-Demand combines high-quality video, reading and knowledge checks in a self-paced format to help you build skills as your schedule allows all at once or five minutes at a time.
| Basic Package |
Standard Package |
Premium Package |
- 1-year access to instructor lecture video (based on availability)
- 1-year access to hands-on exercises, labs, games and practice tests*
- Email Help Desk Support
- *Practice tests and/or labs may not be available for certain courses
- *Includes reading materials and study guides, but official vendor courseware not included
|
- Includes digital license for official vendor courseware
- 1-year access to instructor lecture video (based on availability)
- 1-year access to hands-on exercises, labs, games and practice tests*
- Email Help Desk Support
- *Practice tests and/or labs may not be available for certain courses
|
- Standard Package plus:
- Premium Certification Prep Package:
- 3 hours of Instructor Time:
- One-on-one live instructor time geared towards your specific needs
- Scheduled in 1-hour increments
|
| $595 or 2 SATVs |
$995 or 5 SATVs |
$1595 or 5 SATVs + $595 |
Description
Overview
About this Microsoft Office On-Demand Training Course
The main purpose of the Microsoft Office On-Demand Training Course is to give students the ability to add BI techniques to Excel data analysis. The Microsoft Office On-Demand Training Course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
Audience Profile
This Microsoft Office On-Demand Training Course is intended for anyone responsible for analyzing data with Excel.
The Microsoft Office On-Demand Training Course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
Prerequisite
Before attending this Microsoft Office On-Demand Training Course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Good Knowledge of Excel spreadsheets, functions, and charts.
- Working knowledge of relational databases.
At Microsoft Office On-Demand Training Course Completion
After completing this Microsoft Office On-Demand Training Course, students will be able to:
- 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.
