Microsoft Excel Quick Replay

Spend 30 minutes than several hours to learn or repeat most often used Excel functions

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!

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.

Course Content

  • Filter and sort –> 1 lecture • 1min.
  • Row and column blocking using $ –> 2 lectures • 4min.
  • Conditional formatting –> 2 lectures • 3min.
  • If function –> 2 lectures • 3min.
  • Text functions –> 2 lectures • 3min.
  • Pivot table –> 2 lectures • 3min.
  • Creating a basic chart –> 1 lecture • 2min.
  • Vlookup function –> 1 lecture • 3min.
  • Countif function –> 1 lecture • 1min.
  • Countifs –> 1 lecture • 2min.
  • Nesting functions –> 1 lecture • 2min.
  • Macro –> 1 lecture • 2min.
  • Counta function –> 1 lecture • 1min.
  • Iferror function –> 1 lecture • 1min.

Microsoft Excel Quick Replay

Requirements

  • You have to have basic knowledge about Microsoft Excel.
  • My course was prepared on Microsoft Excel 2013.

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

Get Tutorial