OR Function
Returns TRUE if at least one argument is TRUE.
AND Function
Returns TRUE if all arguments are TRUE.
Logical Functions
Logical functions makes it possible to replace manual controls with logical tests.
Formula Auditing
It is important to know techniques that supports a structured way of finding the errors and correcting them.
Formula Structure
Structuring formulas makes them easier to review.
Structured References
When referring to a Table dynamic Structured References can be used instead of static A1 References.
Assortment audit
Assortment audits are carried out to phase in new products and phase out old products.
Core Exercises
Realistic case studies which will train you in implementing your new Excel skills.