Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC) (Video) (Course Id 2277)

• Who is this course for?
  This course is designed for CPAs, accountants, or any professionals needing Continuing Professional Education (CPE), particularly those with intermediate spreadsheet knowledge and an interest in using LibreOffice Calc.

• What is this course about or what problem does this course solve?
  The course focuses on enhancing spreadsheet capabilities in LibreOffice Calc by teaching advanced techniques such as data vortices, decision matrices, array functions, and user-defined functions.

• How can the knowledge from this course be used?
  Learners can apply the skills gained to perform advanced data analysis, simplify complex formulas, and implement custom functions for more powerful and efficient spreadsheet operations.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  It equips finance professionals with advanced tools to streamline their spreadsheet tasks, enabling better data handling and more informed decision-making within financial and business environments.

• When is this course relevant or timely?
  This course is relevant now as it was released in 2024 and addresses current needs for advanced spreadsheet functionality using free and open-source software like LibreOffice Calc.

• How is a course like this consumed or used?
  The course is delivered via QAS self-study in video and text format, includes review and final exam questions, and requires a computer with audio capability for completion.

Part 1

• Learn to create and use data vortices for analysis and summarization,;and
• Learn to create and use decision matrices to simplify complex formulas.

Part 2

• Learn how LibreOffice Calc array functions work and how to create and use them to enhance your calculations;
• Learn how to create and use user-defined functions and arrays in code script to gain additional functionality and perform complex operations; and
• Learn how to return an entire array to the spreadsheet in one statement.

In this course we will use LibreOffice Calc for our discussion and demonstrations. The code script language used will be LibreOffice Basic.

Video - NASBA QAS - Text - NASBA Registry - 2277

Course Learning Objectives

• Data Vortices
• Decision Matrices

• User-defined Functions
• Arrays in spreadsheets
• Arrays in code script

Chapter 1 - Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC)

Chapter 1 Review Questions

Glossary of Terms