Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

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