ONLINE - Excel Functions Boot Camp 2/11-12/2026

Length/CPE Hours

14 hours (2 days)

Class Time

Day 1 - 8:30 a.m. – 4:15 p.m. Central Time
Day 2 - 8:30 a.m. – 4:15 p.m. Central Time

One-hour break for lunch and a 15-minute morning and afternoon break.

Method of Delivery

This class will be held online using GoToMeeting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoToMeeting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. It will usually be sent after the cancellation deadline with which is 5 days prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoToMeeting subscription to participate.

The web browser client will download automatically when you start or join your first GoToMeeting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

Course Description

Microsoft Excel has over 480 functions divided into 14 categories. My 30+ years of experience in teaching Excel has shown me that most Excel students know less than 15 functions. The purpose of this class is to expose students to a variety of functions that could improve their daily use of Excel.

Microsoft continually introduces new functions. Many of the new Excel 365 functions “spill” or automatically return multiple results into neighboring cells. These are called dynamic array functions.

This class is not designed to teach all the functions in Excel, but to focus on functions that can be useful to accountants, auditors and heavy users of Excel. This class is designed for the intermediate to advanced Excel user that wants to expand their knowledge of Excel functions. You must have Office 365 to be able to follow along with the examples in this class.

Course Objectives

Upon completion of this course, participants will be aware of the new Excel 365 functions and many standard functions that can help in everyday use of Excel. Users will be able to implement many of the topics in the class right away in their worksheets. They can reference the book and class files to become more proficient in using these functions.

FORMULA BASICS AND UNDERSTANDING FUNCTIONS

• Understanding the Structure of Functions
• Work with the Function Library and the Insert Function Dialog Box
• Learn How and When to use Absolute and Mixed References
• Use the Formula Auditing Features

LOGICAL FUNCTIONS

• How to write and IF statement and nest IF statements
• NEW IFS statement
• Using IFERROR
• USE the AND OR FUNCTIONS

LOOKUP AND REFERENCE FUNCTIONS

• Using VLOOKUP
• XLOOKUP functions (OFFICE 365 Users)
• UNDERSTAND INDIRECT and use it with Data Validation TEXT FUNCTIONS
• Use TRIM to remove extra spaces
• USE TEXT to convert numbers
• Join Text using CONCATENATE, CONCAT and TEXTJOIN
• Work with FORMULATEXT
• Work with TEXTAFTER, TEXTBEFORE, and TEXTSPLIT

DATE FUNCTIONS

• Understand date serial values
• Use the DATE function to convert a date stored incorrectly
• Use DATEDIF to calculate age or hire dates
• Work with TODAY() AND NOW() for current date and time
• Use NETWORKINGDAYS to calculate whole workdays
• Understand WEEKDAY and how it can be used with conditional formatting
• Work with WORKDAY to calculate number of days from a start date excluding weekend and holidays

DYNAMIC ARRAY FUNCTIONS

• What is an Array?
• SORT - Sorts the contents of a range or array.
• SORTBY - Sorts the contents of a range or array based on the values in a corresponding range or array.
• FILTER - Filters a range of data based on criteria you define.
• UNIQUE - Returns a list of unique values in a list or range.
• DROP - Excludes a specified number of rows or columns from the start or end of an array.
• TAKE - Returns a specified number of contiguous rows or columns from the start or end of an array.
• TOCOL - Returns the array in a single column.
• TOROW - Returns the array in a single row.
• TRANSPOSE - Returns the transpose of an array.

MATH, TRIG AND LOGICAL FUNCTIONS

• SEQUENCE – How to use the Sequence Function instead of filling a series.
• RANDARRAY vs RAND or RANDBEWTWEEN

Prerequisites

This is an intermediate to advanced class. Users should have taken an Excel Level 1 course, or equivalent working knowledge of the software.

Cancellation Deadline

The cancellation deadline is 5 business days prior to the class. If you are unable to attend, you may send a substitute. If you are a "no show" or you do not send a substitute you will be charged full price for the class.

Cloud Training Services will consider emergency situations such as a death in the family, illness, and weather, and will make every attempt to work with the person in the event of an emergency.