Course Description:

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. 

Topics Covered: 

• Describe the purpose of data vortices and decision matrices, and use them to manipulate spreadsheet data. 
• Describe the purpose of user-defined functions and arrays, and use them to manipulate spreadsheet data.