Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Microsoft Excel Introduction to PowerPivot Webinar

Code:
WEXLPP
Days:
1 Hour
Price:
$149 excl GST
Code:
WEXLPP
Days:
1 Hour
Price:
$149 excl GST
Overview:
Understand what PowerPivot can do to enhance your pivot tables.

60 minute Live Online Webinar plus 15 minute Q&A.

Download Course Outline
Course Outline (PDF)

Objectives:

After completing this course, students will have understanding of:

  • What is PowerPivot?
  • Activating the PowerPivot add-in
  • PowerPivot Tab
  • PowerPivot for Excel
  • PowerPivot Home Tab
  • PowerPivot Design Tab
  • PowerPivot Linked Table Tab
  • Excel Data Models
  • Add Data to Your PowerPivot Workbook
  • Add Data by Using a Custom Query
  • Add Data by Using Copy and Paste
  • Save your PowerPivot Workbook
  • Create Relationships between Tables
  • Create New Relationships between Data from Separate Sources
  • Create Relationships in Diagram View
  • Create a Calculated Column
  • Create a Hierarchy in a Table
  • Create a PivotTable from PowerPivot Data
  • Add Slicers to PivotTables
  • Create a Calculated Field and KPI

Prerequisites:

Before attending this course students must be familiar with Excel and pivot tables.

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

No classes currently scheduledEnquire about this course

Interested in a private class? Enquire about a private class