LSE Website
You are not logged on Log in
Programme: Microsoft Office IT Practical Workshops
Course: Excel: Logical and Lookup Functions
By the end of this session, you will be able to use Excel logic and lookup functions to display text, perform calculations, or retrieve information by querying information held elsewhere in the spreadsheet. These skills are key to the use of Excel as a tool for interrogating data tables or performing advanced calculations based on logical queries, particularly in numeric disciplines.

These IT sessions flip traditional training on its head by presenting learners with the problem to be solved and encouraging them to use their prior experience, real-world problem solving tools like Google and in-application Help programs, and their fellow students or colleagues to find the solution. We all learn best by ‘doing’ and these sessions provide a structured environment in which we help you find the best solutions yourself, rather than walking you through the ‘right answer’.

The workshops are all held in ALD.LG.01B (The Amber Room) and we request that you kindly refrain from eating and drinking in this room.

Please ensure you bring your LSE ID with you as you may be asked to show it at reception.

Before booking this workshop, please ensure that you have attended the following workshops:

  1. Excel: Creating a Calculated Spreadsheet
  2. Excel: Numeric Calculations 
  3. Excel: Essential Functions (Former Basic Functions)
Event information:
No courses currently scheduled.

Reserve a place for me when this course is next scheduled.*

Additional Resources:
Training Provider:
* Currently, course reservation is available to Staff and PHD Students.

LSE Training and Development System - version