-

Modern Excel - The Transformative Advanced Skills


A customizable course according to your company’s requirements.


1. Duration

2 days (4 sessions of 3.5 hours each).


2. Objectives

The course aims to transform your experience and engagement with Excel. We introduce transformative features of Excel.

  • The course starts from the foundations of data as accepted by a cell in Excel.

  • Transform Excel surface – use Tables instead of Range.

  • Transform filtering - use playful Slicers

  • Transform reporting: use Pivot Tables

  • Transform data lookup: VLOOKUP and XLOOKUP

  • Transform logical formulas: IF to IFS

  • Transform default settings of Excel – settings that make Excel easier to use.

  • Transform Data cleaning – use Power Query

And so on.

The course is totally hands-on. No theory! No PowerPoint presentation. Throughout the course you practice the skills on Excel. The exercises are based on real life data scenarios.


3. Pre-requisite

You must have worked on Excel for at least 6 months.