sales@dynamicsedge.com
202-410-6400
SKU: 100015 Categories: ,

Excel PowerPivot Course 100015

Excel PowerPivot Course 100015 - Explore the PowerPivot application, import data from sources, refresh data, and create linked tables.
Students will then move on to learning how to: organize and format tables, create calculated columns, sort and filter PowerPivot data, and create and manage table relationships.

Excel PowerPivot Course 100015

Power Pivot is an add-in you can use to perform powerful data analysis in Excel. The add-in is built into certain versions of Excel, but by default, it's not enabled.

Excel PowerPivot Course 100015 - Explore the PowerPivot application, import data from sources, refresh data, and create linked tables.
Students will then move on to learning how to: organize and format tables, create calculated columns, sort and filter PowerPivot data, and create and manage table relationships.
After building your table data learn how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually. Then, manipulate PowerPivot data using DAX functions, extract data from tables using functions, and work with time-dependent data.
Wrap up with a look at how to protect reports and how to save reports in different file formats.

Excel PowerPivot Course 100015 Outline

Lesson 1: Getting Started with PowerPivot

  • A: Enable and Navigate
  • B: Import Data from Various Data Sources
  • C: Refresh Data from a Data Source
  • D: Create Linked Tables

Lesson 2: Manipulating PowerPivot Data

  • A: Organize and Format Tables
  • B: Create Calculated Columns
  • C: Sort and Filter PowerPivot Data
  • D: Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports

  • A: Create PivotTables
  • B: Create PivotCharts
  • C: Create PowerViews
  • D: Filter Data Using Slicers
  • E: Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot

  • A: Manipulate PowerPivot Data Using DAX Functions
  • B: Extract Data from Tables Using Functions
  • C: Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data

  • A: Protect Reports
  • B: Save Reports in Different File Formats

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Excel PowerPivot Course 100015

Need help picking the right course?

Give us a call!
408-684-5250 or 
800-453-596 (Toll Free) 

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!
Request group quote

Register Now

Price:

    Print

    [bws_pdfprint display='pdf,print']
    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    https://www.dynamicsedge.com/
    sales@dynamicsedge.com
    Solutions
    Company
    202 Church Street S.E. , Suite 203 Leesburg, VA 20175
    202-410-6400
    800-453-596 (Toll Free)
    sales@dynamicsedge.com