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