Login / Register

9.1.1 MCSA: 70-779 Data Analysis Fundamentals using Excel

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 ... Show More
Course Prerequisites:
Before attending this course, students must have: Basic knowledge of the Microsoft Windows operating syst... Show More
Request a Quote

Virtual Instructor-Led Training (V-ILT)

Virtual instruction environments are designed to simulate the traditional classroom or learning experience. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

2 days

Course Schedule

Upcoming dates for 9.1.1 MCSA: 70-779 Data Analysis Fundamentals using Excel

Module 1: Reporting in Excel

This module examines how you can plan for an effective deployment strategy by identifying the phases of the Enterprise Desktop life-cycle. It also introduces methods used to assess readiness to ensure your network environment can efficiently and effectively deploy the Windows 10 client operating system.

  • Filtering and Formatting Data
  • Charts

Lab : Create an Excel report

  • Filtering Excel Data
  • Formatting Excel Data
  • Create excel Charts

See fewer details

Module 2: Excel Tables

This module looks at the classic Excel data model and at ways to extend it.

  • Excel Data Tables
  • Summarizing Data

Lab : Create an Excel Table

  • Create an Excel Table
  • Summarize Excel Data

+ See more details

Module 3: Pivot Tables and Pivot Charts

This module describes pivot tables and pivot charts and how to work with them.

  • Pivot Tables
  • Pivot Charts
  • Editing Pivot Tables and Pivot Charts

Lab : Importing Data from a CSV File

  • Creating a Pivot Table
  • Creating a Pivot Chart
  • Editing Pivot Tables and Pivot Charts

+ See more details

Module 4: Dashboards

This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.

  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables

Lab : Create a Dashboard

  • Arranging Tables and Charts
  • Slicing Data
  • Data Analysis

+ See more details

Module 5: Hierarchies

This module describes hierarchies and time data.

  • Hierarchies
  • Time Data

Lab : Creating Hierarchies

  • Create a Hierarchy
  • Configure Time data
  • Create an Animated Time Chart

+ See more details

Module 6: The Excel Data Model

This module explores the Excel data model and looks at ways of extending it.

  • Using an Excel Data Model
  • External Data

Lab : Explore an Excel Data Model

  • Add Multiple Tables
  • Create Relationships
  • Add External Data

+ See more details

CTU Training Solutions , Updated: May 20th, 2019

Share with friends

Request a Quote

    Your Name
    Your Surname
    Contact Number
    Your Email
    Which campus would you like to study at?
    Your job title
    Will your training be sponsored?
    How did you hear about CTU?
    The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

    Join the CTU community

    Join the CTU Community Portal and gain access to superior resources.

    Join for Free