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.

Worth $20, Absolutely Free

Tag Archives for " data cleaning "

Remove Extra Spaces

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. And, the of the one biggest reasons which make our data unable to use is extra spaces in a cell. So, if you want to use […]

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. I was that bad.But, you always learn with your mistakes. Am I right? And, if you are doing the same mistakes like I […]

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