Master the Excel LOOKUP Functions

Wed Feb 26 2025 at 10:30 am to 05:30 pm UTC01:00

Robertson House | Glasgow

Civicos Training and Communications CiC
Publisher/HostCivicos Training and Communications CiC
Advertisement
Excel's LOOKUP Functions are incredibly powerful tools that will make your spreadsheets much more useful.
About this Event

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
Advertisement

Event Venue & Nearby Stays

Robertson House, The Robertson Trust, Glasgow, United Kingdom

Tickets

GBP 158.00

Discover more events by tags:

Workshops in Glasgow

Sharing is Caring:

More Events in Glasgow

Carly Pearce
Tue, 25 Feb, 2025 at 07:00 pm Carly Pearce

O2 Academy Glasgow

Future Palace, Immerse in Glasgow
Tue, 25 Feb, 2025 at 07:00 pm Future Palace, Immerse in Glasgow

Slay Glasgow

Future Palace @ Slay Glasgow in Glasgow
Tue, 25 Feb, 2025 at 07:00 pm Future Palace @ Slay Glasgow in Glasgow

Slay Glasgow

Doves in Glasgow
Tue, 25 Feb, 2025 at 07:00 pm Doves in Glasgow

Galvanizers SWG3

Nashville Nights \/\/ Glasgow Oran Mor
Tue, 25 Feb, 2025 at 07:30 pm Nashville Nights // Glasgow Oran Mor

Òran Mór

The Nashville Nights Tour
Tue, 25 Feb, 2025 at 07:30 pm The Nashville Nights Tour

Oran Mor

Disney On Ice - 100 Years of Wonder
Wed, 26 Feb, 2025 at 05:30 pm Disney On Ice - 100 Years of Wonder

OVO Hydro

Biohazard, Life Of Agony, BillyBio in Glasgow
Wed, 26 Feb, 2025 at 06:00 pm Biohazard, Life Of Agony, BillyBio in Glasgow

SWG3 Galvanizers

2025 Awards Night ~ Grand Gala Dinner
Wed, 26 Feb, 2025 at 06:30 pm 2025 Awards Night ~ Grand Gala Dinner

Crowne Plaza Glasgow SEC

Biohazard, Life Of Agony, BillyBio in Glasgow
Wed, 26 Feb, 2025 at 06:30 pm Biohazard, Life Of Agony, BillyBio in Glasgow

Galvanizers SWG3

Glasgow Gay Speed Dating | Ages 24-40
Wed, 26 Feb, 2025 at 07:00 pm Glasgow Gay Speed Dating | Ages 24-40

Saint Judes

The Lottery Winners in Glasgow
Wed, 26 Feb, 2025 at 07:00 pm The Lottery Winners in Glasgow

Saint Luke's

Glasgow is Happening!

Never miss your favorite happenings again!

Explore Glasgow Events