Tables- Critical for Excel use going forward

Please purchase the course before starting the lesson.

Tables are a new feature in the more recent versions of Excel.

If you have a block of data, you can switch the table on by highlighting the block, clicking on INSERT and TABLE.

Tables in Excel

You will notice that the formatting becomes much cleaner but it does more than that.

Tables in Excel

 

Add a slicer to a table and see the impact on a chart (Excel 2013+ only)

Below we have created a Table with a chart(in Excel 2013 and higher only).

Tables in Excel

After you have placed your slicer, if you choose one of the options you will note that not only does the table change to only show the chosen items, but the chart only shows the visible cells results and will automatically resize both the horizontal and vertical axis for the best fit

Tables in Excel

To see the full course contents click here.

Back to: Advanced Excel Course > Tips and Tricks- Advanced