How to Make a Frequency Table on Microsoft Excel. A frequency table tabulates the number of times values from a data set appear within a configured range. As an example, you might have a list of ...

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

Yet, one of the biggest mistakes marketers make is trying to wrangle static data instead of taking advantage of Excel’s table formatting, which basically turns your data range into an ...

Fetching live data Since we're dealing with live data to create the dashboard, the first step is to link Excel with the data source so that all the required data can be fetched in real-time.

Fortunately, a few quick formatting tricks will make them stand out, loud and clear. How to format subtotals in Excel What this list needs is some formatting to make those vendor subtotals stand out.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

Learn 10 cool techniques that will make your Excel charts way sexier.