thumbnail
IT Skills

Microsoft Excel: Power Pivot (ITS16EO)

profile
Instructor

Savvy

Reviews 0 (0 Reviews)

Course Overview

Course Content

  • Academy Topics

    • About This Course

    • Course Prerequisites

    • Course Overview

    • Course Objectives

    • How To Use This Book

    • Getting Started with Power Pivot

    • Enable and Navigate Power Pivot

    • Import Data from Various Sources

    • Refresh Data from a Data Source

    • Create Linked Tables

    • Summary

    • Manipulating Power Pivot Data

    • Managing Tables

    • Creating Calculated Columns

    • Sort and Filter Power Pivot Data

    • Create and Manage Table Relationships

    • Summary

    • Visualizing Power Pivot Data

    • Create Pivot Tables

    • Create PivotCharts

    • Create Key Performance Indicators (KPIs)

    • Filter Data Using Slicers

    • Create Sparklines

    • Apply Conditional Formattin

    • Summary

    • Using DAX Functions In Power Pivot

    • Manipulate Power Pivot Data Using DAX Functions

    • Extract Data from Tables Using Functions

    • Work with Time Dependent Data

    • Summary

    • Distributing Power Pivot Data

    • Protect Data

    • Saving Data in Different File Formats

    • Summary

    • Course Summary

    • Post-Course Assessment

Paid
  • Lessons 35
  • Skill Beginner
  • Last Update 27/02/2025