Syntellis Academy Hands-On Lab: Advanced Spreadsheet Reporting
When
2-Day Online Course, Group Internet Based
Available Dates
- November 28 – 29, 2023
- February 20 – 21, 2024
Registration
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
Cost
$750
Audience
Primary Users, Data Analysts, Report Writers, Report Modifiers
Prerequisites
Axiom Essentials and Axiom Intelligence (Live or Virtual)
OR
Axiom Academy Certification - Fundamentals and Report Writing (before April 2022)
Advanced Preparation
None
Field of Study
Computer Software and Applications
Program Level
Intermediate
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 syntellisacademy@syntellis.com.
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: www.nasbaregistry.org