Login
Copyright

Quick Analysis in Excel

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next:

You're on a roll. Keep up the good work!

Take Quiz
 Replay
Your next lesson will play in 10 seconds
  • 0:00 The Quick Analysis Tool
  • 0:30 Accessing the Quick…
  • 2:50 How to Select an…
  • 4:40 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Login or Sign up

Timeline
Autoplay
Autoplay
Create an account to start this course today
Try it free for 5 days!
Create An Account

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Karen Sorensen

Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.

If you have ever thought about adding analytic elements to your worksheet, such as charts, conditional formatting or sparklines, then the Quick Analysis tool is for you. This lesson will introduce you to the tool and explain how easy it is to use.

The Quick Analysis Tool

There are many easy to use, time-saving tools in Excel. With each version, Microsoft looks at new ways to help the user take advantage of the powerful spreadsheet program. One that definitely sits at the top of my list is the Quick Analysis tool. This tool makes it super easy to add analytic elements to your worksheet, such as conditional formatting, charts and sparklines.

This lesson will introduce you to the Quick Analysis option. You will learn how to access the tool and how it can help you easily and quickly add analytic elements to your worksheet.

Accessing the Quick Analysis Tool

Excel has so many different ways to display data that at times it can be a bit overwhelming. Users often don't know the options exist, or, if they do, they are intimidated and afraid to use them. Thus, the Quick Analysis tool was born. One of the cool functions of the tool is that it allows you to preview many different ways you can display the same data.

To access the tool, you simply need to select the data you wish to analyze. It's that easy. When you highlight or select the data, the Quick Analysis icon appears in the lower, right-hand corner of the selected data. Doesn't get much easier than that. You don't have to look in the ribbon, search through different tabs or strain your eyes by scouring through the different command groupings. Just highlight the data and it's there!

Let's use an example. Assume you created a worksheet that displays the last five years of revenue results for your company. Each column is titled with each month of the year, with one row for Year 1, another for Year 2, and so on.

Numbers, Numbers, Numbers!

Sometimes, just a bunch of numbers on a page can be a bit boring. Using the Quick Analysis tool, you can easily spice it up a bit. If you select the data, including your titles, then click on the Quick Analysis tool, a dialogue box will appear.

In the dialogue box, you will see five different options for analytic elements. Let's take a look:

  1. Formatting: uses conditions to highlight specific data that meets certain rules
  2. Charts: these are the recommended charts or graphs to visualize your data, such as bar, column, and line
  3. Totals: you can instantly add formulas to perform calculations, such as average and sum
  4. Tables: to sort and filter your data
  5. Sparklines: these are mini charts added to a single cell

Hovering your mouse over the different options will give you a preview of what the element will look like. This makes it easy to choose the right one for your selected data.

How to Select an Analytical Element

Now that you know how to access the Quick Analysis tool, let's take it a step further and apply an element to the data. We will also answer whether you can add more than one element to a worksheet.

Looking at an example worksheet with revenue numbers from the last five years, assume you would like to add a chart. Click on the Quick Analysis icon or command and choose 'Charts'. Immediately, Excel displays the recommended charts for your data. Hover over each chart to see the style and type that has been recommended.

Using the Clustered option
chart with added clustered option

If you select the 'Clustered' option, you'll notice that Excel loads the chart with your revenue results, adds the dollar amount legend on the left and months across the bottom. With just a couple clicks, you have added a chart to your worksheet. With the chart selected, click and hold your mouse to move the chart anywhere on the worksheet. Easy!

To unlock this lesson you must be a Study.com Member.
Create your account

Register for a free trial

Are you a student or a teacher?
I am a teacher
What is your educational goal?
 Back

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back

Earning College Credit

Did you know… We have over 95 college courses that prepare you to earn credit by exam that is accepted by over 2,000 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it free for 5 days!
Create An Account
Support