What you'll learn:
Filter and sort columns
Block row and column using $
Use conditional formatting
Use if function
Use text functions like left, right, mid
Creating a basic pivot table, pivot table chart
Creating a basic table (automatically and manually)
Vlookup function
Countif function
Countifs function
Nesting functions - how to connect a several functions in one cell
How to create a basic Macro
Counta function
Iferror function - using with vlookup function
Requirements
You have to have basic knowledge about Microsoft Excel
My course was prepared on Microsoft Excel 2013
Description
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 IF function, 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 COUNTA function, like counting a cells which have some text, amount, date,
- how to use IFERROR function, example with connecting with VLOOKUP function
Who this course is for
Beginners which want to learn most often used functions
Intermediate and advanced people which want to repeat most often used functions
Homepage

https://www.udemy.com/course/microsoft-excel-quick-replay

Related Downloads :

{related-news}