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

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.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How to Make a Chart on Excel With More Than One Variable. One of the more useful features in Microsoft Excel is Insert Charts. You can create a wide variety of charts: bar, line, pie and others ...

Here are six tips to turn you into a spreadsheet pro whether you're using Microsoft Excel or Google Sheets. Alphabetize your data You can customize your spreadsheet data a number of ways ...