Microsoft Excel Go To Data Cleaning Trick

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

• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

One of the most important techniques that will help you speed up with accuracy is “Go To” command.


• 200+ Video Tutorials • 80 Case Studies • 3 eBooks • 2 Webinar • 24*7 Dedicated Support


  1. Ctrl + G invokes “Go To” prompt
  2. Alt + S activates the “Special” button on the prompt
  3. Options such as Constants, Formula, Blanks, Visible Cells etc. help you select ALL the cells with such special properties.
  4. 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

Become an Excel pro by joining our Free Online Excel Courses and Advanced Excel Courses