course

Advanced Spreadsheet Techniques in Microsoft Excel

(18)
4.38889
40 Enrolled
2.5 Hours (On-Demand)
2.5 CPE  

This course is a premium course it can be accessed either by individual purchase or through a premium subscription

Purchase this course | $90

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).

Learning Objectives
  • Describe the purpose of data vortices, decision matrices, user-defined functions, and arrays, and use them to manipulate spreadsheet data.
Last updated/reviewed: March 15, 2024
3 Reviews (18 ratings)

Reviews

4
Anonymous Author
It was very informative. I appreciate the ability to review information to apply to worksheets that I may need to create in the future.
4
Anonymous Author
Nice introduction to the possibilities of arrays. I would love to see a more in depth course covering this material.
4
Member's Profile
This course has good contents that can be used for my job
Prerequisites
Course Complexity: Intermediate
- Intermediate knowledge of spreadsheets such as Microsoft Excel, LibreOffice Calc, or Google Sheets
- Basic knowledge of computer programming is helpful
Advance Preparation: Access to a computer with speakers or headset. Alternatively, access to a computer and a telephone (for audio reception).
Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Advanced Spreadsheet Techniques in Microsoft Excel1:36
Data Vortices
  Data Vortices - Part 112:08
  Data Vortices - Part 28:12
Decision Matrices
  Decision Matrices14:20
User-Defined Functions
  User Defined Functions - Part 113:16
  User Defined Functions - Part 212:52
  UDFs Advantages and Disadvantages3:40
Arrays
  Arrays - Part 115:04
  Arrays - Part 214:30
Conclusion
  Summary0:56
CONTINUOUS PLAY
  Advanced Spreadsheet Techniques in Microsoft Excel1:36:34
SUPPORTING MATERIAL
  Slides: Advanced Spreadsheet Techniques in Microsoft ExcelPDF
  Advanced Spreadsheet Techniques in Microsoft Excel GlossaryPDF
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam