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

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

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy