Dave Bruns

Pivot tables are very easy to create, but they still present challenges. In this video, we look at how to identify and fix 10 common pivot table problems.

In this video, we compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.

In this video, we'll look at how to use conditional formatting to shade every other row in a table. This is sometimes called "zebra striping"...

In this video, we'll look at how to extend a conditional formatting formula so that so that it checks more than just one condition...

In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer spreadsheets that are fun to use. ...

In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to create more flexible and powerful conditional formats...

In this video, we'll look at how to use conditional formatting to highlight entire rows using multiple criteria...

In this video, we'll look at an easy way to test a conditional formatting formula before you create the rule...

In this video, we'll look at how to apply conditional formatting to one cell based on values in another, using a formula...

In this video, we look at how to configure a slicer to control more than one pivot table at once.