 # Functions 5 in Ms-Excel

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()

### Join to get a free e-book!

By subscribing, you will get a free e-book about China. (See Table of content) # Functions 4 in Ms-Excel

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()

### Join to get a free e-book!

By subscribing, you will get a free e-book about China. (See Table of content) # Functions 3 in Ms-Excel

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()

### Join to get a free e-book!

By subscribing, you will get a free e-book about China. (See Table of content) # Functions 2 in Ms-Excel

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()

### Join to get a free e-book!

By subscribing, you will get a free e-book about China. (See Table of content) # Functions 1 in Ms-Excel

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()

### Join to get a free e-book!

By subscribing, you will get a free e-book about China. (See Table of content) # Invoice with a dropdown list in Ms-Excel

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

### Join to get a free e-book!

By subscribing, you will get a free e-book about China. (See Table of content) error: Content is protected !!