Self Study

Stay up to date on the latest changes...

Shop course
/ Shop course
Advanced Spreadsheet Techniques in Microsoft Excel - A/V

Advanced Spreadsheet Techniques in Microsoft Excel - A/V

$39.95$39.95
  • SKU : KJ02
  • OUR PRICE :$39.95
  • CREDIT HOURS : 2
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).

The Wait is Over

SIGNUP TODAY AND RECEIVE 8 HOURS OF FREE CPE CREDIT

How may we Help you?

Info@cpecredit.com 1-800-545-7601

Connect with us

Copyright © 2018 CPE Credit. All Rights Reserved.

cross

// 15-Aprial 19 discount pop