Category Archives for "Excel"

Top 10 Text Functions in Excel

 Top 10 TEXTS Functions in Excel Transforming and cleaning text is an essential for any analyst, teacher or secretary.  Luckily Excel provides a quick and easy ways to transform text in a spreadsheet using using native functions. Check out the Excel Text Function Training Video FIND: Definition: The FIND function is used in Excel to locate […]

How to Remove Spaces in Cells in Excel

A big part of cleaning up data is removing spaces in cells with text. Usually, these spaces are imported when text is copied or pasted in Excel. Luckily, there is an easy function that you can use to remove leading and trailing spaces in cells with text. This function is called TRIM. How to Remove […]

How to Find Outliers in Excel

Excel has a lot of underused function that can greatly improve your data analysis. One of the best features is it’s statistical capabilities So you can find outliers in Excel easily with simple statistics formulas.. Why should you isolate and eliminate outliers in your data? One of the main reasons is that these extreme data […]

Best Online Excel 2018 Courses

The Best Courses to Master Excel  2016 Data Analysis Anyone who works with data knows that one of the most used data tools is Excel.  This is not only an essential tool but it is also the number one spreadsheet tool on the planet. Only followed by OpenCalc and Google Sheets.  On the whole those with advanced […]