K2E Canada Inc
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG
  • Home
  • TRAINING
    • WEBINARS
    • UPCOMING EVENTS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • CONFERENCES
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG

Advanced PivotTables, Including PowerPivot

Half Day Course

PivotTables are Excel’s most powerful feature and if you are looking to raise your game with PivotTables, then you should plan to participate in this half-day session that will surely elevate your skills. Designed for those who already work extensively with PivotTables, this program shows how you can do even more with PivotTables to summarize, report, and analyze potentially very large volumes of data.
 
In this program, you will learn how to build PivotTables from Data Models and how to leverage PowerPivot to take advantage of even more advanced features and functions, such as Data Analysis Expressions, Key Performance Indicators, Hierarchies, Dimensions, and OLAP reporting. If you currently use PivotTables on a regular basis and want to take advantage of the powerful advanced features available in this tool, then sign up today for this program.
 
Note: This program is taught at an advanced level; other, more fundamental coverage of PivotTables is offered in our Excel PivotTables for Accountants seminar. Many of the concepts taught in this course depend upon access to PowerPivot, available only in the Professional Plus editions of Excel 2013 and Excel 2016.

Learning Objectives

Upon completing this course, you should be able to:
  • Define Data Models and build PivotTables from these objects
  • Create PivotTables using PowerPivot, including PivotTables that summarize data from multiple data sources
  • Utilize Data Analysis Expressions and other tools to add calculations to PivotTables
  • Add features such as Key Performance Indicators, Dimensions, and Hierarchies to PivotTables

Course Information

  • CPE credit: Recommended for 3.5 hours
  • Instructional delivery method: This course will be taught in Excel for Office 365 with reference to the differences to Excel 2013 and subsequent. The program focuses on Excel for Windows and we encourage you to bring your windows laptop equipped with Excel 2013 or newer to follow along with the instructor.
  • Prerequisites: Full understanding of intermediate to advanced PivotTables
  • Program level: Advanced
  • Advance preparation: Power Pivot is available in premium editions of Excel as listed at http://bit.ly/PowerPivotMyExcel you may download a trial of Office that includes PowerPivot from http://bit.ly/ExcelProPlusTrial
  • Who should participate: Business professionals using premium editions of Excel 2013 and subsequent who are seeking to extend their knowledge of PivotTables

Training & Education

Webinars
Upcoming Events
Road to Excellence Online Seminar
Seminars
Conferences
Instructors

Tech News

K2E Canada's Tech Update Newsletter

More

Privacy Policy
About
Contact

K2E Canada Inc.  |  591 Highway 221  |  North Kingston, NS Canada B0P 1R0  |  (902) 200-9207
© 2020 K2E Canada Inc. ALL RIGHTS RESERVED.