Designed for advanced users of Excel who are aiming to extend their Excel knowledge even further by looking at the more complex but informative formulas and hidden gems to help with data analysis. By the end of this course you will learn how to work with more complex formulas such as MATCH, INDEX, OFFSET, work with Excel tools to analyse data further and produce more advanced charts.
FROG Software Training: Excel Expert Formulae
- ROW / COLUMN / ADDRESS
- Data tables
- Goal seeking
- Data consolidation
- Conditional data validation
- Forecast sheet
Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.