Histogram charts are great tools for marketers, but unfortunately Excel doesn't make the process of creating them terribly intuitive. But I'll try to … [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...]