Dave Bruns

Because tables support structured references, you can learn a lot about a table with simple formulas. In this video, we'll look at some formulas you can use to query a table...

In this video, we'll look at how to copy and lock structured references in a formula. Structured references are a special syntax used by Excel Tables...

In this video, we'll review the key terminology associated with Excel Tables...

In this video, we'll look at different ways to remove a table from an Excel worksheet...

In this video, we'll look at how to create an Excel Table from source data on a worksheet...

What is an Excel Table? This video provides an introduction to Excel Tables.

When you first create an Excel Table, you'll see filter buttons automatically added to the top of each column. In this video, we'll look at how filters work in an Excel table...

Once you have an Excel Table, it's very easy to sort the data. In this video, we'll look at how to sort data in an Excel Table. ...

One of the most useful features of Excel Tables is that they create a dynamic range. In this video, we'll take a closer look at how table ranges work. ...

In this video, we'll look at how to work with rows and columns to structure data in an Excel Table...