NEW! FREE 15 Hours Microsoft Excel Course! View now 

ExcelTutorials

Microsoft Excel Go To Data Cleaning Trick

1 Mins read

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
[xyz-ihs snippet=”Excel-Curriculum”]




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

Go-To-Special

[xyz-ihs snippet=”Excel-online-Course”]

 

  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

Related posts
ExcelExcel VBA Code

Create A Table Of Contents By VBA Code

1 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
ExcelExcel VBA Code

Save Each Worksheet as a Separate PDF

1 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…