Discover the must-know Excel Formulas and Functions
30 Lessons
4.5 Hours
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.
Click an icon to see what's covered
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
Our Excel Program just works ...
Amazing !! I love the tutorials and even though I’ve been using Excel for years, I now have many new tricks that will make my job a lot easier.
Great and very easy to follow. If you need to go over everything more than once, you can! Plus, the certificate looks great on my resume!
Very helpful, instructions are super easy and layout is step by step… I will purchase from them again – thumbs up and 5 star rating from me!!!
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
