Excel Formulas Made Easy
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Formulas Made Easy to your Wishlist.

Add to Wishlist

Excel Formulas Made Easy

Learn the essentials of Excel formulas in one hour
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 13 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Confidently build, edit and copy formulas to carry out calculations in Excel.
  • Design worksheets that will help you to work more quickly and efficiently.
  • Understand how cell references, brackets and named functions work.
  • Build formulas that link data between worksheets and workbooks.
View Curriculum
Requirements
  • You should be able to perform basic data entry in Excel.
  • You will need Excel installed to enable you to carry out the practical exercises in your own time.
Description

This course will enable you to get to grips with Excel formulas, allowing you to perform calculations within Excel quickly and easily. 

You will learn how to:

  • Understand the principles and 'building blocks' of Excel formulas.
  • Use both mouse and keyboard commands to construct a formula.
  • Perform calculations by using both standard mathematical symbols and common built-in functions.
  • Copy formulas to different parts of your worksheet.
  • Make use of brackets to ensure calculations are carried out in the correct order.
  • Differentiate between relative and absolute cell references, and how to use each of these so your formulas always refer to the correct cells on your worksheet.
  • Refer to cells on different worksheets in your formulas, or to cells in completely separate files.
  • Pick up handy tips to save time and make life easier when you use Excel. 

The course includes :

  • Practical exercises using Excel workbooks that you can download.
  • In-depth quizzes to test your understanding and help to embed your learning.
  • Useful reference guides to download and keep on your desk.

This course is presented by Jane Hames, lead IT trainer at Glide Training. Jane has over twenty years' experience in delivering Excel training to users of all levels and from a variety of backgrounds. 


Who is the target audience?
  • This course is for Excel users who want to learn the essentials of formulas.
  • It won't be full of jargon or "techy-speak", so if you want to learn from someone who understands first hand how overwhelming technology can be, then this is for you.
  • You will gain a thorough understanding of how to use formulas for performing calculations on a spreadsheet, without diving into more advanced statistical or data processing functions.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:04:20
+
Introduction
1 Lecture 01:15

Here you'll find an overview of the course, the areas we'll be covering, and what you can expect to be able to achieve at the end of the course. NOTE: Download the Formulas Reference Sheet and keep it with you throughout the course. It will then become a valuable reference guide for after you have completed this course.

Preview 01:15

A couple of quick questions to ease you in gently!

Getting Started
2 questions
+
Building an Excel formula - the basics
2 Lectures 15:18

Make sure you're on top of the basics before moving forwards with this course!

Key Principles
8 questions

Building a Formula on the Excel worksheet
09:51

You might want to look at the workbook attached to Lecture 3 in order to get some hands-on experience before taking this quiz. Or if you're confident, jump straight in!

Building Formulas
7 questions
+
Adding more functionality to formulas
2 Lectures 06:02
Common Functions
02:09

There are large numbers of named functions accessible from within Excel. 

We couldn't possibly cover all of them in a course such as this, but here is a quick test on the common functions that we looked at in the previous lecture.

Using Common Functions
7 questions

Adding text to formulas
03:53

Combining text and numbers within formulas can be very useful, especially when using Excel for doing things such as generating reports. Make sure you're able to do this properly!

Adding text to formulas
5 questions
+
Brackets - how they affect calculations
2 Lectures 06:57
When to use Brackets
03:19

Put your understanding of calculation order and brackets to the test! 

We'll start with a question on the theory, then move on to some practical examples which will become more difficult as they go on. 

Practicing with Brackets
7 questions

Nested Brackets
03:38

This quiz is a bit shorter as it applies only to the extra things you need to bear in mind when using multiple sets of brackets

Understanding Nested Brackets
3 questions
+
Absolute and Relative cell references
2 Lectures 10:41
Absolute Cell References
06:43

Some exercises to test your understanding of the difference between absolute and relative cell references. 

Understanding Absolute Cell References
7 questions

Partial Absolute Cell References
03:58

Test yourself on using partial absolute cell references to fix columns or rows

Understanding partial absolute cell references
6 questions
+
Linking between Worksheets and Workbooks
2 Lectures 18:42
Linking Between Worksheets
07:50

Sometimes you might need to refer to cells on other worksheets, not just the one that's open in front of you. 

Linking between Worksheets
6 questions

Linking Between Workbooks
10:52

There may be times that the cells you need to refer to in your formulas are in different workbook files altogether.

Linking between Workbooks
6 questions
+
Bonus Tips
1 Lecture 05:25
About the Instructor
Jane Hames
5.0 Average rating
1 Review
6 Students
1 Course
Microsoft Office Training Specialist

Coming from a creative background, I explain software use in a “non-techy” way. I very much focus on the big picture benefits of software use in order to save you time and get more value from the software.

I have been a trainer since 1998 working mainly in the UK and occasionally in Europe. During that time, I have worked with clients from a wide range of industries including, finance, legal, creative, engineering, charities, schools, colleges, government, healthcare, police and more.

I spend several days a week delivering face to face live training and regularly get feedback about how easy I am to learn from and how the training is actually really engaging and enjoyable! My courses are short because I appreciate that not everyone wants to learn everything that the software has to offer. You can pick what's most important to you at the time and select an appropriate course.

Of course, there are lots of people who love Microsoft Office but there are many others who just want to make it work for them and make life easier for themselves. My aim in all of my training is help you to work more quickly, efficiently and with less frustration.

Thanks for stopping by and enjoy your training!

Frank Hames
5.0 Average rating
1 Review
6 Students
1 Course
Director at Glide Training

I am one of the Directors at Glide Training, responsible for our online presence and for all the online technology that our company makes use of. 

I have over fifteen years' experience in training people how to make best use of software, business systems, online and offline marketing in order to achieve success in the workplace.