Register Now      202-747-5000
Road Map To Learning

Choose Your Learning Adventure:

Select from our standard “off-the-shelf” classes or build a course to target your learning goals. Ready to learn new skills? Contact Softek today!

Using Dynamic Arrays and Date/Time Functions in Excel

3 Hours

Course Overview

This instructor-led course is geared for experienced Excel users who want to explore more advanced functions. You will learn how to extract and manipulate components of a date or time, understand the benefits of a dynamic arrays, and explore how dynamic array functions can be used to efficiently analyze large (or even small) sets of data. Finally, you will discover the benefits of data validation and protecting a worksheet from unwanted changes or edits.

Course Objectives

  • Use the MONTH function to extract the month from a date
  • Use the NETWORKDAYS function to calculate the number of Workdays
  • Use the XLOOKUP function to retrieve data from a table
  • Use the UNIQUE function to display a list of values
  • Learn about data validation and protecting worksheets

Course Outline

Working with Date and Time Functions

  • Using the Month Function
  • Using the Day Function
  • Using the Year Function
  • Using the TEXT Function
  • Using the NETWORKDAYS Function

Working with Dynamic Array Functions

  • Understanding Arrays
  • Traditional Functions
  • Working with Dynamic Array Functions
  • SPILL Range
  • Using the SEQUENCE Function
  • Using the XLOOKUP Function
  • Using the UNIQUE Function
  • Using the SORT Function
  • Using the FILTER Function


Setting Data Validation and Protection

  • Validating Data Entry
  • Applying Data Validation
  • Testing Data Validation
  • Understanding Worksheet Protection
  • Unlocking Cells
  • Protecting Worksheets
  • Unprotecting Worksheets



Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats. Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Private Group Class: Live Virtual
1-4 students $850
5-8 students $1000
9-12 students* $1100
*$35 per additional student
Private Group Class: At Your Location
1-4 students $1100
5-8 students $1250
9-12 students* $1350
*$35 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).


Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.

Why Choose Softek?

  • Live, virtual or in-person training
  • Instructors with 15+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee