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 use the desktop version of Microsoft Excel for our discussion and demonstrations. The code script language used will be Visual Basic for Applications (VBA).
Who Should Attend:
Practitioners wanting to learn more advanced techniques for spreadsheet data manipulation.
Topics Covered:
- Data Vortices
- Decision Matrices
- User-defined Functions
- Arrays in spreadsheets
- Arrays in code script
Software and version used in course presentation:
Microsoft Excel 2019 (although users of various desktop versions currently supported by Microsoft should benefit).
