In this video, we cover how to extract numbers, text, or other parts of a cell in Excel. We demonstrate extracting a number ...

Recently Microsoft has introduced a game-changing set of functions in it’s Excel spreadsheet software that harness the power of Regular Expressions (REGEX) to streamline data extraction, cleaning, and ...

Some tools are just so awesome that I can’t imagine I haven’t used them by now. My recent discovery is just awesome and I can’t wait to share it with you! OutWit Hub is a cool FireFox addon that ...

If you use Microsoft Excel on a daily basis as a data analyst or number cruncher, learning how to use Excel’s advanced spreadsheet tools can significantly boost your productivity and efficiency in ...