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

Show users how to create a quick table of contents in Excel using the power of hyperlinks.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

As I've shown above, if you need to create a small table, you can do it in Word instead of Excel. It's easy to manage its layout, you can sort its data and perform basic calculations using formulas.

Use these six shortcuts to select Table elements and insert columns and rows quickly in Microsoft Excel, making your use of Tables that much easier.

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