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...]
VLOOKUP Tips And Tricks For Marketers [VIDEO]
The VLOOKUP function in Excel is one of the most essential functions marketers need to master. It's a staple in my tool set because it allows you to … [Read more...]
How To Find Text Within Text In Excel #FunctionFriday
Update: Based on questions I've received, I added the Misc Notes section to the end of this post. Continuing with our #FunctionFriday series, today … [Read more...]
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 7
- Next Page »