Tips and Tricks | myanmarexcelexpert

To Save Your Time & Energy

Tips & Tricks

Tips and Tricks

5. Protect Sheet and Workbook (Video)

4. Data Filtering (Video)

3. Find and Replace (Video)

2. Conditional Formatting (Video)

1. Paste Special (Video)

6. To Sum Quickly

7. One Click to Select All

9. Status Bar in Excel

13. Speakout the Data in Excel

20. Unit Conversion in Excel

17. Using Clipboard Efficiently

16. Excel ဖုိင္ကုိ Password ျဖင့္ကာကြယ္နည္း

18. Spelling Check in Excel

19. Inserting Bullet in a Cell

12. Arrange to View Multiple Windows

10. Custom List in Excel

11. Format Painter

14. Freeze Panes

15. Auto Correct

21. Excel Camera

22. Go to the Right Cell after pressing Enter

Download this Video

Download this Video

Download this Video

Download this Video

Download this Video

23. Name a Cell Range

24. Data Validation - Drop Down List

25. Data Validation - Dependent Drop-Down List

26. Removing Unwanted Rows Quickly

28. Password Protecting only to Specific Cell Range

30. Scenario Manager