Data Analysis is simpler and faster with Excel analytics. Here, we offer some tips for work:
Create auto expandable ranges with Excel tables: One of the most underused features of MS Excel is Excel Tables. Excel Tables have wonderful properties that allow you to work more efficiently. Some of these features include:
Formula Auto Fill: Once you enter a formula in a table it will be automatically be copied to the rest of the table.
Auto Expansion: New items typed below or at the right of the table become part of the table.
Visible headers: Regardless of your position within the table, your headers will always be visible.
Automatic Total Row: To calculate the total of a row, you just have to select the desired formula.
Use Excel Tables as part of a formula: Like in dropdown lists, if you have a formula that depends on a Table, when you add new items to the Table, the reference in the formula will be automatically updated.
Use Excel Tables as a source for a chart: Charts will be updated automatically as well if you use an Excel Table as a source. As you can see, Excel Tables allow you to create data sources that do not have to be updated when new data is included
How to Analyze Data in Excel: Data Visualization
Quickly visualize trends with sparklines: Sparklines are a visualization feature of MS Excel that allows you to quickly visualize the overall trend of a set of values. Sparklines are mini-graphs located inside of cells. You may want to visualize the overall trend of monthly sales by a group of salesmen.
To create the sparklines, follow these steps below:
Select the range that contains the data that you will plot (This step is recommended but not required, you can select the data range later).
Go to Insert > Sparklines > Select the type of sparkline you want (Line, Column, or Win/Loss). For this specific example, I will choose Lines.
Click on the range selection button Select Range Excel Button to browse for the location of the sparklines, press Enter and click OK. Make sure you select a location that is proportional to the data source. For example, if the data source range contains 6 rows then the location of the sparkline must contain 6 rows.
To format the sparkline you may try the following:
To change the colour of markers:
Click on any cell within the sparkline to show the Sparkline Tools menu.
In the Sparkline tools menu, go to Marker Color and change the colour for the specific markers you want.
For example High points on the green, Low points on red, and the remaining in blue.
To change the width of the lines:
Click on any cell within the sparkline to show the Sparkline Tools menu.
In the Sparkline tools contextual menu, go to Sparkline Color > Weight and change the width of the line as you desire.
Save Time with Quick Analysis: One of the major improvements introduced back in Excel 2013 was the Quick Analysis feature. This feature allows you to quickly create graphs, sparklines, PivotTables, PivotCharts, and summary functions by just clicking on a button.
When you select data in Excel 2013 or later, you will see the Quick Analysis button Quick Analysis Excel Button in the bottom-right corner of the range selected. If you click on the Quick Analysis button you will see the following options:
Formatting
Charts
Totals
Tables
Sparklines
When you click on any of the options, Excel will show a preview of the possible results you could obtain given the data you selected.
If you click on the Quick Analysis button and go to charts, you could quickly create the graph below just by clicking a button.
If you go to Totals, you can quickly insert a row with the average for each column:
If you click on Sparklines, you can quickly insert Sparklines:
As you can see, the Quick Analysis feature really allows you to quickly perform different visualizations and analysis with almost no effort.
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive
digiexclusive