Step 2 - MS Excel - Introduction Functions and Formula Level 1 - IT0058
Who is this course for?
This course is for participants to would like to know how to create and use the 5 standard functions and use of formulas in MS Excel. This is a Level 1 course.
Aims
This course provides the skills and knowledge to create and work with the 5 standard functions and use of mathematical operators in analysing data.
Objectives
• Work with the 5 standard functions of - Sum, Average, Min, Max, Count
• Introduce the date functions of Today and Now
• Transforming the Count function to incorporate blank cells and text cells as a count number
• Work with Formulae (BiDMAS review)
• Understand when and how to use Absolute and Relative References
• Recognise common error messages and how to fix these issues
• Formulae Auditing
• Name Box (create, edit & delete)
• Reviewing large tables in excess of 200 rows
Trainer
Business Systems Trainer
Course Description
Virtual Training and Face to Face
Cost
£75.00
Apply
This course is available either as a Virtual or Face to Face course – which is better for you?
Face-to-Face – this is perfect if you'd rather take your time and ask more questions of the Trainer.
Virtual Training – this is ideal if you're comfortable working with computers, able to navigate between a variety of files and working with multiple windows. The course tends to be faster paced and with a little less interaction than the face-to-face option. For this type of training, it is a must that you have use of two monitors and use of a mouse (not the trackpad on a laptop).
If there are no dates available, please Register your interest.
How to Register your interest - to register your interest in this course please email psteamstrainingandsupport@lancashire.gov.uk - stating whether you'd prefer virtual or face-to-face training, and your name will be added to our waiting list. When we have a few names on the waiting list, we will schedule a course and contact you to advise of the next steps.