Step 6 - MS Excel - Look Ups – Level 2 - IT0059
|
Who is this course for? |
|
This course is aimed at existing MS Excel users who want to use the Lookup function to search for information in a workbook. This is a Level 2 course. If you have not used MS Excel for more than 4 years, please do a recap with the Level 1 courses. |
|
Aim(s) |
|
This course provides the skills and knowledge to use Lookup tables to automate workbooks more efficiently. It also covers use of the Index and Match function for more advanced formulas. |
|
Objectives |
|
|
Trainer |
|
Business Systems Trainer |
|
Course Description |
|
Virtual Training |
|
Course Cost |
|
£75.00 |
|
Apply |
Please note, if there are no dates available, please register your interest – see below.
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.