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.