Without freezing rows or columns in your Excel spreadsheet, everything moves when you scroll through the page, as shown in the gif below. This can be frustrating if you can’t always see key data markers that explain what data is what, like column headers or row titles. As with many things on Excel, there are tricks…
Your Brief Guide to Using Goal Seek in Excel
Successful marketers make informed decisions quickly using a combination of gut instincts and data analysis. They know the end goal, and figure out what it takes to get there. One way to fill in those gaps is by using Goal Seek in Excel. The function is helpful when you know your desired result, but you’re…
How to Find and Remove Duplicates in Excel
“I’ve never been a natural, all I do is try, try, try.” These Taylor Swift lyrics, in the song “mirrorball“, perfectly explain my relationship with numbers, math, and anything concerning data analytics. However, as a marketer, data analysis is one of the most important aspects of my job. But like most marketers, who prefer strategy…
How to Merge Cells in Excel in 5 Minutes or Less
Knowing the ins and outs of Excel is essential for organizing data, understanding analytics, and getting the most from your marketing efforts. The tool is great for quickly processing vast amounts of data, but it can be overwhelming if you don’t spend the majority of your workday whipping up spreadsheets. Fortunately, a few basic skills…
How to Create a Pie Chart in Excel in 60 Seconds or Less
At the beginning of 2021, I was tasked with an assignment: Create a pie chart showcasing which types of content performed best on the Marketing Blog in 2020. The question was an undeniably important one, as it would influence what types of content we wrote in 2021, along with identifying new opportunities for growth. But…