Microsoft Excel Functions (Formulas)


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
COUNTIF, SUMIF, SUMIFS, and AVERAGEIF

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
ISERR, ISERROR, IFERROR

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

Section 5: Date and Time Functions
DAYS
WORKDAY
WORKDAY.INTL
NETWORKDAYS
Retrieving Dates in Excel
WEEKDAY
WEEKNUM
DATEDIF

Section 6: Statistical Functions
MEDIAN
MODE
RANK
COUNTBLANK

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

Section 8: Database Functions
DSUM, DCOUNT, DAVERAGE

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!

Functions (Formulas)
Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes
Date(s) Price Qty
August 24, 2020 9am to 4pm EDT $425.00 (CAD)*  
November 16, 2020 9am to 4pm EST $425.00 (CAD)*  
February 4, 2021 9am to 4pm EST $425.00 (CAD)*  

* 13% HST will be applied on checkout


Online registration closes two business days before the start of the class.
Questions?
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