Microsoft Excel - Bangla Syllabus

Download PDF

  1. Excel - Home Tab

1. Serial No Auto Create - Process 1

2. Serial No Auto Create - Process 2

3. Update Serial No Dynamically in Excel

4. Add multiple line in same cell in excel

5. UPPER Function in Excel

6. LOWER Function in Excel

7. PROPER Function in Excel

8. SUM Formula in Excel

9. Sum Easy Process in Excel

10. SUMIF Formula in Excel

11. RIGHT Formula in Excel

12. LEFT Function in Excel

13. CONCATENATE Function in Excel

14. MIN Function in Excel

15. WEEKDAY Formula

16. if Formula

17. VLOOKUP Function in Excel

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

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

20. Rank Function in excel

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

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

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

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

25. 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. Dropdown List

2. Text to Colums

3. Import Table Data from Website Using Query

  5. Excel - Developer Tab

1. Enable Developer Tab

2. Merge Multiple Excel files into a Single File