Ultimate Excel Course #1 - Excel Formulas Made Easy: Get Up to Speed with Excel Formulas Fast | Alan Murray | Skillshare

# Ultimate Excel Course #1 - Excel Formulas Made Easy: Get Up to Speed with Excel Formulas Fast

#### Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
10 Lessons (1h 11m)
• 1. Introduction

2:44
• 2. Introduction to Formulas - Writing your First Excel Formulas

7:50
• 3. The Order of Calculation - BODMAS

3:13
• 4. Formulas for Calculating Percentages

7:54
• 5. Unleash the Power of Excel Functions

8:43
• 6. Referencing other Sheets and Workbooks

11:45
• 7. Calculating Date Difference including Working Days Only

8:09
• 8. Understanding Absolute Cell Addresses

6:22
• 9. The COUNTIF Function - An Incredibly Useful Function

13:12
• 10. Thank you

0:41
23 students are watching this class

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

Class #6 - Validating and Protecting Excel Data

Class #7 -Â Advanced Formulas for Analysing Data

Class #12 -Â Get & Transform Data with Power Query

Class #13 -Â Introduction to the Data Model and PowerPivot