Excel Intermediate Training Course London

1.)Advanced functions:

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

  1. Named range

  2. Multiple formula

  3. Array formulas

  4. Auditing formulas

  5. Data validation

  6. Condition formatting

  7. PivotTables and PivotCharts

  8. 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.

Other Training

Also, we provide Excel trainings for all levels.

On-site EXCEL Training  courses in London

Excel for Beginners

Excel Advanced

Request a Quote:

Call: 07761716681