How to add a totals row to a Table
In this video, we'll look at how to add and configure a Total Row to an Excel Table. The Total Row can automatically show summary calculations below a table...
Dave Bruns
How to use VLOOKUP with a table
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
How to use table slicer styles
In this video, we'll look at how to use slicer styles to control the look of slicers. You can use styles to quickly change a slicer, and keep slicers consistent...
How to use table slicer options
Table slicers have a variety of settings. In this video, we'll look at how to configure available options.
...
How to add a slicer to a table
In this video, we'll look at how to add one or more slicers to an Excel table. Slicers let users filter data with large, friendly buttons...
Basic inventory formula example
This formula demonstrates a very simple inventory concept where current inventory is simply the result of all incoming stock minus all outgoing stock. In the example, colors are treated as unique item identifiers – imagine a product available in one size only in just three colors: red, blue, or...Read more
How to use SUMIFS with an Excel Table
In this video, we'll look at how to use the SUMIFS function with an Excel table, with a side-by-side comparison without a table...
Introduction to structured references
This video provides a brief introduction to structured references. Structured references are an easy way to refer to tables in Excel formulas.
Structured references inside a table
In this video, we'll look at how to use structured reference syntax inside a table...
Structured reference syntax examples
Structured references are used to refer to Excel tables in formulas. In this video, we get into the nitty gritty with many examples.