From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Formula vs. helper columns

Formula vs. helper columns

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 and 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, the 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. Go here, say…

Contents