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).
Learning Objectives
- Discover and describe the purpose of data vortices and decision matrices, and use them to manipulate spreadsheet data.
- Explore and describe the purpose of user-defined functions and arrays, and use them to manipulate spreadsheet data.
Prerequisites
Intermediate knowledge of spreadsheets such as Microsoft Excel, LibreOffice Calc, or Google Sheets. Basic knowledge of computer programming is helpful.
Advance Preparation: Access to a computer with speakers or headset. Alternatively, access to a computer and a telephone (for audio reception).