EXCEL REPORTING ON DYNAMICS NAV

This module explains how to create basic NAV reports using Excel to connect to Dynamics NAV.

Lessons:

1. Plan the dashboard
2. Create the dashboard
   – Create and save a SQL data connection
   – Create a report
   – Create a filter
   – Create a slicer
   – Create a Timeline
3. Configure Excel Add-In
4. Practice
5. Useful links

Lab:

1. Create and save a SQL data connection
2. Create a report
3. Create a filter
4. Create a slicer
5. Create a Timeline
6. Configure Excel Add-in
7. Create report to display outstanding amount by customers

After completing this module, students will be able to:

1. Able to create basic dashboard by using Excel and SQL Data source.
2. Able to create basic dashboard that contains several reports and a filter using external data connections.

PRE-REQUISITE

1. Excel 2013 (and above) installed on Laptop/Notebook
2. Dynamics NAV with SQL DB
3. Bring your own Laptop/Notebook

For Who?

• IT Personnels and Anyone who needs to generate basic reports

Details:

• Date: 27-Apr-2017
• Time: 2.00pm to 5:30pm
• Venue: 20, Jalan Eco Cascadia, Taman Setia Eco Cascadia, 81100 JB

Register here :-