Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

Tag Archives for " data cleaning "

4 Quick Methods for Deleting Spaces in Excel

how to delete extra spaces in excel

A clean data is our birthright. But sometimes, we are not able to access it. Sometimes, we are not able to use our data as the way we want to use it. And, the one biggest reason which makes our data unable to use is unwanted spaces in a cell. So, if you want to […]

Check it out now

Consolidate Data From Multiple Worksheets In A Single Worksheet

consolidate data from multiple worksheets in a single worksheet featured images

In my starting days with Excel, I was really bad in capturing data. If you asked me to capture sales data for four different zones, I will create four different worksheets for that. Yes, I was really bad. But, you always learn with your mistakes. Am I right? And, if you are doing the same […]

Check it out now

How To Remove First Character From a Cell Using Quick Methods

how to remove first character in excel cell using quick methods featured image

Yesterday, one of my colleagues, who is really passionate to learn Excel these days asked me “do you know how to remove first character from a cell? I told him a small formula (which was easy) for that, but he was not satisfied & want another method. And after that, I told him about five […]

Check it out now