Microsoft Excel Essentials 2024

Microsoft Excel knowledge for basic and intermediate level

What you’ll learn
Basic Microsoft Excel knowledge
How to create simple formulae
How to use 1st level functions
How to create pivot tables
How to use date functions
How to use text functions
How to use vlookup and xlookup functions

Requirements
Laptop / PC and a valid Microsoft Excel license

Description
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 companiesThis 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.

Who this course is for
Basic and intermediate level in Microsoft Excel