Advanced Spreadsheet Techniques in Microsoft Excel - A/V |
|
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:
• Data Vortices
• Decision Matrices
• User-defined Functions
• Arrays in spreadsheets
• Arrays in code script
|
|
Learning Objectives: |
|
Upon successful completion of this course, participants will be able to:
- Describe the purpose of data vortices, decision matrices, user-defined functions, and arrays, and use them to manipulate spreadsheet data.
|
|
Course Number: |
KJ02 |
NASBA Field of Study: |
Finance |
Level: |
Intermediate |
Author/Instructor: |
Keith Jordan |
Publication Date: |
February 2024 |
|
CPE Credits: |
2 |
|
Program Prerequisites: |
• Intermediate knowledge of spreadsheets such as Microsoft Excel, LibreOffice Calc, or Google Sheets
• Basic knowledge of computer programming is helpful
|
|
Advanced Preparation: |
Access to a computer with speakers or headset |
Software and Version used: |
Microsoft Excel 2019 (although users of various desktop versions currently supported by Microsoft should benefit). |
|
0 Comments