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. 

Aim(s)

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

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