MS Excel All About Dates & Times Level 2/3 - IT0084
Who is this course for?
This course is for MS Excel Users who already know and regularly work with the traditional functions including the IF function, if you are confident working with functions, this course is for you. This is a Level 2/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 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. As for Times reviewing various time formats, together with standard formulas and functions to add, subtract times, formatting of time between 24 hours, 12 hour and numbers, concluding with nested IF's for worksheet functions and highlighting via conditional formatting to analyse information
Objectives
- Working with If(and(
- Date Functions of:
- Day, Month, Year, Networkdays, Date Difference, Workday, Weekday, EOMonth, Date, EDate
- Time Formatting (12 hour, 24 hour & General)
- Use of Conditional Formulas with Functions
Trainer
Business Systems Trainer
Course Description
Virtual Training
Course Cost
£75.00
Apply
All Microsoft courses are recommended that you use a mouse and not the trackball facility that is available on the laptop.
For Virtual Training it is recommended that you utilise an additional monitor, you will also need to be familiar with using Microsoft Teams Meetings, work with the Windows Taskbar, to be able to switch applications and to access files and folders in File Explorer.
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.
If, when you have tried to book on a course, you see no dates are displayed, please register your interest by emailing SLDTeamstrainingandsupport@lancashire.gov.uk
Dates, Venues & Times
*Virtual online participation
Tuesday 9 July 2024 (09:30 to 12:30)
Click here to obtain our course Booking Form