Now when the “ Data” manu item is selected, there should be an option called “Data Analysis” on the far-right-hand side of the ribbon. You will be returned to the spreadsheet that you were working on.
Step 3Ĭlick “OK” and the selected data packs will be installed. If a prompt says that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
If Analysis ToolPak is not listed, click “Browse” to locate it. Choose “ Analysis ToolPak” and “ Analysis ToolPak – VBA” In the “ Manage” drop-down box at the bottom, select “ Excel Add-ins” and press “ Go…”Ī dialogue box will appear. In the menu, go to File > Options and then click on “ Add Ins” on the left-hand menu. Here are instructions for enabling Data Analysis in Excel 2010. Microsoft Office’s Excel package contains a number of data-analysis tools for professionals who require an ability to perform sophisticated mathematical analyses of data. Instructions for adding the Data Analysis tool pack to Microsoft Excel
0 kommentar(er)
