Brief Introduction
Learn the essentials of Excel formulas in one hourDescription
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.
Requirements
- 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.
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019 **This course includes practice exercises and LIFETIME access**...
Microsoft Excel 2016 Training: Beginner to Intermediate
- 4.6
-
![]()
![]()
![]()
![]()
![]()
The Most Convenient Way to Boost Your Confidence And Learn Microsoft Excel 2016 Inside And Out. Learn Microsoft Excel 2016 Inside and Out...
Marketing Strategy Business Coach Certification6 Coaching
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Marketing Strategy Business Coaching Level 2 Grads Accredited Certification Marketing Strategy Business Coaching Listing Why is this important? How can you compete?...
No Nonsense Excel Pivot Tables Pro Course
- 4.2
-
![]()
![]()
![]()
![]()
![]()
With real Companies examples learn the best tricks of Excel Pivot Tables in Just 1 Hour. Improve Decision Making Skills. Practice with 6 real life practical examples....
