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

Type your input message (255 characters). Click OK. To help other users fill in the form, you can integrate hints into individual cells that appear automatically when you click on them.

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 ...