Functions 5 in Ms-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

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

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

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

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

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

 

error: Content is protected !!