Goals
- Understanding Conditions in Excel Formulas
- Applying Lookup Formulas to an Array
- Understanding Formula Errors
Program
Use condition formulas
Use the SI formula
Nest several SI
Check several conditions in an SI formula
Lab: Applying Conditions to a Data Table
Use search and text formulas
Search
formulas: VLOOKUP, HLOOKUP Text formulas: LEFT, STXT, SEARCH …
Workshop: Applying these formulas to a typical table
Handle formula errors
Recognize a formula error
Analyze the detected error
Evaluate a formula
Duration
0.25 day
Price
£ 2495
Audience
All
Prerequisites
Have followed « Excel: statistical formulas » or have equivalent knowledge
Reference
BUR100974-F
Sessions
Contact us for more informations about session date