From the course: Excel for Marketers (2023)

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Building complex formulas the easy way

Building complex formulas the easy way - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Building complex formulas the easy way

“

- [Instructor] Have you ever stumbled upon an Excel formula so complex, you couldn't imagine how it was constructed? Well, actually, there's a foolproof trick for building this type of complicated formula. Let's see how it works. So, the first step of building any complex formula is to build it the easy way first, step by step. And that's what I've done here. And this spreadsheet you might recognize from one of the earlier courses on how to check the test duration of an AB test. So, what we have here are the inputs on this left hand side and then we've broken the calculation down into a series of steps. Each one of these steps is relatively simple, so in this case, it's the conversion rate, divided by one minus the conversion rate and then the square root and then we divide by the conversion rate, times target improvement and so on. But that's really useful for calculating it in the first place and checking there's no…

Contents