Microsoft Excel Advanced Formulas and Functions

Course Length: 6 hours (1 day)
Excel functions are the key to providing financial results from data. There are hundreds of Excel functions, each with their own purpose and usefulness yet with common elements that make learning new functions easier.

The purpose of this course is to learn how to create and apply Excel functions to generate mathematical results from data.

Learning Objectives:
After completing this course, students will be able to:
  • Identify which function to use to generate results
  • Employ a number of strategies for creating functions
  • Build their own functions using the fx tool
  • Add multiple worksheets together
  • Utilize array formulas
Target Student:
This course is designed for Excel users with some knowledge of entering financial data but would like to explore more mathematical functions.

Course Outline:
Section 1: Working with Basic Formulas, Functions and Named Ranges
Creating Basic Functions
Absolute & Relative Cell References
Updating Values without Formulas (Paste Special)
Displaying & Highlighting Formulas
Named Ranges
Logical Functions
IF logical tests

Section 2: Text Functions
Locating Data with FIND, SEARCH, EXACT
Extracting Data with LEFT, RIGHT, and MID
Flash Fill
Combine Data from Different Cells using CONCATENATE
Changing the Case of Text using PROPER, UPPER, and LOWER

Section 3: Information Functions

Section 4: Lookup Functions
MATCH (2 list comparison)
INDEX (pull info from a list based on column and row headings)

Section 5: Date and Time Functions
Retrieving Dates in Excel

Section 6: Statistical Functions

Section 7: Math Functions and Arrays
Basic Array Formulas
Array Formulas with Basic Functions
Array Formulas with VLookup

Section 8: Database Functions

This Course Comes With

PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Excel Advanced
Formulas and Functions
Guaranteed to run
Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes
Date(s) Price Qty
January 19, 2023 9am to 4pm ET $425.00 (CAD)*  
April 21, 2023 9am to 4pm ET $425.00 (CAD)*  

* 13% HST will be applied on checkout

Online registration closes two business days before the start of the class.
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here