Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Quick analysis tools in excel are the tools provided by Excel to quickly analyze any data rather than going the older method of inserting a chart or tables etc, there are two ways to see this quick analysis tools, select the cell range data which contains values and a yellow box appears on bottom right hand side which is the quick analysis tools or we can press CTRL + Q for quick analysis tools.
Quick Analysis Tools in Excel (Table of Contents)
- Quickly Insert Formatting to the Data
- Quickly Analysis Inserting Chart to the Data
- Quickly Analysis through Totals
- Quickly Analysis through Tables
- Quickly Analysis through Sparkline’s
Excel Quick Analysis Tools
Excel is tremendous while doing the data analysis, for this purpose only excel has various kinds of formulas, tools, visualization charts, and many other pieces of stuff. Over a period of time, Microsoft has made very useful updates with its new version products and similarly, in its 2013 version of excel it has provided one more useful tool i.e. “Quick Analysis”.
You must have searched for this tool in excel 2013 but it is always with you whenever you select the data. Yes, it is with you but you are not interested in that at all, so in this article, we have decided to take you through the “Quick Analysis” option with excel.
When we are analyzing the data instead of going through various tabs we can make use of the Excel Quick Analysis tool to insert charts, visualizations, various formatting techniques, formulas, tables, pivot table, Sparklines.
These are can be done in a few seconds.
Where is Quick Analysis Tools in Excel?
Now all important question where is this tool. This tool appears when we select the data range in excel. For an example look at the below data.
Once we select the data we can see a small icon to the bottom right of the selection.
I know you have seen this icon before but you have not worried about this. Not many of the excel users make use of this wonderful tool. We will show what the various kinds of analysis tools it has are.
How to Use Quick Analysis Tools in Excel?
Below are examples of using quick analysis tools.
#1 – Quickly Insert Formatting to the Data
Once you select the data we can see the Quick Analysis tool icon at the bottom of the selection. Click on this icon to explore all the possible options.
We have “Formatting, Charts, Totals, Tables, and Sparklines”.
Let look at formatting now. Just place a cursor on the required formatting option we can see the immediate impact in our data.
I have placed a cursor on “Data Bars” it has inserted data bars according to the size of the numbers. Similarly, we can make use of “Color Set, Icon Set, Greater Than, Top Value and more importantly we can clear the excel formatting with “Clear” option.
Click on Color set to insert different colors.
Click on Icon Set to get icons for your numbers.
If you want to highlight all the values which are greater than 140 then click on the Greater option you will see below window.
Mention the value as 140 and choose the formatting color.
Click on OK, we will have mentioned formatting for all the values which are >140.
#2 – Quickly Analysis Inserting Chart to the Data
We can also insert a chart to the selected data by using Quick Analysis tool. Once the data is selected click on “Charts”.
Select the required chart here I have selected a clustered column chart, your quick analysis is ready to use.
Like this we can make use of various charts which suits our data structure.
#3 – Quickly Analysis through Totals
We can also insert totals to the data by choosing TOTALS under quick analysis. Under this, we have a various variety of formulas.
We can insert SUM, AVERAGE, COUNT, % Total, Running Total, SUM to the Right, Average to the Right, count to the right, running total to the right.
Based on the requirement we can make use of these formulas. Now I have applied RUNNING TOTAL.
We got the result for Running total as shown below:
Similarly, you can use SUM, AVERAGE, etc.
#4 – Quickly Analysis through Tables
A table will convert the range of data to table format data.
If you click on Blank it will insert a pivot table in the new sheet.
#5 – Quickly Analysis through Sparklines
We can insert Sparklines to the right of the data under SPARKLINES option.
Based on the selection we make it will display the Sparkline to the left of the data.
I have selected Column sparkline as shown below.
Like this making use of the “Quick Analysis” tool in excel, we can make a quick analysis of our data without breaking any sweat.
This has been a guide to Quick Analysis Tools in Excel. Here we discuss the top 5 tips to use quick analysis tools in excel with examples and downloadable excel template. You may learn more about excel from the following articles –