Microsoft Excel 2016 PowerPivot


SKU: GC1920 Categories: ,

Microsoft Excel 2016 PowerPivot

Our Microsoft Excel 2016 PowerPivot training materials provides you with a fully-customizable package of courseware content for delivering Microsoft Office training to your employees and/or students. Everything you need to run the course is included, just add trainer!

All courseware print licences are perpetual – buy once and use forever!

  • Fully customizable. Sold on a site licence basis, you can tailor ALL content to meet specific learning or corporate requirements.
  • Digital download. Content is available to download after purchase.
  • Proven. Our course materials are used in hundreds of training centres around the world. Every course is fully beta tested and validated in the classroom before undergoing a full production release.
  • Simple… No need to invest in expensive DTP applications – all files are easily editable in any word processor.
  • Print on demand. You only need to print exactly what you need, when you need it.
  • Totally flexible. Courses can be modified to meet specific requirements. Sections can be removed. New content added. One or more titles can be combined. Whatever your training requirements, our courseware can help you meet that need.
  • Unlimited users. Content is sold on a site licence basis. You can train as many staff or employees at that location as you like. Forever!
  • Buy once. Use forever! You’re buying a perpetual licence. One payment gives you an unlimited site licence for use as long as you need it.
  • No limits! Unlike some content providers, our licence enables you to reprint the courseware as many times as you like. 1 student or 100,000. No limits…

Student manual

Fully customisable. May be opened in any word processor and changed to meet your exact needs.

Student workbook

Fully customisable. Additional book includes series of practical tasks and review questions.

Student workbook exercises

Sample exercises to accompany the student workbook.

Trainer manual

Fully customisable with additional information for trainers.

Timetable and lesson plans

Detailed timetable and plans ensure you deliver the best possible course

PowerPoint presentations

PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

Course contents

  • Enable and Navigate • PowerPivot • The PowerPivot Window • The PowerPivot Ribbon Interface • PowerPivot Worksheets
  • Import Data from Various Data Sources • PowerPivot Data Sources • Data Feeds • The Table Import Wizard • Data Types • How to Import Data From Various Data Sources
  • Refresh Data from a Data Source • Data Refresh • Connections • How to Refresh Data from a Data Source
  • Create Linked Tables • Linked Tables • How to Create Linked Tables • Review Questions
  • Organize and Format Tables • PowerPivot Tables • Managing Tables • How to Organize and Format Tables
  • Create Calculated Columns • Calculated Columns • PowerPivot Formulas • How to Create Calculated Columns
  • Sort and Filter PowerPivot Data • Sort Options • Filter Options • How to Sort and Filter PowerPivot Data
  • Create and Manage Table Relationships • Table Relationships • Types of Relationships • The Create Relationship Dialog Box • The Manage Relationships Dialog Box • The Diagram View • How to Create and Manage Table Relationships • Review Questions
  • Create PivotTables • PivotTables • Flattened PivotTables • The PowerPivot Field List Pane • Creating Key Performance Indicators • How to Create a PivotTable
  • Create PivotCharts • PivotCharts • PivotChart Types • How to Create PivotCharts
  • Create Power Views • Customize the Ribbon • Power Views
  • Filter Data Using Slicers • Slicers • How to Filter Data Using Slicers
  • Present PivotTable Data Visually • Sparklines • Types of Sparklines • The Sparkline Tools – Design Contextual Tab • Conditional Formatting • Conditional Formats • How to Present PivotTable Data Visually
  • Manipulate PowerPivot Data Using DAX Functions • Measures • DAX Functions • DAX Variables • Aggregate Functions • How to Manipulate PowerPivot Data Using DAX Functions
  • Extract Data from Tables Using Functions • Filter Functions • How to Extract Data From Tables Using Functions
  • Work with Time Dependent Data • Time Intelligence Functions • Create a Date Table • How to Work with
  • Protect Reports • Workbook Protection • Worksheet Protection • How to Protect Reports
  • Save Reports in Different File Formats • File Formats • How to Save Reports in Different File Formats • Review Questions
  • Appendices • Keyboard Shortcut Quick Reference Sheet • Glossary • Index