Lookup functions and 3-D Excel file
-
Speaker : ISAAC GOTTLIEB
-
When : Wednesday, July 31, 2024
-
Time : 01 : 00 PM EST
-
Add To Calendar
Refer a Friend
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU and others in the US and other countries. In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years.
He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.” (From Microsoft’s site.)
Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations.
He mails Excel-Tip-Of-The-Month to over 35,000 recipients.
Dr. Gottlieb has earned his PhD and two Masters Degrees from Columbia University Department of Industrial Engineering and Operations Research.
His two recent books are:
Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards. Nov 2022.
Management Science using Excel: Harnessing Excel's advanced features for business optimization. Aug 2023.
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.
Areas Covered
- 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
Course Level- All Levels
Who Should Attend
Any person using Excel that needs wants to improve their day to days skills and deals with small and large databases.
Why Should You 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?
Topic Background
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
-
$160.00
-
