Advanced filters in Ms-Excel

Advanced filters in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to use Advanced filters in Microsoft Excel:

 

  • Creating advanced filters
  • Deleting advanced filters
  • Modifying advanced filters
  • Custom advanced filters
  • Using advanced filters

 

Basic filters in Ms-Excel

Basic filters in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to use Basic filters in Microsoft Excel:

 

  • Creating basic filters
  • Deleting basic filters
  • Modifying basic filters
  • Custom basic filters
  • Using basic filters

 

Conditional Formatting in Ms-Excel

Conditional Formatting in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to use the Conditional Formatting in Microsoft Excel:

 

  • Creating rules
  • Deleting rules
  • Modifying rules
  • Copying rules to other cells
  • Using values in formatting formulas
  • Using cells in formatting formulas

 

The conditional IF function in Ms-Excel

The conditional IF function in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to use the Conditional IF function in Microsoft Excel:

 

  • Syntax
  • Conditions
  • Actions
  • Numeric content
  • Text content
  • Nested functions IF

 

Absolute formulas in Ms-Excel

Absolute formulas in Ms-Excel

In this video, we are going to learn, with a practical exercise, how to use absolute formulas in Microsoft Excel:

 

  • Relative Formulas
  • Absolute formulas
  • Huge benefits of using absolute formulas

 

Manipulating Sheets in Ms-Excel

Manipulating Sheets in Ms-Excel

In this video, we are going to learn how to manipulate Sheets in Microsoft Excel:

 

  • Creating Sheets
  • Renaming Sheets
  • Copying Sheets
  • Deleting Sheets
  • Moving Sheets
  • Inserting rows
  • Deleting rows
  • Inserting columns
  • Deleting columns
  • Assigning colors to Sheets
  • Doing simultaneous actions in several Sheets

 

error: Content is protected !!