PowerPivots with Excel

Summary
This course takes Pivot Tables to the next level.  You will learn how to use PowerPivot to access data sources, create relationships, PowerPivot DAX Expressions and Format reports; enabling deeper business insight and shorter decision making cycles.

 

Venue details:  
Belfast, 8-10 Amelia Street, Belfast
Start date & time:  
03 October 2019 09:30
End date & time:  
03 October 2019 16:30
Price: €270.53  (€257.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
10.00
CPD hours:  
7.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend?

Prerequisites:   

  • Demonstrate a good working knowledge of Microsoft Excel
  • Demonstrate a basic knowledge of Database Relationships (if relevant to your work)
  • Understand formula/function writing to manipulate data
  • Understand basic features of Pivot Tables, such as the area designed for fields

Course Overview

Sheet Operations

  • Copy/ Move Within Current File And To External Files
  • Group Sheets (Select Adjacent & Non-Adjacent Sheets)
  • Link Worksheets Within A Single File
  • Link Worksheets to External Files

Security

  • Protect Cell Ranges
  • Password Protect Files

Advanced Functions

  • IF Function & Nested IF Statements
  • And & Or Functions
  • Lookup Functions (Horizontal And Vertical Lookup
  • Subtotals
  • Conditional Formatting

3D Ranges

  • Create & Maintain (Within Worksheets In a Single File & Between External Files)
  • Consolidate Data (via 3D Ranges & Using The Consolidate Tool)

Data

  • Enter & Select Records Using The Input Form
  • Sort Data Into Lists
  • Filter Data - Autofilter, Advanced Filter
  • Validation Rules

Outlines

  • Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
  • Display Summary Rows And Summary Styles

Custom Views

  • Create, Modify, Delete
  • Include Hidden Rows, Columns, Filter Settings

Key learning outcomes

  • Understand the basic principles of data modelling
  • Better understand how PowerPivot might be applied back in your workplace
  • Use some of the most common DAXfunctions to extend the power of the Power Pivot data model
  • You will be able to communicate business and data insights with dashboards