Around the end of the year, the data team gets a lot of requests from the editorial teams to pull which posts had the highest traffic that year. Usually, they’re looking to figure out which of the posts they wrote that year did the best - but there are always posts that were published in previous years that gain…

Do you ever find yourself using the same formula, day in and day out, and think, “Wow, I wish Excel just had a function for this.” Turns out, you can create your own functions in Excel to do whatever you want (for the most part)!

Excel’s built-in conditional formatting options are great for a lot of use cases, but what if we wanted to highlight a whole row when one of it’s cells meets some criteria, instead of just highlighting the one cell? Or what if we want to highlight a cell only if the cell is greater than 10 AND the cell in column A…

I started appreciating the wonders of conditional formatting when I was working in Ad Operations and in charge of a daily delivery report, which was basically a giant data dump on all currently live ad units. It was my job to parse through the data and figure out which units were at risk of underdelivering (and losing…

Here at Gawker, we’ve dabbled with A/B testing before, but 2015 was the first year we started taking testing seriously. A/B tests are now an integral part of our product workflow, helping us make smarter, better informed decisions.

Here at Gawker, we run a lot of A/B tests. A focus for us lately has been testing the new recommended post module, as we move away from our basic “popular stories” recommendations to a more personalized algorithm. During the analysis of this test - and after a long conversation with the Google Analytics support team -…

The Microsoft Excel team was on Reddit yesterday holding an AMA. Users got to grill the team about their biggest Excel pet peeves, beg for long awaited feature requests, and of course, make some good ol’ fashioned Excel puns:

I attended Quantcast’s Supernova Big Data Summit last Thursday in New York. Most of the talks were less about data and more business/marketing oriented (talks like “Death of the Traditional RFP: Rise of the Programmatic Specialist” were not really for me) but there were a lot of great speakers.

Do you ever find yourself highlighting rows and rows of data by dragging your mouse? Or changing a cell to an absolute reference by manually typing dollar signs into your formula? Stop doing all of that – use keyboard shortcuts instead.

IF statements may seem scary – after all, they involve logic, they’re an “advanced” Excel topic, and what the heck is a Boolean! Take a deep breath. This article will walk you through the basics of writing IF Statements in Excel and teach you how they can make your life easier and more productive. IF Statements are a…