• LOGIN
    • No products in the cart.

MOD-10994

Audience: IT Professionals | Technology: SQL Server | Level: 200

Introduction

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

Audience Profile

This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

Prerequisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic Knowledge of Excel spreadsheets

At Course Completion

After completing this course, students will be able to:

  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data
Download Full Description

Course Curriculum

Module 1: Reporting in Excel
Module 2: Excel Tables
Module 3: Pivot Tables and Pivot Charts
Module 4: Dashboards
Module 5: Hierarchies
Module 6: The Excel Data Model
TAKE THIS COURSE
  • $315.00
  • 3 months
  • Course Certificate
0 STUDENTS ENROLLED

    Course Search

    New Energy Taxes = Less Energy
    Website Designers © The Brand Institute. Microsoft Online Training Courses | MOC on Demand
    MOC On-Demand
    CONTACT US
    Please send us your information and we will get back to you in regard to Software Assurance Training Vouchers
    Thank You. We will contact you as soon as possible.
    MOC On-Demand
    CONTACT US
    We look forward to hearing from you, please do feel free to leave us a message and we will get back to you soonest.
    Thank You. We will contact you as soon as possible.
    MOC On-Demand
    REQUEST A DEMO
    Please send us your information and we will get back to you in regard to a demo course.
    Thank You. We will contact you as soon as possible.