Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Formulas Made Easy
Rating: 4.5 out of 5(67 ratings)
1,131 students

Excel Formulas Made Easy

Learn the essentials of Excel formulas in one hour
Created byJane Hames
Last updated 6/2017
English

What you'll 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.

Course content

7 sections • 12 lectures • 1h 4m total length

  • Introduction to this Course1: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.

  • Getting Started

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 this course is for:

  • 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.

Report abuse