Microsoft Excel

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

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

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

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

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

## 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

In this video, we are going to learn, with a practical exercise, how to use Advanced filters in Microsoft 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

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

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

# Get the book about China!

Get it now!

(See Table of Content)

# Get the book about All Prepositions in Spanish!

### Get it now!

(See Table of Content)

# Get the book about 1100 English-Spanish Cognates!

Bonus:  Audio pronunciations

### Get it now!

(See Table of Content)

error: Content is protected !!