How to Get Data Analysis in Excel?
Data Analysis is an Excel add-ins so you should enable it. Follow the below steps to enable it:
- Open your Excel file or open the Excel 2016
- Click on File in the top bar
- Click on Options in the opened vertical bar.
- The 'Excel Options' window will open and then click on Add-ins
- In the below click on Go button
- The Add-Ins window will open
- Enable the Data Analysis on the checkboxes
- Click on OK
- Go to the Data tab and find the Data Analysis icon.
Name: Hidden
Data Analysis Toolpak in Excel
How to Get Data Analysis in Excel?