Tables- Critical for Excel use going forward
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.
You will notice that the formatting becomes much cleaner but it does more than that.
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).
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
To see the full course contents click here.