Login / Register

55084A: Excel 2013 Self-Service Analytics with No Code for the End User

This course is designed for the end users and analysts that are interested in exploring the new self-service business intelligence tools in Excel and SharePoint Server 2013. This course is intended for all business profe... Show More
Course Prerequisites:
Computer Literacy
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. 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 55084A: Excel 2013 Self-Service Analytics with No Code for the End User

Course Content

Module 1: Course Overview

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing

Module 2: Microsoft Business Intelligence Vision

  • What is Business Intelligence?
  • Enterprise Business Intelligence
  • Team Business Intelligence
  • Self-Service Business Intelligence

Lab : Microsoft Business Intelligence Vision

Module 3: Excel 2013 PowerPivot
In this Module we will explore PowerPivot and its analytical capabilities. PowerPivot is a data analysis add-on for Microsoft Excel that allows large amounts of data to be collected, aggregated, and analyzed in one workbook. Sound powerful? It is! We’ll cover everything you need to know to get you up, running, and analyzing.


  • Best Things That PowerPivot Brings to Excel
  • What Will PowerPivot Do for the Analyst?
  • Introduction to PivotTables (Optional)
  • PowerPivot Versions
  • New 2013 PowerPivot Features
  • VLOOKUP Not Required (Use Relationships)
  • Architectural Changes in Excel 2013
  • PowerPivot and Excel 2013
  • PowerPivot and SharePoint
  • Enterprise Business Intelligence and PowerPivot
  • Importing Data
  • Data Models
  • Relationships
  • Simple PivotTable Reports
  • Calculated Columns and Calculated Fields
  • Refreshing Data
  • Calculations
  • SharePoint Sharing

Lab : Excel 2013 PowerPivot

Module 4: Power View
In this Module we will cover Power View and the reporting that can be created. From tables to charts and sharing on SharePoint, this Module will have you ready to visualize your data in a variety of ways.


  • Report Design Principles
  • New 2013 Power View Features
  • Microsoft Power View User Interface
  • Tables
  • Charts
  • BI Semantic Models
  • Saving and Sharing

Lab : Power View

Module 5: Power Query
This Module explains how to use Power Query effectively.


  • Power Query and Power Query Formulas
  • ETL with Power Query
  • Online Search
  • Data Refresh
  • Managing Data Sources and Queries

Lab : Power Query
Module 6: Power Map
This Module explores Power Map, a new 3D visualization add-in for mapping, exploring, and interacting with geographical and temporal data, enabling users to discover and share new insights.


  • What is Power Map and How Does It Work?
  • Data Visualizations and 3D Mapping Using Power Map
  • What is a Tour?

Lab : Power Map

Module 7: Summary Lab Exercises
This Module includes concept reinforcement scenarios to encourage students to use what they’ve learned throughout this course. Scenario solutions are provided.

  • Summary Scenario xx
  • Summary Scenario xx
  • Summary Scenario xx

Lab : Summary Lab Solutions

CTU Training Solutions , Updated: July 6th, 2017

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