EXERCISE TOPIC▼
EXCEL EXERCISES▼
EXCEL EXERCISES▼
- Excel basics (1)
- Creating formulae (5)
- Formatting worksheets (9)
- Basic printing (8)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (17)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (6)
- 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 DATA TABLES
This page lists the 2 exercises about Data tables in Excel on our website: p >
Software: | Excel |
Version: | Excel 2010 and later |
Topic: | Data tables |
Level: | Average difficulty |
Course: | Excel Business Modelling |
Exercise: | Create a one-way data table in an Excel 2007 model to show the effect of a change in initial investment on the NPV for a project. |
Software: | Excel |
Version: | Excel 2010 and later |
Topic: | Data tables |
Level: | Harder than average |
Course: | Excel Business Modelling |
Exercise: | Create a two-way data table in an Excel 2007 model, comparing the NPV for an investment for different discount rates and different initial outlays. |
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