Anatomy of an Excel Table
In this video, we'll review the key terminology associated with Excel Tables...
Dave Bruns
How to remove an Excel Table
In this video, we'll look at different ways to remove a table from an Excel worksheet...
How to create an Excel Table
In this video, we'll look at how to create an Excel Table from source data on a worksheet...
What is an Excel Table
What is an Excel Table? This video provides an introduction to Excel Tables.
How to use Table filters
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...
How to sort 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.
...
How Excel Table ranges work
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.
...
Working with table rows and columns
In this video, we'll look at how to work with rows and columns to structure data in an Excel Table...
Count dates in current month
At the core, this formula uses the COUNTIFS function to count dates that are greater than or equal to the first day of the current month, and less than the first day of the next month. The EOMONTH function is used to create both dates...Read more
Sum every 3 cells
At the core, the OFFSET function delivers a range of 3 cells to SUM, which returns a summed result.
The arguments for OFFSET are provided as follows:
For reference we use the first cell in the data range, B5, entered as a ...Read more