Microsoft Excel - Bangla Syllabus

Download PDF Subject Details

  1. Excel - Home Tab

1. Datedif Formula in Microsoft Excel

2. Serial No Auto Create - Process 1

3. Serial No Auto Create - Process 2

4. Update Serial No Dynamically in Excel

5. Add multiple line in same cell in excel

6. UPPER Function in Excel

7. LOWER Function in Excel

8. PROPER Function in Excel

9. SUM Formula in Excel

10. Sum Easy Process in Excel

11. SUMIF Formula in Excel

12. RIGHT Formula in Excel

13. LEFT Function in Excel

14. CONCATENATE Function in Excel

15. MIN Function in Excel

16. WEEKDAY Formula

17. if Formula

18. VLOOKUP Function in Excel

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

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

21. Rank Function in excel

22. 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

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

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

26. Conditional Formatting Rule 6 - Example

  2. Excel - View Tab

1. Freeze first row and column

  3. Excel - Insert Tab

1. Pie Chart - Example

  4. Excel - Data Tab

1. Text to Colums

2. Import Table Data from Website Using Query

3. How to mask numbers in Excel Bangla

4. Dropdown List

  5. Excel Options

1. Excel Options

  6. Excel - Developer Tab

1. Enable Developer Tab

2. Merge Multiple Excel files into a Single File