# How to use data tables

Data tables are orderly arrangement of data, especially one in which the data are arranged in columns and rows

1. article Completed

### Learn Excel Data Tables

&nbsp;Excel table is a series of rows and columns with related data that is managed independently. Excel tables, (known as lists in excel 2003) is a very powerful and supercool feature that you must learn if your work involves handling tables of data. This is a text tutorial on all the important tricks you need to know.

Edit Remove
2. article Completed

### Articles on Excel Tables

Last week, we had a lovely poll on what are your favorite features of Excel? More than 120 people responded to it with various answers. So I did what any data analyst worth his salt would do, I analyzed the data and here are the top 10 features in Excel according to you.<br><br>This is a great list of important features in Excel!

Edit Remove
3. article Completed

### Making a chart with dynamic range of values

Learn how to make the chart series data dynamic, thus when you add or remove rows the chart gets automatically updated. You can use excel tables or OFFSET formula to do this. Use this tutorial (and downloadable example) know how to do this using Microsoft Excel.

Edit Remove
4. article Completed

### Using Lookup Formulas with Excel Tables

Excel Tables, a newly introduced feature in Excel 2007 is a very powerful way to manage &amp; work with tabular data. I really like tables feature and use it quite often. If you are new to tables, read up Introduction to Excel Tables.In this short video tutorial I explain how to combine VLOOKUP, INDEX, MATCH formulas with Excel Tables. This is a great video tutorial and really helps you develop your skills.

Edit Remove
5. video Completed

### Setup Database in Excel

See how to create a simple database in Excel using the List or Table feature. A simple database can be created in Excel using the Excel 2003 "List" feature or the Excel 2007 "Table" feature. Fields names must be in first row (no blanks). Records are in rows (no blanks).

Edit Remove
6. article Completed

### 8 Tips to Make you a Formatting Pro

We can take any Excel workbook and format it until Christmas, and we would still not be done. But not many of us have so much of time or energy. So, today, lets talk formatting. This gives you eight great tips on how to format. It is super easy to follow and is a great guideline.&nbsp;

Edit Remove