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 ...

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

How to insert a table using Excel Spreadsheet On the Insert tab, click the Table button in the Tables group. On the drop-down menu, select Excel Spreadsheet.

Learn how to create a Pie Chart in Excel with percentages, without numbers, with words, multiple data or columns, etc. A pie chart helps understand data spread.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

Calculate R-squared in Microsoft Excel by creating two data ranges to correlate. Use the correlation formula to correlate both sets of data, or x and y.

Excel's Insights feature uses AI and machine learning to indicate patterns in data that can help your decision making, but there are several caveats to consider along the way.

Learn how to calculate net current assets, or working capital, in Microsoft Excel and how to evaluate the financial health of a company.