Excel Tables
Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables.Read more
Dave Bruns
How to use INDEX and MATCH with a table
In this video, we'll look at how to use INDEX and MATCH with an Excel Table. Using INDEX and MATCH with an Excel Table is wonderfully straightforward...
Basic timesheet formula with breaks
At the core, this formula subtracts start time from end time to get duration in hours. This is done to calculate both work time and break time.
MOD(C6-B6,1) // get work time
MOD(E6-D6,1) // get break time
Next, break time is subtracted from...Read more
How to remove duplicates from a table
In this video, we'll look at how to remove duplicates in an Excel Table...
How to use named ranges with tables
In this video, we'll look at how to use named ranges with Excel tables to create data validation or conditional formatting rules...
Index and match on multiple columns
Working from the inside out, the logical criteria used in this formula is this expression:
--(names=G4)
where names is the named range C4:E7. This generates a TRUE / FALSE result for...Read more
Data validation with an Excel table
In this video we'll look at how to apply data validation to an Excel Table...
How to set a default custom table style
In this video, we'll look at how to make a custom table style the default table style in new workbooks...
How to set up a running total in a table
Setting up a running total in an Excel table is a bit tricky because it's not obvious how to use structured references. This video explores some options...
How to copy a table style to another file
In this video, we'll look at how to move a custom table style into another Excel workbook...