课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Formula vs. helper columns

Formula vs. helper columns

课程: Excel: Advanced Formulas and Functions

开始一个月试用 购买团队方案

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…

内容