Select the cells of data that you want to analyze. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Roll over each option in the Quick Analysis gallery to see a preview. We can use any of these features by clicking on them and the result is reflected on your screen immediately. Here we take an example to show the Quick Analysis tool feature in Excel 2013. ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel. Step 1: Open the Microsoft Excel 2013 Preview. During the past 22 years our add-in has grown to become probably one of the worlds most popular add-ins for Microsoft Excel. Step 4: After creating the table, select the table. You will be shown a popup button at the bottom-left side. Step 5: You will be shown a toolbar with many data analysis features. There are many easy to use, time-saving tools in Excel. Here we are creating a chart on the selected data. Step 6: Select the type of the chart you want to create or you can also click on more chart options to get a list of all charts in Excel 2013. Step 7: After selecting the charts you wil see that it appears on your Excel sheet.Excel like many of Microsoft’s other Office applications are extremely powerful tools that have many ‘hidden’ features. I stumbled on the Analysis ToolPak when I took an quantitative analysis class for my Masters program.
Once I enabled the add-in and learned how to use the tools it provided, I have not used any other statistical tool except perhaps Minitab, but then I use that for the more complex analysis. The problem with the Excel add-in is that it is not loaded by default, this quickly became a problem for the professor teaching the class because he had to walk everyone through the process of enabling the powerful add-in. I’m posting this quick how-to for those of you that don’t know how to enable it or even know where to locate it.
#HOW TO USE QUICK ANALYSIS TOOL IN EXCEL MAC HOW TO#
If you have any questions or comments, feel free to post them below.ġ. #HOW TO USE QUICK ANALYSIS TOOL IN EXCEL MAC FREE# Click the File tab, click Options, and then click the Add-Ins category. While Excel is open, click the Office button (the Orb) and click on Excel Options.Ģ. If youre using Excel 2007, click the Microsoft Office Button, and then click Excel Options. In the Manage box, select Excel Add-ins and then click Go. If youre using Excel for Mac, in the file menu go to Tools > Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. When the Excel Options window opens, click on Add-Ins located on the left pane. At the bottom of the window select Excel Add-ins from the drop-down to the right of Manage:, click Go… to proceed.ģ. The Add-Ins window will open, add a checkmark to the check box next to Analysis ToolPak, click OK.Ĥ. Once enabled the Data Analysis ToolPak will be located in the the Data tab all the way to the right. #HOW TO USE QUICK ANALYSIS TOOL IN EXCEL MAC FREE#Ĭlick on Data Analysis to open the analysis tools available.ĥ.#HOW TO USE QUICK ANALYSIS TOOL IN EXCEL MAC FOR MAC#.#HOW TO USE QUICK ANALYSIS TOOL IN EXCEL MAC HOW TO#.