In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart for dashboards and other reports.
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name inside VLOOKUP, instead of hardcoding the column number. As a bonus, you can reorder the columns and the formula will keep working correctly.
Conditional formatting with formulas can be tricky because you can't see what happens to the formula when the rule is applied. Dummy formulas let you visualize how formulas will behave before you create a rule. This video shows you how to test with dummy formulas, for perfect conditional formatting, every time.
In this video, we'll look at how to build a two-way lookup with INDEX and MATCH, using approximate matching. This is a classic solution for non-exact lookups like income tax, shipping costs, material costs, etc.