CMU School of Drama


Monday, April 18, 2016

How to Use Excel: 12 Techniques for Power Users

business.tutsplus.com: Excel is great, but trying to figure it out how to use Excel on your own can get you only so far because it isn’t intuitive. But if you use the techniques and tips in this tutorial, you’ll be able to get your work done faster and without a lot of stress.

Learn how to apply Excel formulas, calculations, filtering, data manipulation, workflow efficiencies, and more. Here are a dozen Excel techniques and features you need to know.

2 comments:

Unknown said...

So, I got really excited about this article and thought that I would be able to learn some new things about Excel, however most of this is basic formatting information or basic formula information. I have learned these formulas for the most part in Technical Management last semester and the rest in Production Resource Management this semester or by my own self-discovery of browsing around Excel while doing assignments. I have learned this semester that Excel is such a powerful program, however most people I know and work with do not use it to its fullest extent because it can sometimes not be particularly user-friendly. Now, it its important to say that for someone that does not have a formal Excel education, these techniques could be extremely helpful, however I do not know if I would fully agree with the fact that these techniques would be helpful “power users” like myself.

Lauren Miller said...

Unlike Ben King, I have almost no experience with excel. Basic PTM this semester has been my first time actually opening and using this program. For him, this video was absolutely basic and boring, but for me, articles like this are a godsend. I am currently working on the production calendar project and I am dying, not because of a lack of understanding or ideas on how to make the calendar, but because I have no idea what I am doing in this program. I learned from this video that I can have multiple sheets on this program (can they refer to each other? I don’t know). Also I wasn’t aware of the sum function. I’ve just been clicking every box, think the entire time that there had to be some other, more efficient, method of adding figures. I also need help with the “making things pretty” commands. I discovered the “merge and center” command yesterday, it was so exciting because I remember looking at David Boever’s example documents while we were learning excel and I remember just constantly thinking “how!?”. I am learning. Thank you for the video, it is helping.