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 ones below I just added to my dashboard course for subscribers to apply to their data. Note: If you want to reanimate the images, just refresh the page with a […]
Search Results for: excel
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 join any number of data sets, as long as they have one column in common. Sadly, as is the case with most really useful Excel techniques, it […]
Three Marketing Examples Of The OFFSET Function [VIDEO]
UPDATE: I shared this post because I know marketers are quite fond of the OFFSET function. But I share a much more stable alternative to the OFFSET function. If you’re building out a dashboard or large Excel file, the INDEX function will take less of a toll on your workbook than its more volatile OFFSET counterpart. And […]