FROG Software Training: Excel Expert Formulae


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.   

Dates Thursday, May 21, 2020 - Download as vCalendar
Venue Online training via Microsoft Teams
Contact Name Rachel Crew
Email rachel.crew@frog.co.uk
Contact Phone 01223841848
Website Event website

Event details:

Functions 

  • INDEX 
  • MATCH 
  • VLOOKUP/HLOOKUP 
  • ROW / COLUMN / ADDRESS 
  • OFFSET 
  • INDIRECT 
  • FORECAST  
  • SWITCH 
  • REPLACE 
  • PMT 
  • SUBTOTAL 
  • SUMPRODUCT 
  • FIND 
  • DATEVALUE 
  • VALUE 

Array functions

  • FREQUENCY
  • TRANSPOSE

Tools 

  • Data tables 
  • Scenarios 
  • Goal seeking
  • Data consolidation
  • Conditional data validation
  • Forecast sheet

Charts 

  • Waterfall  
  • Funnel  
  • Stock  

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.