Skip to the content

DC020 - PowerPivot and NAV Training Course


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 Power Pivot using NAV Queries and Web Services and to use PowerPivot to analyse your data into helpful pivot 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.

Course Overview

The following is a list of the subjects covered in the course. 

  • 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


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

Attend This Course

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

Booking Form


What will we do with your data? See our Privacy Policy for more information.

Use Your Rewards Here!

Reward Scheme for Partners

If you have earned credit on the Customer Partner Rewards Scheme, you can use it here!

As part of being a customer of Dynamics Consultants, you will receive reward credit when you renew your support contract. This credit can be spend on a range of services, including training, SQL server healthchecks and user shadowing. 

Held at our Southampton Offices

40 Locks Heath Centre
Centre Way
Locks Heath
SO31 6DX

Partner with the Experts

With over 300 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licensing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.