EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tools Excel Quick Analysis
 

Excel Quick Analysis

Madhuri Thakur
Article byMadhuri Thakur

Updated June 7, 2023

Excel Quick Analysis

 

 

Excel Quick Analysis (Table of Contents)

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

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

Overview of Excel Quick Analysis

Excel is tremendous while doing 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”.

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.

Note: This feature is available from Excel 2013 onwards.

What are 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 are Quick Analysis Tools in Excel?

Now the important question is where this tool is. 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 at the bottom right of the selection.

Excel Quick Analysis tool icon

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

Quickly Insert Formatting into 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’s look at formatting now. Just place a cursor on the required formatting option we can see the immediate impact on 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 use “Color Set, Icon Set, Greater Than, Top Value, and, more importantly, 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 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 into the Data

We can also insert a chart to the selected data 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 use various charts that suit 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, and 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 the 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 our selection, it will display the Sparkline to the left of the data.

sparklines 2

Like, by using the “Quick Analysis” tool, we can quickly analyze 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, and 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

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Excel Quick Analysis Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Excel Quick Analysis Template

EDUCBA

डाउनलोड Excel Quick Analysis Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW