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

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

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

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

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