Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
When you create a table in Excel, what happens?
Nothing, you have to set all the characteristics above manually.
Alternate row color banding is added to the table.
Filters are automatically added to the header row.
Excel tables come with a new style of formulas called Structured Table Referencing. What happens when a classic A1 style of formulas that you are used to writing is entered in an Excel table cell?
A1 style formulas are replaced by the new formula style and automatically run down the entire column
A1 style formulas cannot be used in tables.
A1 style formulas function as normal, but are automatically run down the entire column
Formatting a range of data as an Excel table can apply color banding, immediately adds a name to the table (which always covers the entire table range), and also adds filters. Which of is the most difficult to replicate on a range of data that is not set up as an official Excel table?
Alternate row color banding
Adding filters to a list of data
Ensuring a VLOOKUP is always pointed at the entirety of the target data