The objective of this workshop is to cover all the ins and out of two important parts of Excel. The first one is the LOOKUP functions finding information in a table based on key words or other information. The second part is to be able to use the third dimension in Excel – summing a number of sheets into a summary sheet. When you complete this workshop, you will be fluent in all aspects of the lookup function and you will be able to use the third dimension in Excel going through a number of sheets – summing it to the summary sheet.
Course Objectives:
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.
Course Outline:
• Use Lookup functions.
• Understand the different aspects 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.
What You Get:
• Training Materials
• 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.
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
All Excel users can use the familiarity with the lookup functions. Most Excel users are not familiar with the 3-D functionality of Excel – which will a game changer in their use.
Advanced Excel Functions: Lookups, Logic, and More
Get Instant Access 90 Minutes View Program |
Lookup Function Essentials in Microsoft Excel
Get Instant Access 60 Minutes View Program |
2 Hours Virtual Seminar on Microsoft Excel Functions
Get Instant Access 120 Minutes View Program |
INTERMEDIATE FUNCTIONS, LOOKUPS & LINKING IN MS EXCEL
Get Instant Access 90 Minutes View Program |
Lookup Functions, Formula Tracing & Named Ranges in Excel
Get Instant Access 90 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry