Course Description:

Learn to create and use data vortices for analysis and summarization, and decision matrices to simplify complex formulas. Learn how Microsoft Excel 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.

In this course we will use the desktop version of Microsoft Excel for our discussion and demonstrations. The code script language used will be Visual Basic for Applications (VBA).

Topics Covered: 

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