Expanding tables automatically and adding totals


show more Expanding tables automatically and adding totals provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Setting Up a Database in Excel 2010 show less
please wait ...

Expanding tables automatically and adding totals

When you work with a Table you may need to add new records perhaps at the bottom of a table. You might want to add new columns to the right both of these will happen automatically you might even want to consider adding a total row. So let's take a look and see how these features work. In this particular list here I might want to add a record by inserting from within and you can usually right-click and Insert and add the data that way, if that seems appropriate, that's just fine. Excel will automatically include formulas where they exist in certain columns, so we could just fill in this data if we needed to, and then fill in this data.

We don't need to worry about this formulas; that's one approach. I am going to undo that. We might want to go the bottom here and maybe I am going to start typing and look what's happening here, Smith, Marion, I'll tab over, you can begin to see based on the formatting changes, this is automatically part of the Table, and so that means...

Expanding tables automatically and adding totals
Video duration: 4m 10s 43m 27s Appropriate for all

Viewers:

Expanding tables automatically and adding totals provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Setting Up a Database in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...