3-day Virtual Seminar

Lookup Functions and 3-D Excel File

Overview

Lookup tables are a good way to search for information and to return specific data relating to the information you introduce or look for. The Lookup function is a quick way to find the information one needs, and is particularly efficient when dealing with large databases that would be extremely time-consuming to search manually. 

So far, most spreadsheets people deal with use models with rows and columns only. You are now going to utilize the third dimension in the model, namely sheets. You may want to prepare Payroll reports for four or five weeks on separate sheets and compile the results (going to the third dimension) into the last sheet for a summary. Other possible applications include summing four quarters' sheets into an annual report, inventory reports of different locations consolidated into a corporate total inventory report, or a summary budget for a number of departments.

You will receive all the Excel files before the workshop - so that you can practice all these techniques during the workshop and on you own.

Why you should Attend

Professionals or students who are using Excel:

• When they have to look up values based on specific key parameters as it may be almost impossible and time consuming otherwise
• When one has multiple pages of information and they want to combine the information
  

Areas Covered in the Session

• Use Lookup functions
• Understand the different types of these functions
• Use approximate and exact values lookup
• Understand how to use multi sheet functions 
• Sum a number of sheets into a summary sheet
  

Who Will Benefit

• Any Person using Excel that needs wants to improve their day to days skills and deals with small and large Databases