Executive Training Solutions

If you’ve been using Microsoft Excel 2007 for a while, you might have noticed the button on your Ribbon referring to tables.  Tables are a new feature in Microsoft Excel 2007 and are useful in a few different ways.

When you convert a range of cells into a table, you can manipulate and format it separately from the rest of the worksheet.  And formatting it is extremely easy using the themes and styles built into Excel 2007!

When you convert a range into a table, you will notice drop-down arrows at the top of each column.  This makes filtering and sorting very easy!  You can also easily add additional rows or columns of data into your table and know that it will be included in the previous data.

Instead of selecting an entire range, you only need to click in any cell within a table to select the entire table.

Tables cannot have blank rows or blank columns, but applying the various themes and styles provide formatting to help differentiate the different data contained within your table.

Finally, if you use SharePoint, it is a simple step to export a table into a SharePoint list which means you don’t have to share an entire workbook!

For more tips and tricks on using Microsoft Excel, please visit one of our classes.  We’re looking forward to helping you learn more about this great piece of software.