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 ADVANCED IFS
This page lists the 6 exercises about Advanced IFs in Excel on our website: p >
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Advanced IFs |
Level: | Relatively easy |
Course: | Excel Advanced |
Exercise: | Using Nested If to Calculate Parking Charges. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Advanced IFs |
Level: | Average difficulty |
Course: | Excel Advanced |
Exercise: | Using the IF function to calculate different interest rates and messages. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Advanced IFs |
Level: | Average difficulty |
Course: | Excel Advanced |
Exercise: | Uses nested =IF to calculate overdue project charges. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Advanced IFs |
Level: | Average difficulty |
Course: | Excel Advanced |
Exercise: | Nested IF calculates different % for staff bonuses as well as a text message. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Advanced IFs |
Level: | Average difficulty |
Course: | Excel Advanced |
Exercise: | Using a nested =IF function to calculate different discounts. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Advanced IFs |
Level: | Harder than average |
Course: | Excel Advanced |
Exercise: | Combining nested =IF and =AND functions. |
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