A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Being Excel gurus in your offices or Excel consultants to many different companies, you are always assumed to be at odds with the IT guys. But the need of the hour is not to have these alpha battles but to collaborate effectively.
The technology landscape is changing really fast and the business needs are evolving even faster. Addressing this situation calls for formation of an alliance with the IT personnel. All the way from our Excel experts, we present to you some tips to achieve this outcome.
Most IT guys are expected to not be avid Excel users, let alone come from a rigorous programming background to deal with your VBA codes. Hence, it is always a good idea to bring as much into the spreadsheet as is possible and let Macros run behind the scenes. This means that developing user-friendly interfaces, where one can just input data and press a button to do something, should be the norm rather than a one-off thing.
Conflicts can never be resolved through “who’s right” arguments. Collaborating with the IT people is definitely the way forward. It is important to realize that they excel at what they do, for example pulling data into a spreadsheet from a data warehouse. And, as expert Excel users, we are better at analyzing and using that data. The functions of these two sets of people complement each other. And we need to highlight this fact.
Also, it is important to note that the gap between the IT personnel and Excel experts is narrowing as Power BI is evolving into a much more complex set of tools.
Sharing the spreadsheets created by you is always a dreaded task. This is so as we ultimately expect to receive hundreds, if not thousands, of queries on what is going on! Well, there are a few things you can do to make this task lesser dreaded or, maybe, even fruitful:
This can be a very frustrating task. There are two things which help readability of spreadsheets or VBA codes:
Hence, as Excel experts, we should encourage our colleagues to adopt these guidelines. Ultimately, they will be coming to you with their spreadsheets. Hence, this reduces your own precious time and some unnecessary frustration.
We would love to read about your unique experiences in dealing with similar problems at work. Please leave your comments below.
And… share these amazing tips with your friends!
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide