Skip to the content

DC020 - PowerPivot and NAV Training Course

Introduction

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

Pre-requisites

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

Prices

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

Book Now!

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.

I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our team

Lee Crowhurst, Technical Director

Partner with the Experts

With over 200 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 licencing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.