contact  contact

Cart  

(empty)

Currency

Functions-Audit-Protection-If-Analysis

Functions-Audit-Protection-If-Analysis

95 pages (2010) and 97 pages (2013) / Training Excel Functions-Audit-Protection: go beyond standard functions, use the auditing tools in case of errors, protection ... Use functionalities related indirectly to functions.

More details


CHF 95.00

Main topics covered in the documentation

Absolute and relative references
Functions : general principles
Names
Examples of functions : COUNT, COUNTBLANK, COUNTIF - SUMIF - AND, OR - VLOOKUP (H) - INDEX, MATCH, EXACT, SUBTOTAL and so on
Audit
Conditional formats
Protection
If-Analysis (custom views, scenarios, single/double entry tables, solver ...)