Move the cursor over each option to preview it. From the pop-up window, click “Formatting.” This is just one of many analysis types, though it’s a great one to start with for our fictional example. You’ll find it at the bottom right of the selected data. Next, click the small “Quick Analysis” icon. To use the Quick Analysis tool, all you have to do is select the worksheet table’s cells and then click the Quick Analysis tool that automatically appears in the lower-right corner of the last selected cell.
Once you select the data, we can see the Quick. Select the tool you wish to use and click OK.
Click on Data Analysis to open the analysis tools available. Once enabled the Data Analysis ToolPak will be located in the the Data tab all the way to the right. The Add-Ins window will open, add a checkmark to the check box next to Analysis ToolPak, click OK.
0 kommentar(er)
