Learn how to parse data in Microsoft Excel easily using our step-by-step guide. Skip to content ... Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range.

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