From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

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

Formula vs. helper columns

Formula vs. helper columns - Microsoft Excel Tutorial

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Formula vs. helper columns

“

- [Instructor] When I was thinking about this course, Advanced Functions in Formulas, I figured I didn't want to just show you exotic, obscure functions or wild formulas. I also wanted to give you some strategy. In this video, we're going to talk about writing formulas versus helper columns. And you need to be able to decide based on your skill, your comfort, this situation, all of those will dictate whether you use helper columns or formulas. In this situation, with all of these meeting spaces from 37th Avenue down to The Triton, we want to calculate the square meters for all venues that have both Wi-Fi and a projector. For other venues, we want those to stay blank. So City Center Q, it doesn't have a projector, so we do not want square meters filled in for that venue. All right, let's go to the helper columns tab. So we had used helper columns for intermediate steps towards our goals. Let's get started here. (mouse…

Contents