Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

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

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

We won't be able to create pivot tables without this, which are essential for creating a dashboard. To do this, select the imported data and navigate to the Insert section in Excel.

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

In this guide Kenji explains how to build your own multi-step data entry form from scratch, using Excel’s capabilities to create an interactive and dynamic tool.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Having covered all the basics of how to make tabular data tell a story using custom cell formatting and conditional formatting for both static tables and pivot tables, we’re now going to jump ...

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