Here are my top 10 secrets for managing lists of data using Excel Tables. 1. Create a Table in Any of Several Ways You can create a table from the Insert tab or (as here) from the Home tab, where ...

Excel will present a few options for you to consider. In our example, Excel offers to create 10 different pivot tables that take a look at a number of different angles on our sales data.

How to Choose Random Sampling in Excel. Randomly selected samples from a larger population prevent bias in statistical procedures while avoiding the hassle of dealing with the entire dataset.

The CHOOSE function in Microsoft Excel is a Lookup and Reference function, and its purpose is to choose a value from a list of values. Learn how to use it.

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.

The first example in the accompanying Excel workbook and video contains a list of companies, as shown below on the left. After creating the list of companies, select the entire list of companies, go ...