Thursday, October 29, 2015

Use Quick Analysis to Explore Your Data in Microsoft Excel

Microsoft Excel - One Cool Tip www.onecooltip.com
Excel is the standard for spreadsheets and data analysis.  There are thousands of ways to sort, analyze and view data.  But with so many options, it can be hard to do quick analysis, especially for novice users.

There is a quick way to explore your data.  It's "Quick Analysis".

It's simple to use and since it's so close to your data, you can quickly analyze your data.

Here's how to use it.

  • Select a data set in your spreadsheet. See our cool tip HERE.
  • Look for the small box in the bottom right-hand corner of the selected data.  You can also you the keyboard shortcut of "Ctrl + Q".
  • Click the icon to display the Quick Analysis menu.


Microsoft Excel - Quick Analysis - One Cool Tip www.onecooltip.com

Select between the various options: Formatting, Charts, Totals, Tables and Sparklines to quickly analyze your data.

That's it.  Enjoy!



No comments: