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.