Excel Tips and Tricks

Excel Tips and Tricks

Duration: 24-40 Hours

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. You will learn 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2010.

  1. One Click to Select All
  2. Open Excel Files in Bulk
  3. Shift Between Different Excel Files
  4. Create a New Shortcut Menu
  5. Add a Diagonal Line to a Cell
  6. Add More Than One New Row or Column
  7. Speedily Move and Copy Data in Cells
  8. Speedily Delete Blank Cells
  9. Vague Search with Wildcard
  10. Generate a Unique Value in a Column
  11. Input Restriction with Data Validation Function
  12. Fast Navigation with Ctrl + Arrow Button
  13. Transpose Data from a Row to a Column
  14. Hide Data Thoroughly
  15. Compose Text with &
  16. Transforming the Case of Text
  17. Input Values Starting with 0
  18. Speed up Inputting Complicated Terms with AutoCorrect
  19. One Click to Get More Status
  20. Rename a Sheet Using Double Click