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.

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
Excel Functions (Formulas)

Register for this class

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

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!

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

Video Library

Sign up to our video library subscription and review an extensive selection of training videos to refresh your memory
Register for this class here
Learn more about each course here
Contact us for more information here