Base Management Reporting with Jet Essentials 2011
(Duration: 1 Day)
Course Aims
To enable the delegate to have a good understanding of the specialist Jet Essentials functionality and its ability to create and send superior reports in MS Excel, directly from live data in the NAV database, with colour, charts and graphs as required..
Who should attend?
All 'Reporting Champions'
Pre-Requisites
Delegates should have a good working knowledge of both Navision and Excel.
Course Content:
Introduction to Jet Essentials 2011
· Static Reports
· Dynamic Reports
Creating Static Reports
· Using the GL command
· Using Excel cell addressing modes
· Construct date filters using Excel date formulas
· Using the NL command for data retrieval
Building Dynamic Format Reports
· Building Simple lists
· Replicators
· Unique values
· Using the NL and NF commands together
· Sorting with the NL command
· Working with Excel's formula ranges
· Conditionally hiding data
Intermediate Dynamic Reports
· Nested Replicators
· Grouping and sub-totalling data by multiple criteria
Scheduling and distributing reports to end-users
C/Front & NAV
Further sources of Jet Essentials training & support
If you would like more information regarding Jet training then please do not hesitate to email us at web@cosl.co.uk or call 01223 422600