Intermediate Excel

Excel Intermediate Training Course London

1) Advanced functions:

  • IF, IFS;
  • OR, AND, NOT;
  • TEXT, RIGHT, LEFT, SEARCH, MID;
  • IFERROR, ISEEROR;
  • VLOOKOP, HLOOKUP;
  • MATCH, INDEX;
  • SUMIF, SUMIFS, COUNIF, COUNIFS;

2) Named range
3) Multiple formula
4) Array formulas
5) Auditing formulas
6) Data validation
7) Condition formatting
8) PivotTables and PivotCharts
9) Protection
10) Excel Tricks and Tips