EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Quick Analysis
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Quick Analysis

By Madhuri ThakurMadhuri Thakur

Excel Quick Analysis

Excel Quick Analysis (Table of Contents)

  • Overview of Excel Quick Analysis
  • How to Use Quick Analysis Tools in Excel?

Overview of Excel Quick Analysis

Excel is tremendous while doing the data analysis; for this purpose, only excel has various kinds of formulas, tools, visualization charts, and many other kinds of stuff. Over a period of time, Microsoft has made handy updates with its new version of products, and similarly, in its 2013 version of excel, it has provided one more useful tool, i.e. “Quick Analysis”.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

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.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,368 ratings)
Note: This feature is available from Excel 2013 onwards.

What is Quick Analysis Tools in Excel?

When analyzing the data, instead of going through various tabs, we can use the Quick Analysis tool to insert charts, visualizations, various formatting techniques, formulas, tables, pivot tables, and Sparklines.

These can be done in a few seconds.

How to Use Quick Analysis Tools in Excel?

Here are some following ways to Operate Quick Analysis Tools in Excel.

You can download this Excel Quick Analysis Template here – Excel Quick Analysis Template

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.

Excel Quick Analysis Data

Once we select the data, we can see a small icon to the bottom right of the selection.

Excel Quick Analysis tool icon

I know you have seen this icon before, but you have not worried about this. Unfortunately, not many of excel users make use of this wonderful tool. We will show what the various kinds of analysis tools it has are.

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.

Excel Quick Analysis tool option

We have “Formatting, Charts, Totals, Tables, and Sparkline’s”.

Let look at formatting now. Just place a cursor on the required formatting option we can see the immediate impact in our data.

Formatting Data bars

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 formatting with the “Clear” option.

Click on the Color set to insert different colors.

Formatting Color

Click on Icon Set to get icons for your numbers.

Formatting Icon Set

If you want to highlight all the values greater than 140, click on the Greater option you will see below the window.

Formatting Greater than

Mention the value as 140 and choose the formatting color.

Formatting Greater than 2

Click on OK; we will have mentioned formatting for all the values, which are >140.

Formatting Greater than 3

Quickly Analysis Inserting Chart to the Data

We can also insert a chart to the selected data by using the Quick Analysis tool. Once the data is selected, click on “CHARTS”.

Excel Quick Analysis tool chart

Select the required chart; your quick analysis is ready to use.

Excel Quick Analysis tool chart 2

Like this, we can make use of various charts that suits our data structure.

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.

Excel Quick Analysis tool Formula

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.

formula running total

Similarly, you can use SUM, AVERAGE, etc.

formula average

Quickly Analysis through Tables

We can also insert the table format and pivot table to the data under Tables. Click on TABLES and choose the option you want to use.

Excel Quick Analysis tool table

The table will convert the range of data to table format data.

Excel Quick Analysis tool table 2

If you click on Pivot Table, it will insert the pivot table in a new sheet.

Excel Quick Analysis tool table 3

Quickly Analysis through Sparkline’s

We can insert Sparklines to the right of the data under the SPARKLINES option.

sparklines 1

Based on the selection we make, it will display the Sparkline to the left of the data.

sparklines 2

Like this, by making use of the “Quick Analysis” tool, we can make a quick analysis of our data without breaking any sweat.

Recommended Articles

This is a guide to Excel Quick Analysis. Here we discuss how to make use of the Quick Analysis tool to insert charts, visualizations, various formatting techniques, formulas, tables, pivot tables, Sparklines, along with a downloadable excel template. You may also look at the following articles to learn more –

  1. Pareto Analysis in Excel
  2. What-If Analysis in Excel
  3. Excel Regression Analysis
  4. Excel Tool for Data Analysis
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Training (23 Courses, 9+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Excel Quick Analysis Template

EDUCBA

Download Excel Quick Analysis Template

EDUCBA

डाउनलोड Excel Quick Analysis Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more