Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 4 Minute(s)
Language
English
Taught by
Jane Hames
Rating
Course Overview
Learn the essentials of Excel formulas in one hour
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.
Course Content
- 1 section(s)
- 12 lecture(s)
- Section 1 Introduction
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.
Skills covered in this course
Reviews
-
CColleen Smith
I know a lot of the basic formulas and auto functions. I look forward to creating more difficult ones
-
ZZee WC
Great course with tons of helpful info! I'm ready for the next level now!
-
MMarnye Langer
My first Udemy course, but not my last. I am fairly experienced in Excel and was looking for some specific skills. I got those and more. I learned a bunch of little tips and alternate ways of doing things, plus I added to the skills. The instructor was clear, on point, and gave good instruction. The examples were simple and allowed you to focus on the skill. Thank you to Jane Hames! And I loved the British accent!
-
AAllan
The course is great! Very easy to understand.
