fbpx

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




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

Excel Power Users Ebook

Be Smart at Excel | New Skills for New JOB

This eBook will help you to get Excel Skills & Boost your career

Go-To-Special

 

ARE YOU STRUGGLING WITH EXCEL FORMULAS?
Become a "Hero at Office"• 200+ Video Lessons • Real-life Case studies • Lifetime Access

 

  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