Master the Excel LOOKUP Functions

The Excel LOOKUP Functions let you efficiently search for and retrieve data from another part of your database.
They are incredibly powerful tools that will make your spreadsheets much more useful - and they can save you hundreds of hours a year of manual data entry
This tutor-led, classroom course will show you how to build and manipulate the LOOKUP functions. Content includes

• Finding an exact match – or the nearest fit
• Using VLOOKUP across different sheets
• Finding the second (or third, or fourth) return, rather than the first
• Looking UP a list, rather than from the top down
• Searching horizontally (HLOOKUP)
• Using a helper column to differentiate similar data
• The new kid in town – XLOOKUP, and why it is so much easier to use
  

We use a specially-designed booklet to take you through the various lessons Each lesson comes with its own practise exercises, and questions are encouraged by the tutor, who will also be on hand to help you with anything you get suck on.
The booklet is yours to keep, and the course also comes with free access for six months to our free online Excel helpdesk, so you can contact us at any point for help if you are stuck on an Excel problem.

.

Attendees may bring their own laptop, or work from one of ours, supplied on the day.

FAQs

• Do I have to book using Eventbrite?No. You can simply contact us at [email protected] with your name, organisation, billing address and a note of any access issues. We will issue an invoice in advance of your attendance.What refreshments are served at the training?Two free rounds of tea, coffee and biscuits are served on arrival and at mid-morning. There is also a sandwich and wraps lunch served as part of the ticket cost.Is there disabled access?The venue is fully accessible, although wheelchair entry has to be from the rear of the building, as there are steps at the front. Please let us know in advance of any access requirements.What can/can't I bring to the event?No need to bring equipment or laptop unless we specifically ask in the training descriptor. Pen and paper may be handy for notes.Is my registration/ticket transferrable?If you want to transfer to another training course, please contact us with five or more days’ notice at [email protected]Do I have to bring my printed ticket to the event?No needWhat is the refund policy?Civicos Training requires five working days' notice of cancellation. We will always attempt to place you on a later version of the same course, or transfer your booking to another course at no extra cost. However, if you cancel with less than the required notice, we do reserve the right to charge for the full cost of the course

Host or Publisher Civicos Training and Communications CiC