Excel Functions (Formulas)

Course length: 6hrs (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.

Course 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.

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

What You Get:

Training includes 1 course Tip Sheet, a Certificate of completion, and a voucher for 30 days of After Training Support