Step 8 - MS Excel All About Dates Level 3 - IT0112
Who is this course for?
This course is for MS Excel Users who already know and regularly work with the traditional functions including the IFs function, if you are confident working with functions, this course is for you. This is a Level 3 course. If you have not used MS Excel for more than 4 years, please do a recap with the Level 1 and/or Level 2 and Level 3 courses for Functions & Formulas.
Aim(s)
This course provides the skills and knowledge to use a variety of date functions which include Date Difference, End of Month, manipulating the Date Functionality and working with Days to name a few Date Functions. Use of conditional formatting to analyse information. The use of Ifs will be used in converting numerals to days.
Objectives
- Working with Ifs
- Date Functions of:
- Day, Month, Year, Networkdays, Date Difference, Workday, Weekday, EOMonth, Date, EDate
- Use of Conditional Formulas with Functions
Trainer
Business Systems Trainer
Course Description
Virtual Training
Course Cost
£75.00
Apply
Please note, if there are no dates published, please can you Register your interest.
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 a 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).
How to Register your interest - to register your interest in this course please email psteamstrainingandsupport@lancashire.gov.uk – 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.
All prospective participants please complete the mandatory pre-requisite Skills Checklist prior to course application. See below link for the checklist. You will not hear from the Trainer unless they deem that you have not met the skills required for this course. Confirmation of a place on the course will be subject to the Trainer's assessment of the data provided on the checklist. Joining Instructions and course data files will be sent out 2 weeks or thereabouts, prior to the course taking place.