Microsoft Excel Essentials

About Microsoft Excel Essentials

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

This is a training for basic and intermediate level.

In approximately 4 hours you will learn about Microsoft Excel interface, how to use the basic functions as SUM, MIN, MAX, AVERAGE, how to modify the cells format using basic formatting options, conditional formatting, format as table, as well as the most commonly used functions and functionalities from Microsoft Excel. We will also cover the basics for the lookup functions: VLOOKUP and XLOOKUP, simple IF functions, COUNTIF, COUNTIFS, SUMIF, SUMIFS and protections.

We will cover the basics for pivot tables.

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.