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.
- One Click to Select All
- Open Excel Files in Bulk
- Shift Between Different Excel Files
- Create a New Shortcut Menu
- Add a Diagonal Line to a Cell
- Add More Than One New Row or Column
- Speedily Move and Copy Data in Cells
- Speedily Delete Blank Cells
- Vague Search with Wildcard
- Generate a Unique Value in a Column
- Input Restriction with Data Validation Function
- Fast Navigation with Ctrl + Arrow Button
- Transpose Data from a Row to a Column
- Hide Data Thoroughly
- Compose Text with &
- Transforming the Case of Text
- Input Values Starting with 0
- Speed up Inputting Complicated Terms with AutoCorrect
- One Click to Get More Status
- Rename a Sheet Using Double Click