Syntellis Academy Hands-On Lab: Advanced Spreadsheet Reporting



2-Day Online Course, Group Internet Based

Available Dates

  • February 20 – 21, 2024
  • June 4 – 5, 2024


You can register for the course here.


Course Description

Axiom software provides enhanced spreadsheets to transform data into insightful reports and dashboards. In this course that expands on the spreadsheet fundamentals learned in Axiom Intelligence, you will develop best practices in creating robust spreadsheet reports using advanced techniques such as nesting Axiom queries to dynamically group and build data structures in a report. Additionally, you will learn to use Axiom diagnostic tools to troubleshoot and tune spreadsheets for high-performance and usability. 


Course Length and Delivery Method

2 Day, Group Internet Based






Primary Users, Data Analysts, Report Writers, Report Modifiers



Axiom Essentials and Axiom Intelligence (Live or Virtual)
Axiom Academy Certification - Fundamentals and Report Writing (before April 2022)


Advanced Preparation



Field of Study

Computer Software and Applications


Program Level



CPE Credits

Earn up to 4 CPE credits


Learning Objectives

Module 1: Advanced Spreadsheet Reports

  • Define advanced spreadsheet reports and contrast with other Axiom intelligence files
  • Identify use cases for advanced spreadsheet reports
  • List best practices for creating efficient and interactive spreadsheet reports

Module 2: Variables and Data Lookups

  • Configure the Variables sheet
  • Differentiate Data Lookups from Axiom Queries
  • Add Data Lookups to a report

Module 3: Nested and Parallel Queries

  • Identify use cases for multiple queries
  • Create reports with Nested and Parallel Queries
  • Decipher a complex report that uses multiple queries

Module 4: Stacked and Horizontal Queries

  • Identify use cases for Stacked and Horizontal Queries
  • Create reports that use Stacked queries
  • Use a Horizontal Query to populate a field definition row

Module 5: Axiom diagnostic tools

  • Enable Axiom diagnostic tools
  • Generate a diagnostic report
  • List best practices when using spreadsheet formulas
  • Troubleshoot and optimize a slow performing report 


For more information regarding administrative policies such as complaints and refunds, please contact

Syntellis Performance Solutions, LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: