Microsoft Excel - Bangla - Syllabus [PDF]

Subject Details

1. Datedif Formula in Microsoft Excel

Datedif Formula in Microsoft Excel

2. Serial No Auto Create - Process 1

Serial No Auto Create

3. Serial No Auto Create - Process 2

Serial No Auto Create - Process 2

4. Update Serial No Dynamically in Excel

Update Serial No Dynamically in Excel

5. Add multiple line in same cell in excel

How to add multiple line in same cell in excel

10. Sum Easy Process in Excel

Sum Easy Process in Excel. In this video I will show you how to add in excel in 3 different way.

In this tutorial, discover how to use the RIGHT formula in Excel to extract the rightmost characters from a cell or range of cells. You will learn the syntax, how to use the RIGHT function, and use cases for when to apply this formula. Additionally, you will find a few tips to help you work with the RIGHT formula more efficiently.

13. LEFT Function in Excel

LEFT Function in Excel

14. CONCATENATE Function in Excel

CONCATENATE Function in Excel

15. MIN Function in Excel

MIN Function in Excel

16. WEEKDAY Formula

WEEKDAY Formula

17. if Formula

if Formula

18. VLOOKUP Function in Excel

VLOOKUP Function in Excel

19. Conditional Formatting Rule 1 - Format all cells based on their values

Conditional Formatting Rule - Format all cells based on their values

20. Conditional Formatting Rule 2 - Format only cells that contain

Conditional Formatting Rule - Format only cells that contain

21. Rank Function in excel

How to Create Rank using Students Marks using Excel

22. Conditional Formatting Rule 3 - Format Only top or bottom ranked values

Conditional Formatting Rule 3- Format Only top or bottom ranked values

23. Conditional Formatting Rule 4- Format only values that are above or below average

Conditional Formatting Rule - Format only values that are above or below average

24. Conditional Formatting Rule 5 - Format only unique or duplicate values

Conditional Formatting Rule 5 - Format only unique or duplicate values

25. Conditional Formatting Rule 6 - Use a formula to determine which cells to format

Conditional Formatting Rule 6 - Use a formula to determine which cells to format

26. Conditional Formatting Rule 6 - Example

Conditional Formatting Rule 6 - Example

2. Excel - View Tab

1. Freeze first row and column

freeze first row and column

3. Excel - Insert Tab

1. Pie Chart - Example

Pie Chart - Example

4. Excel - Data Tab

1. Text to Colums

Text to Colums

2. Import Table Data from Website Using Query

Import Table Data from Website Using Query

3. How to mask numbers in Excel Bangla

How to mask numbers in Excel Bangla

4. Dropdown List

Dropdown List

5. Excel Options

1. Excel Options

Excel Options

6. Excel - Developer Tab

1. Merge Multiple Excel files into a Single File - Get Specific Column

Merge Multiple Excel files into a Single File - Get Specific Column

2. Copy all the columns from multiple Excel files into a single sheet

copy all the columns from multiple Excel files into a single sheet

3. copies all columns from the first Excel file but only copies columns starting from the second column for all subsequent Excel files

copies all columns from the first Excel file but only copies columns starting from the second column for all subsequent Excel files

4. Enable Developer Tab

Learn how to enable the Developer tab in Microsoft Excel to access its full set of features. Find out what the Developer tab contains, how to add it to the Ribbon, and more.

5. Merge Multiple Excel files into a Single File

Merge Multiple Excel files into a Single File

Microsoft Excel - Bangla Syllabus

1. Excel - Home Tab