| Print |

Excel Expert Formulae

Location Cambridge
Price ex. VAT 255 GBP
Start Date 30 January 2020
Course typeStandard
   
Course codeFROG246
   
Duration1 Day

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.   

Target Audience

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.  

Prerequisites

It is assumed that the participant will have either attended an Excel Advanced Formulae and Functions course or have equivalent knowledge.  

Outline

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  

Book the course: Excel Expert Formulae

Course Search