Excel Formulas

  • How To Create Histograms For Marketers In Excel [VIDEO]

    … the individual students; we’re getting more of a bird’s eye view of the performance of the entire class. Make sense? Great! Practice File You can download the Excel file I used in the video from Dropbox here. Steps I took a list of blog posts from my site that I ran last year in Screaming Frog and wanted to see a distribution (got tired of writing…

    Annie Cushing/ Annielyticsin How To's- 12 readers -
  • How To Create A Scrolling Table In Excel [VIDEO]

    … How To Create A Scrolling Table In Excel [VIDEO] October 3, 2014 by Annie Cushing Leave a Comment Does this table ever end? 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…

    Annie Cushing/ Annielyticsin How To's- 20 readers -
  • How To Find Text Within Text In Excel

    … Continuing with our #FunctionFriday series, today we’re going 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 […] The post How To Find Text Within Text In Excel appeared first on Annielytics. …

    Annie Cushing/ Annielytics- 5 readers -
  • 17 Real-World Examles Of Concatenating Marketing Data In Excel

    … 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 services. Two Approaches Excel gives…

    Annie Cushing/ Annielytics- 1 readers -
  • Easiest Way To Calculate Percent Delta in Excel

    … When To Use It A bedrock of marketing is the calculation of percent change. (Real analysts call it percent delta … just so you know.) We use these to show month-over-month (MoM) and year-over-year (YoY) changes in data, and they should be in every reporting dashboard you build. Without exception. What is amazing to me […] The post Easiest Way…

    Annie Cushing/ Annielytics- 3 readers -
Get the top posts daily into your mailbox!