Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
10 Videos (1h 14m)
• Introduction

2:44
• Introduction to Formulas - Writing Your First Excel Formulas

8:39
• The Order of Calculation - BODMAS

5:42
• Formulas for Calculating Percentages

8:24
• Unleash the Power of Excel Functions

10:39
• Referencing other Sheets and Workbooks

10:43
• Calculating Date Difference - Including Working Days Only

9:18

6:47
• The COUNTIF Function - An Incredibly Useful Function

10:09
• Thank you

0:41

This is class #1 in a series called the Ultimate Excel Course.

When you first start to learn Excel, the formulas are always the most daunting aspect. This class will break through those barriers as it explains everything you need to know to get started with Excel formulas in plain English.

In just 1 hour you will understand the different parts that make up a formula and will be able to write some typical formulas and functions. This class builds a solid foundation for further learning from other classes, or from your everyday work.

The Excel Formulas for Beginners files are provided in the Projects section of this class to download, so that you may follow me through each lesson.

There are also plenty of project files provided so that you may practice and test the skills that you have learnt.

If you have any questions, please do ask through the discussion area. I am happy to help.

What you will learn;

• What makes up a formula and how to write them.
• 8 useful Excel functions.
• How to reference cells in different worksheets, and even different workbooks.
• To calculate the difference between two dates including just working days.
• Calculating percentages for working out discounts, commissions, percentage increase/decrease.
• What absolute cell references are, why they so important and how to use them.

Please note that this is class #1 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Power Up your Excel Formula Skills Fast

8 of 8 students recommend

David Symington
Very clear and easy to understand.
Scott Rushlow
Very nice course! Thank you!
Anna Lynd

Live simply. Care deeply. Help cheerfully.

105

Students

--

Projects

Alan Murray

IT Trainer, Coffee Lover and Lifelong learner

Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 17 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.

I set up Computergaga about 8 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.

I have a real passion for Excel and I hope that it comes across in my classes. I believe that it helps if you enjoy what you are learning.

I currently live in Ipswich, on the east coast of England. I am married with two beautiful children. So they take up most of my time away from Excel. If I'm not with my family or Excel, I can probably be found running.

View the latest FREE Excel Tips >>

http://www.computergaga.com/blog/

Speak to you soon. Have fun learning.

Alan