Data Cleaning Trick
It is so easy to work on your own spreadsheet rather than working with Excel files made by someone else. Significant time is wasted in (1) cleaning or “sanitising” the data, and (2) establishing inter-sheet and intra-sheet formula connections. This process of Data Cleaning becomes super important if you are working in the domain of Forensic Audit. This is made easy with the help of Excel Go To Function
One of the most important techniques that will help you speed up with accuracy is “Go To” command.
- Ctrl + G invokes “Go To” prompt
- Alt + S activates the “Special” button on the prompt
- Options such as Constants, Formula, Blanks, Visible Cells etc. help you select ALL the cells with such special properties.
- If you also apply Ctrl + Enter technique with the above procedure, you will be amazed at the possibilities.
How to use Go To – Special along with Ctrl + Enter technique to reduce 3-4 hrs. work to 2 mins. This can considerably increase your productivity and efficiency.
For more smart videos on Excel Tricks subscribe to our Yoda learning YouTube channel