This series of Modules covers everything you need to know about Formulas and Functions - from the fundamentals of creating a formula to lots of good functions to use in your spreadsheets. It is intended for Introduction and Intermediate Level Users.
Your Instructor
Course Curriculum
Excel Formula and Functions
Available in
days
days
after you enroll
-
StartIntroduction to Calculations (8:22)
-
StartCreating Calculations (Formula) you can move or copy anywhere (14:22)
-
StartTop 10 Functions including SUM and AVERAGE, Text Functions and use Today's Date in Calculations (22:49)
-
StartLogical and Reference Functions including IF and VLOOKUP (29:09)
-
StartLinking Cells and Formula in Worksheet and Workbooks (4:53)
-
StartDate Calculations - when you need to use dates and or time in your calculations (19:38)
-
StartUsing Copy and Paste Special (12:58)
-
StartGoalseek - when you have the answer and need to work backwards (6:32)
-
StartPMT - Financial Function - Learn how to work out payments due on a loan (4:59)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.