Functions 5 in Ms-Excel

small head BIG WISDOM

Rising your being

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

small head BIG WISDOM

Rising your being

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

small head BIG WISDOM

Rising your being

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

small head BIG WISDOM

Rising your being

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

small head BIG WISDOM

Rising your being

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

small head BIG WISDOM

Rising your being

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)