Tables

Hello Emma,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding the use of tables in Excel.

Once you format your data as a table you are presented with a table tools contextual tab which contains a design ribbon. On this ribbon there are a number of options available such as adding a 'Total Row', 'Removing Duplicates', 'Summarize with PivotTable' and so on. Autofilter buttons are added by default.

The data range is also easily expanded by clicking and dragging the corner of the bottom right-hand cell. When using your data in a PivotTable the range is dynamically increased and therefore when you refresh the PivotTable it will include all new rows and columns.

I feel that all these features make working with a table a great experience and you should try it out as much as possible.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer