# Data Analysis

## A collection of 63 posts

This example describes how to compare two lists using conditional formatting. For example, you may have two lists of NFL teams. To highlight the teams in the first list that are not in
24 October 2020
Use the solver in Excel to find the combination of capital investments that maximizes the total profit. Formulate the Model The model we are going to solve looks as follows in Excel. 1.
24 October 2020
Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost. Formulate the Model The model we are going to solve looks as follows in Excel.
24 October 2020
A bar chart is the horizontal version of a column chart. Use a bar chart if you have large text labels. To create a bar chart, execute the following steps. 1. Select the
24 October 2020
The data form in Excel allows you to add, edit and delete records (rows) and display only those records that meet certain criteria. Especially when you have wide rows and you want to
24 October 2020
A combination chart is a chart that combines two or more chart types in a single chart. To create a combination chart, execute the following steps. 1. Select the range A1:C13. 2.
24 October 2020
Color Scales in Excel make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell. To add a color scale, execute
24 October 2020
So far we have only seen charts on the same worksheet as the source data (embedded charts). However, you can also move a chart to a separate sheet that only contains a chart
24 October 2020
An area chart is a line chart with the areas below the lines filled with colors. Use a stacked area chart to display the contribution of each value to a total over time.
24 October 2020
Column charts are used to compare values across categories by using vertical bars. To create a column chart, execute the following steps. 1. Select the range A1:A7, hold down CTRL, and select
24 October 2020
This example teaches you how to create a checklist in Excel. First, turn on the Developer tab. Next, you can create a checklist. You can also insert a check mark symbol. To create
24 October 2020
Quickly format a range of cells by choosing a table style. You can also create your own table style. Quickly format a cell by choosing a cell style. Click any single cell inside
24 October 2020
This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria. When you use the Advanced Filter, you need to enter the criteria on
24 October 2020