Advanced Spreadsheet Techniques in LibreOffice Calc

This course consists of two parts. In Part 1, we learn to create and use data vortices for analysis and summarization, and learn to create and use decision matrices to simplify complex formulas.

In Part 2, we 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 also learn how to return an entire array to the spreadsheet in one statement.

Topics Covered:
Part 1:

• Data Vortices
• Decision Matrices

Part 2:

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

Who Should Attend:
CPAs, accountants, and other financial professionals wanting to learn more advanced techniques for spreadsheet data manipulation.

Software and version used in course presentation:
In this course we use LibreOffice 7.x for our discussion and demonstrations. The code script language used will be LibreOffice Basic. (although users of various desktop versions currently supported by LibreOffice should benefit).