How to use Quick Analysis in Excel 2013

Description: To quickly change formatting, make charts, get totals, create tables, or insert sparklines you can access the quick analysis menu to perform these actions efficiently.

  1. When you have data in a spreadsheet and you want to quickly make a change to it, whether it be changing the formatting, making charts, getting totals, creating tables or inserting sparklines, all you have to do is highlight the data set, then in the bottom right hand corner you will see a box appear - click on that box.
    Excel Sample Data Set
  2. This will open the Quick Analysis menu where you can select formatting, charts, totals, tables, and sparklines.
    Excel Quick Analysis Menu
  3. For this example let's select charts. This gives us some options to choose from, the selection will be the most popular chart types, if you do not see your chart type click on more charts.
    Excel Charts
  4. Let's select the line chart. You will notice when you hover your mouse over line chart you will get a preview of what it will look like.
    Excel Sample Chart
  5. After you have picked a chart type, click on it to insert the chart into the spreadsheet.
    Excel Insert Data into Chart

Technical Support Community

Free technical support is available for your desktops, laptops, printers, software usage and more, via our new community forum, where our tech support staff, or the Micro Center Community will be happy to answer your questions online.

Forums

Ask questions and get answers from our technical support team or our community.
PC Builds
Help in Choosing Parts
Troubleshooting

Knowledge Base

Helpful articles written by Micro Center Experts.
ESET
Windows

Sign in for the best experience

Access helpful features and personalize your experience - Sign in or create an account now

Sign In
Don't have an account? Create Account