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 "

Top 5 Methods to Remove First Character from a Cell in Excel

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

➲ Continue Reading

Remove Extra Spaces

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 […]

➲ Continue Reading

Consolidate Data From Multiple Worksheets in a Single Worksheet

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 […]

➲ Continue Reading