Intermediate Excel

Excel Intermediate Training Course London

1) Advanced functions:

  • IF vs IFS;
  • OR, AND, NOT;
  • TEXT, RIGHT, LEFT, SEARCH, MID;
  • IFERROR, ISEEROR;
  • VLOOKOP vs 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

For more information or if you have any questions, I would be happy to talk through more details of our services as well as providing a free quotation before starting any project.
Excel training:

Request a quote

Call us on 07761 716 681