WISE OWL EXERCISES
EXCEL EXERCISES
EXCEL EXERCISES
- Creating formulae (5)
- Formatting worksheets (7)
- Basic printing (7)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (16)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (5)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (2)
- Pivot tables (3)
- Advanced pivot tables (3)
- Scenarios (2)
- Data tables (2)
- Array formulae (2)
- Building models (2)
- Masking (2)
- Cashflow calculations (1)
- Investment appraisal (1)
Excel exercises on ADVANCED LOOKUP FUNCTIONS
This page lists the 9 exercises about Advanced lookup functions in Excel on our website:
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Advanced lookup functions |
| Level: | Relatively easy |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Add an input field to an Excel 2007 model saying what sort of celebrity you are, and use this to calculate income using a lookup formula. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Advanced lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use the MATCH/INDEX functions to work out when a drawdown fee is exceeded in an Excel 2007 model. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Advanced lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using MATCH and INDEX to find Flight Times. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Advanced lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Nesting =MATCH inside =VLOOKUP. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Advanced lookup functions |
| Level: | Average difficulty |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Using MATCH in an Exact Match Lookup. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Advanced lookup functions |
| Level: | Harder than average |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Show a cash position at the end of every second month for an Excel 2007 model in 3 different ways, using INDEX, OFFSET and INDIRECT. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Advanced lookup functions |
| Level: | Harder than average |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Use the INDIRECT function in an Excel 2007 model to allow a user to specify a line item and show its total. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Advanced lookup functions |
| Level: | Harder than average |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | When a user looks up a month and week number in an Excel 2007 spreadsheet, show the corresponding value by using MATCH and INDEX. |
| Software: | Excel |
| Version: | Excel 2010 and later |
| Topic: | Advanced lookup functions |
| Level: | Harder than average |
| Courses: | Excel AdvancedExcel Business Modelling |
| Exercise: | Create INDEX array functions to show rows and columns from a table for a choice of row/column. |
You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?
This page has 0 threads
Add post