From the course: Excel: Advanced Formulas and Functions

Developing your own style with formulas and functions

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Developing your own style with formulas and functions

“

- Okay, now this is serious. Before we get into the course, I want to tell you... No, I want to invite you and give you permission to find your style of how you want to work with Excel. There are people who write big formulas, people who write helper columns, people who put different things on different sheets and then bring 'em all back and summarize 'em on another sheet. There's all kinds of different ways of working. There are people who like named ranges. I personally don't like named ranges. I don't think they're evil, I just don't use 'em. And I'm saying to you, use what works for you in your style, what you are comfortable with. If you prefer working with the interface versus writing a lot of things from scratch, that's okay. As long as you are delivering for the people who need what you are providing, that's what's most important. Are they happy? And I'm going to tell you one thing. I've spent years as an analyst, and nobody has ever said, "You know, my commission's calculated right, but you used helper columns," or, "You used this big massive formula," or "You didn't use named ranges, or you used V Look." No, they never said that. The work was accurate in my style, the way I worked in order to get things done for them. So if you see another Excel user, and they're doing some impressive things, sure, learn from that. Continue to expand and learn and grow. But also, don't apologize if you're not somebody who likes writing big monster formulas. This is about you and the people who rely on what you do. This is not about impressing other Excel users. Develop your own style, unapologetically.

Contents