If you want to spend only 30 minutes than several hours to learn or repeat most often used Excel functions, you are in the right place!

In this course I will explain :

- how to make basic filter and sort (based on dates, text, amount),

- how to use $ to be able to block row and columns. To know what is the logic and to be able to remember it,

- how to use conditional formatting (greater than, less than, colors etc.),

- how to use IFfunction, what are the parts of function,

- what are the most often used text functions - LEFT, RIGHT, MID,

- how to create a basic pivot table, pivot table chart, what are their options,

- how to create a basic chart (manually and automatically),

- how to use VLOOKUP function, what are the parts of function,

- how to use COUNTIF function, like counting a cells based on one criteria,

- how to use COUNTIFS function, like counting a cells based on a several criteria,

- how to do nesting functions, connecting a several functions in one cell,

- how to create a basic MACRO, how to turn on Macro option,

- how to use COUNTAfunction, like counting a cells which have some text, amount, date,

- how to use IFERRORfunction, example with connecting withVLOOKUPfunction