Leadership and data. Two of my passions. Of course, my bigger passion is helping leaders be more effective at using data. One of the biggest obstacles that many leaders face is not understanding the tools that are available to them. I’ve seen a lot of people waste a lot of time manually performing tasks that Excel can do automatically in a fraction of the time. The result, managers and leaders spend more time manipulating data than they do in thinking about what it means.
I’ve put together an overview of five Excel features and functions that I believe every manager and leader should know. These are all productivity functions. None of them help answer a specific question or perform a specific type of analysis. Their purpose is to make leaders more efficient at any analysis they are conducting.
The functions and features listed in this document can literally turn a two hour task into a ten second operation.
My real goal is to start focusing on helping leaders learn to think differently about data and interpreting information. However, I realize that they can’t begin that journey if they are spending all of their time cutting and pasting, sorting, and highlighting things manually.
At some point I hope to use this guide as an entry point for my blog. I’ll offer it as a free report to anyone who signs up for a feed. However, right now I’d like feedback. I’d like to know if these features and functions are things you already know about, if the explanations are clear, or if something is missing.
So, I’m enlisting my small but loyal band of readers to help me help leaders become more efficient in using information.
I’ve attached a link to the article. Please provide your feedback. I’ve love to hear from you.
http://www.bradkolar.com/articles/Five%20excel%20functions%20that%20every%20business%20person%20should%20know.pdf
Thanks!
Great article you referenced.
My favorite thing to do with Excel is to use the concatenate function to write repetative scripts and batch files.
Thanks.
Steve
http://teamvie.blogspot.com/
Hey Steve,
Good tip. I’ve developed an entire add-in full of custom functions and macros to help with those pesky repetitive tasks!! It’s amazing how much time a few good functions can save!
Thank you for this. I don’t have much experience in using excel which I guess explains my lack of competence with it despite taking a class in it. I believe that some new work assignments might drive my need for this using it. I’m grateful that you wrote this. I’m sure it will be a helpful resource. Thanks.