In this video, we are going to learn, with a practical exercise, how use the functions UPPER(), LOWER(), PROPER() and SUBSTITUTE() in Microsoft Excel:

• Syntax of UPPER()
• How to use UPPER()
• Syntax of LOWER()
• How to use LOWER()
• Syntax of PROPER()
• How to use PROPER()
• Syntax of SUBSTITUTE()
• How to use SUBSTITUTE()

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

• Syntax of FIND()
• How to use FIND()
• Practical exercise to use FIND() and the functions learned in previous videos: LEN(), LEFT(), RIGHT() and MID()

In this video, we are going to learn, with a practical exercise, how use the functions MID() and CONCATENATE() in Microsoft Excel:

• Syntax of MID()
• How to use MID()
• Syntax of CONCATENATE()
• How to use CONCATENATE()

In this video, we are going to learn, with a practical exercise, how use the functions LEFT() and RIGHT() in Microsoft Excel:

• Syntax of LEFT()
• How to use LEFT()
• Syntax of RIGHT()
• How to use RIGHT()

In this video, we are going to learn, with a practical exercise, how use the functions LEN() and TRIM() in Microsoft Excel:

• Syntax of LEN()
• How to use LEN()
• Syntax of TRIM()
• How to use TRIM()

In this video, we are going to learn, with a practical exercise, how create an invoice with a dropdown list and formatting in Microsoft Excel:

• Entering content
• Creating a dropdown list
• Calculation
• Formatting

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