Spreadsheets

It’s time to get your hands dirty, because today we’re delving into the details of creating a Recency-Frequency Matrix using a spreadsheet. If you’ve been keeping up with our “My Favorite Analyses” series, you’ll recall that last week we talked about the value of the Recency-Frequency Matrix in dividing customers into groups and improving marketing […]

In our discussion on creating a C3 chart a few weeks ago, we generated a great deal of discussion. The concept of cohort analysis obviously hit home and quite a few of you wanted to know more. Specifically, we received numerous requests for guidance on preparing data for this type of analysis. In today’s post, […]

Today we wrap up our Spreadsheet Fundamentals series with a lesson on the essentials of data visualization. This guide will equip you with the skills to turn extensive numerical data into compelling visual narratives in spreadsheets, adding impact and clarity to your analyses. How Spreadsheets Help Us Visualize Data With their ability to reveal hidden […]

We are delighted to continue our exploration of Spreadsheet Fundamentals with a tutorial on LOOKUP functions. In this lesson, we dive into the fundamentals of retrieving and combining data seamlessly from various datasets using Excel and Google Sheets. Whether you’re dealing with massive data or merging information from different sources, mastering these lookup functions will […]

As we continue our tour through Spreadsheet Fundamentals, we are excited to present to you a special tutorial on mastering text functions in spreadsheets. Whether you are consolidating data for analysis or extracting specific text segments, these abilities are crucial for any data analyst. In this lesson, we will concentrate on two vital tools: the […]

Today we’re continuing our focus on spreadsheets by delving into one of the most essential functions in both Google Sheets and Excel: the mighty IF statement. Whether you’re a beginner or an experienced data expert, mastering the art of IF statements will greatly improve your ability to process and analyze data. Let’s take a deeper […]

In light of this month’s Excel World Championship (yes, it is indeed a thing), we will be exploring a fundamental aspect of using spreadsheets in this week’s Art+Science blog post. Our focus is on an important step in data preparation: tidying up messy text in spreadsheets. This stage is essential to ensure that your data […]