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...
Dave Bruns
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...
All values in a range are at least
At the core, this formula uses the COUNTIF function to count any cells that fall below a given value, which is hardcoded as 65 in the formula:
COUNTIF(B5:F5,"<65")
In this part of the formula, COUNTIF will return a positive number if...Read more
How to create a new table style
In this video, we'll look at how to create and modify your own custom table style...
How to apply a table style
In this video, we'll look at how to apply a table style. Table styles quickly change the look and feel of an Excel Table.
...
Introduction to table styles
In this video, we'll introduce Table Styles. Table styles make it easy to save and apply table formatting...
Conditional formatting formula in a table
In this video we'll look at how to apply conditional formatting to a table with a formula...
How to use Calculated Columns
In this video, we'll look more closely at calculated columns in Excel Tables, a feature to automatically enter and maintain formulas...
Excel Table Options
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas...