Tuesday, October 3, 2017

3 Ways to Analyze Data in Excel

You used to have a bit more skill to analyze data using Microsoft Excel, but these days (specifically Excel 2013 and newer versions), there are quite a few built-in features which make data analysis with Excel very simple.

Here are three (3) ways to analyze data in Excel using the Quick Analysis icon:

1) Quick Analysis - Charts
2) Quick Analysis - Totals
3) Quick Analysis - Tables

Notice anything similar? Yes, the Quick Analysis icon allows you to format data in a few simple steps. There are actually many different options within each of the three. And, there are actually 5 different Quick Analysis options, but I am highlighting 3 that are typically used for analyzing data.

To use the Quick Analysis icon, simply highlight your data and use the Quick Analysis icon that appears in the lower right corner of the data. From there, you can easily select the option you need in order to view the data in the way you would like to showcase it.

To see how this works in detail, watch the video below.

No comments:

Post a Comment

How to Delete Blank Rows in Excel