Loading...

Course Description

This course concentrates on Excel functions and formulas. Look at commonly used text and data functions, including changing the case of text, combining text cell contents (e.g., first and last names), and comparing cell contents. Work with date and time functions and logical functions. Other topics will include using simple form fields to select items from a list (note that this will not cover creation of custom forms, as that requires VBA), using the formula editing toolbar to check your data and solve formula errors, and working with arrays.

By the end of this course, you will be able to: 

  • Creating and using Mega Formulas 

  • Working with Text functions 

  • Working with Date and Time functions 

  • Using Information functions 

  • Alternate uses of Statistic functions 

  • Using Lookup and Reference functions 

  • Using a Form Control to select lookup values 

  • Exploring Array formulas and constants 

Prerequisites

Intermediate Applications of Excel or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel Formulas and Functions
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
May 31, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
May 29, 2024
Transfer Request Deadline
May 29, 2024
Section Title
Excel Formulas and Functions
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
May 31, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
May 29, 2024
Transfer Request Deadline
May 29, 2024
Section Title
Excel Formulas and Functions
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Jun 26, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 24, 2024
Transfer Request Deadline
Jun 24, 2024
Section Title
Excel Formulas and Functions
Type
Discussion
Days
W
Time
8:30AM to 4:00PM
Dates
Jun 26, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 24, 2024
Transfer Request Deadline
Jun 24, 2024
Required fields are indicated by .