Microsoft Excel from medium to advanced

This training covers knowledge you need to work efficiently in Microsoft Excel.

This is a training for intermediate and advanced level.

In approximately 3 hours you will learn about Microsoft Excel IF function, nested IF functions, IF and logical functions, lookup functions VLOOKUP, XLOOKUP, INDEX and MATCH in more complex scenarios (multiple IDs, drag formula right for retrieving values from multiple column), pivot table in depth, charts in depth, error handling using IFERROR and AGGREGATE, GOAL SEEK, SOLVER, advanced filters, custom rules for conditional formatting, data validation with nested lists, etc.

Each lesson in between 5 and 20 minutes, to be easily accessible from anywhere, anytime, at a pace you choose. In the lessons resources you will find the original source and the completed one, to be more accessible for you to follow along my examples.

We all need a software for entering data, preparing and processing data, data analysis, creating reports. Because it is wide spread, Microsoft Excel is a very common solution.

You can choose this training because:

- you want to improve your knowledge

- you want to change jobs

- you want to change companies

This training is compatible with all versions of Microsoft Excel, except XLOOKUP, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, that are available only in Microsoft 365 or from Microsoft Office 2021 version.