Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.

Key Takeaways. Open your Excel spreadsheet and input your data. Use the “Data Analysis” toolpack by enabling it from the “Add-ins” menu. Select the type of statistical analysis you want to ...