Why Include Dynamic Links in Dashboards When I create dashboards, I like to add as many resources as possible for stakeholders who want more … [Read more...]
How To Create A Scrolling Table In Excel [VIDEO]
In today's video I demonstrate how to create a scrolling table in Excel using the scrollbar option in your format controls. This is a great way to … [Read more...]
How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]
In today's #FunctionFriday post we're going to look at how the SUMIF and SUMIFS functions can be used to build out interactive dashboards like the … [Read more...]
The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]
Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The … [Read more...]
Excel’s INDEX MATCH Alternative To VLOOKUP For Marketers [VIDEO]
Last week's #FunctionFriday video tutorial covered VLOOKUP tips and techniques for marketers. This week's video explores the INDEX MATCH alternative … [Read more...]
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 7
- Next Page »