Introducing Formula & Calculations with Microsoft Excel

Who is this course for?

This specialist course presumes no prior knowledge and is for you if you are new to Microsoft’s Excel, never had any formal training or are unfamiliar carrying out calculations in Microsoft’s Excel.

What are the benefits

At the end of this workshop you will be able to create calculations and formulas, understand how a function is compiled and recognise and correct common error messages.

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

2 Hours

Course Content

Keyboard Shortcuts

  • Selecting worksheet elements
  • Navigating the worksheet

Understanding the Operators

  • Recognise formula operators
  • Create calculations using operators
  • Understand operator precedence

Working with Percentages

  • Find the percentage of a value
  • Use percentages in calculations

Functions

  • Total a range of values
  • Calculate the average
  • Find the lowest and highest value
  • Calculate how many cells have entries

Linking Formula Across Worksheets

  • Link cells across worksheets and workbooks
  • Create a summary sheet of values
  • Work with a 3D formula

Relative and Absolute Cell References

  • Understand the difference between cell references
  • Recognise Relative and Absolute cell references
  • Use Relative cell references
  • Create Absolute cell references

Common Error Messages

  • Recognise and understand common error messages
  • Correct formula errors

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us