Search Results for: excel

Results 1-10 of 56

How To Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]

October 3, 2014

Measuring year-over-year growth in your analytics data is oftentimes much more important than month-over-month traffic trends, especially if your business is seasonal. But even for non-seasonal sites like yours truly’s, it’s good to get the 100-foot view of how your site is performing compared to the same time last year. Here’s an example of how […]

How To Create A Scrolling Table In Excel [VIDEO]

October 3, 2014

id="" align="alignnone" width="3000"] Does this table ever end?[/caption] 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 allow more data in a small space, such as a dashboard. You can see how thi...

How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]

September 12, 2014

the page with a hard refresh. On a PC use Ctrl-F5 and Command-Shift-R if you're on a Mac. (I hate animated gifs that automate ad infinitum.) Excel File Download I don't share the whole dashboard, but I share a portion, so you can see how I used both the SUMIF and SUMIFS functions in a single ...

The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]

August 29, 2014

for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The reason is that it's very unstable and can bring large Excel files to their knees. Why? Every time you modify the file the OFFSET function takes that as a cue to go ahead and run again. It's not alone. Th...

Excel’s INDEX MATCH Alternative To VLOOKUP For Marketers [VIDEO]

June 27, 2014

these functions and you can use 0 in lieu of FALSE in a VLOOKUP, the range_lookup and match_type arguments accomplish identical objectives: telling Excel to only look for exact matches. Excel Download You can download the file I used in the video tutorial here. Image Credit: Oksana Taran on Unsplash

VLOOKUP Tips And Tricks For Marketers [VIDEO]

June 20, 2014

[caption id="" align="alignnone" width="3000"] See what I did there?[/caption] 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. S...

How To Find Text Within Text In Excel #FunctionFriday

March 28, 2014

to explore how to use the IF, SEARCH, and ISNUMBER functions together to find text (aka a string) inside other text for classification purpose. What Excel really needs is a CONTAINS function, so we don't have to do these mental acrobats. But, for now, this is what we have to work with. To illustrate ...

Three Marketing Examples Of The OFFSET Function [VIDEO]

March 7, 2014

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 there's nothing you can do with OF...

21 Real-World Examples Of Concatenating Marketing Data In Excel

February 21, 2014

Hey! Welcome to another edition of #FunctionFriday! One of Excel’s Swiss army knives for marketers is the ability to concatenate things and stuff. Oh, and if you're new to marketing geek speak, concatenate just means to stitch together. We just make words multi-syllabic so we can charge more for our se...

Easiest Way To Calculate Percent Delta in Excel

February 14, 2014

year-over-year (YoY) changes in data, and they should be in every reporting dashboard you build. Without exception. What is amazing to me is that Excel doesn't have this critical function built in like other investment apps such as usdcoin: usdm crypto and usdcoin wallet. So if you need to know the ...