Integrated MRP solutions from the experts >

Off the shelf professional e-Commerce web store that grows with you

Get the Office 365 - Free Trial! Try now for 1 month with no obligation.

PowerPivot and NAV Training Course

Learn how PowerPivot interacts with data from Dynamics NAV


Business Intelligence reporting is important in any company, and NAV’s integration with Microsoft Office is the perfect platform for this. In the PowerPivot and NAV Course you will learn how to expose NAV data to PowerPivot using NAV Queries and Web Services and to use PowerPivot to analyse your data into helpful tables and charts. The PowerPivot and NAV course is useful for anyone wanting to learn how to use PowerPivot, not just NAV users and can be extended for reporting on other applications.


Must have a good working knowledge of Dynamics NAV and Microsoft Excel. The course will be conducted in NAV 2017 and Excel 2016.


Our scheduled training courses are £250.00 per person per day. If you are coming to our site, parking and refreshments will be provided.

Terms & Conditions

For details on what to expect, dress code and general terms and conditions, please see our standard training T&Cs.

Terms & Conditions



Course Overview

The following is a list of the subjects covered in the course. For more details please download the course overview. 

  • Dynamics NAV Connections
  • What are the Different Power Add-Ins
  • PowerPivot
  • Importing Your Data and the Data Model
  • Creating a Data Table
  • Creating PivotTables with PowerPivot
  • Creating Simple Calculated Columns
  • Using Slicers to Filter Data
  • Using PivotCharts and Dashboards
  • Using PowerView and PowerMap

Course Outline

Book Now!

Please fill in the following form to book onto this course. 

Booking Form


For more info contact us
+44 (0) 2380 982283


Other Pages In This Section