MOC On-Demand: Analyzing Data with Excel

Course Number: 20779MOD

• Vendor: Microsoft
• Category: Microsoft Technical Courses
• Prerequisites
• List Price

Description

Microsoft On-Demand Training

The main purpose of this 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.

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

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Any labs associated with courses are delivered on the Microsoft Labs Online (MLO) platform via web browser. Students launch the labs directly from within the course; no additional set-up is required.

Please contact ISInc to purchase your license, each class license is valid for 3 months. Licenses are non-refundable.

Visit www.Microsoft-On-Demand.com for more information and ordering options.

Prerequisites

Before attending this course, students must have:

-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.

-Basic knowledge of data analytics equivalent to having attended course 10994.

List Price

$995.00