Our most popular course designed for Excel users that need to analyse and report with Excel, using advanced formulas and functions.
Using functions as tools will assist you in creating meaningful information from your data. Functions are also a useful tool for searching for specific information in sheets of data and for creating re-usable tools that can be used for specific business functions.
* How to construct functions
* Using Absolute vs. Relative Formulas
* Formula AutoComplete
* Using the Function Wizard
* Useful Functions for your business
* Conditional Functions (IF, AND, OR)
* Using Named Ranges in Function Construction
* Lookup Functions
* Formula Auditing
* Transposing Data