Wednesday, August 8, 2012

Excel 2013 Quick Analysis Tool

Have no doubt about it – Excel 2013 brings an improved interface and several Really Cool New Tools!

One of my favorites is the Context-Sensitive Quick Analysis Tool. This great new gizmo makes it considerably easier to take the data in your worksheet and enable the creation of:

1. Charts
2. Tables
3. Pivot Tables
4. Sparklines
5. Conditional Formatting
6. Totals

All that you need to do is select a range of data, click the Quick Analysis icon that appears to the lower-right, and an easily navigated box of suggestions pops up giving access to all manner of analysis options.

The Quick Analysis tool is Truly Brilliant at allowing users to perform complicated tasks with a few quick taps. For instance, in the example below, the range from B3:D18 was selected, generating the Quick Analysis tool Icon that reveals the Major Categories of Formatting, Charts, Totals, Tables, and Sparklines. Clicking on any of the Major Categories gives you several options from which to choose.

The Quick Analysis Tool. One more reason to consider upgrading to the latest version of Excel. As I often tell my students, it is good to stay current with the latest versions of software, lest you wake up one day terribly behind the technology curve.

1 comment:

Home Services said...

This discussion will focus on the role Excel plays in data analysis and how the Quick Analysis tool for Excel helps you understand complex spreadsheets. You will also learn about ChartExpo, a charting tool for Excel that enables you to produce better visual representations of your data.