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

Ultimate Excel Course #1 - Excel Formulas Made Easy: Get Up to Speed with Excel Formulas Fast (Skillshare)
Free Course
Categories
Effort
Certification
Languages
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Ultimate Excel Course #1 - Excel Formulas Made Easy: Get Up to Speed with Excel Formulas Fast (Skillshare)
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.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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.

For this class project I have multiple exercises for you to work through. Download the project-files folder to get access to the files used in the exercises.


Exercise 1 - Basic Formulas

1. Open the formulas-exercise1 spreadsheet.

2. Enter a formula in cell F4 to return the total in E4 minus a 10% discount. Copy the formula down to cell F17.

3. Enter a formula in cell H4 to return the number of days until the date due. Copy the formula down to cell H17.

4. Enter a SUM function in cell H1 to total the values in range F4:F17.



MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Free Course

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.