Excel Formulas

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

    … 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 simplify it for you a bit. Why A Histogram? Histograms are good for summarizing data into groups. Think about a teacher who has given a test and wants to know how many A’s, B’s, C’s, D’s, and F’s…

    Annie Cushing/ Annielyticsin How To's- 14 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- 21 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…

    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 […] The post 17 Real-World Examles Of Concatenating Marketing Data In Excel appeared first on Annielytics. …

    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!