smallhead BIGWISDOM
Rising your being
Get 10% discount in all the site purchases only in May, 2023!
Use the coupon code: "shBW_Maydeal"
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
Advanced filters in Ms-Excel
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
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!
You can get the book about living
and having experiences in China.
(See Table of Content)
Get the book about All Prepositions in Spanish!
You can get the book about All prepositions in Spanish which includes 427 examples.
(See Table of Content)
Get the book about 1100 English-Spanish Cognates!
It includes:
1100 definitions in English
1100 definitions in Spanish
1100 examples in English
1100 examples in Spanish
Bonus: Audio pronunciations
You can get the book about 1100 English-Spanish Cognates.
(See Table of Content)