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...
Dave Bruns
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.
Formulas to query a table
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...
How to copy and lock structured references
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...