00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

    Power Pivot for Microsoft Excel

     

    Description

    To demonstrate the capability of Power Pivot in Excel; to import data in a Power Pivot and create relationships; to generate Power Pivot tables and charts; to customise Power Pivot table and chart appearance.

    Price €450 per person

    Dates

    • Book a place on this course and pay with your credit card.11 January 2018 , 1/2 Day
    • Book a place on this course and pay with your credit card.27 March 2018 , 1/2 Day
    • Book a place on this course and pay with your credit card.03 May 2018 , 1/2 Day
    • Book a place on this course and pay with your credit card.17 July 2018 , 1/2 Day
    • Book a place on this course and pay with your credit card.25 September 2018 , 1/2 Day
    • Book a place on this course and pay with your credit card.15 November 2018 , 1/2 Day

    TARGET AUDIENCE

    Aimed at experienced Excel users who need to analyse and visualise large datasets from various sources.

    PREREQUISITES

    None

    GOALS AND OBJECTIVES

    Course Outline
    Click here to download course oultline

    Introduction
    Why use Power Pivot
    Power Pivot Workbooks
    The Power Pivot tab
    Data sources
    Relationships

    Importing Data
    Using the Table Import Wizard
    Import and Filter from Databases
    Run SQL Query
    Get Data from Files
    Copy and Paste Data
    Create Linked Tables

    Creating Relationships
    Understanding relationships
    Review existing relationships
    Create new relationships

    Building DAX Formulas
    Formula basics
    Calculated fields and measures

    PivotTables
    Creating a PivotTable
    Updating the table
    Changing the table structure
    Formatting the PivotTable

    PivotCharts
    Creating a PivotChart
    PivotChart Layouts
    Changing the Chart type
    Formatting the Chart

    Slicers
    Adding slicers to PivotTables and Charts
    Resizing Slicers
    Slicer options

    Course Summary and Review
    Recap of Topics Covered
    Question Time
    Individual Project Work

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.