Session Description

For experienced users of Aeries Query, covers applying advanced filters, hiding columns, and applying other tricks to a query statement. Also, will cover pivot tables in Excel and importing and exporting data using Excel with a focus on data evaluation.

Session Content

• Exporting Query results to Excel and Access
• Using various Access tools to analyze and manipulate data
• Using Excel to create Pivot Tables, Pivot Charts, and filter data using Slicers
• Using Access to import Aeries created Excel Files to create Cross Tab and Multiple Table Queries

Related Documentation

PDF documentation for this session is attached.