Formulas & Functions

$97
BUY NOW
Excel Functions

Discover the must-know Excel Formulas and Functions

Put your calculator in the bin, let Excel do it all and save yourself hours

30 Lessons

 
}

4.5 Hours

 
t

3 Quizzes

 

Associate Certification

 

What is Formulas and Functions?

 

A step-by-step guide for Excel Beginners

30 bite-size videos introduce you to the Formulas and Functions you need to know. Watch anytime, anywhere, at your own pace.

Delivered by Experts

We walk you through the entire process so you know exactly what to do and you feel confident implementing every step.

Practice and check your knowledge

Downloadable Practice files make it easy to understand. Take the online quiz to confirm your new Excel knowledge.

Prove to others

Add CPD Certified Excel Certification to your Resume to prove you have the skills to succeed and help you land that promotion.

Apprentice Certification

Click an icon to see what's covered

 
Navigate Excel
The MAX Function

Module 1 : Essential Formula

 

The Top 8 Formula that you’ll use every day

We start at the beginning and walk you step by step through the most used Excel Formulas

Understand Operators

Know how to turn Excel into your super-efficient calculator to solve basic mathematical operations

Know how to Automate Formula

Save time when you know how to apply formula across worksheets

Module 2 : Defining and Auditing Formula

 

Absolute and Relative Referencing

Know how to copy formula across multiple cells

Name Manager

Understand why defining a name for cells is important

Formula Auditing

Discover how and why you should be auditing formula

The Watch Window and Calculation Options 

Find out why the Watch window makes it convenient to inspect formula

Formula Auditing
Formula Auditing

Our Excel Program just works ...

Check out what some of our customers have said
Luis

Senior System Administrator, FIS

Amanda

Talent Manager, U.S. Bank Home Mortgage

Shawn

Program Assistant, West Virginia

IF AND Statement
IF AND Statement

Module 3 : Functions

 

IF Statements

Be able to use IF Statements, one of the most popular instructions among the Decision Making Statements

VLOOKUP and HLOOKUP

When you need to look in a single row or column to find a value from a second row or column, you need to a LOOKUP. Find out how in this section

Module 4 : Advanced Functions

 

Using Excel’s Quick Analysis Tool

With the Quick Analysis Tool you can create different Chart types such as Scattered, Clustered and Stacked. We show you how.

Date and Database Functions

If you need to find information using given criteria, you need to know Functions like DSUM, DCOUNT and DVAR

Calculation Options
Calculation Options

Enroll now and add Excel Certification to your resume