Of the assignments we’ve had so far, this Excel project was the most engaging. I’ve been learning about Excel off and on now since 1997. The problem for me is that if I don’t use it every day, I forget how to use certain features, but that’s what makes Google so awesome as well. If it’s been done before in Excel someone has posted it on the internet. A cool podcast to listen to if you’re a real numbers freak is:
“Mr. Excel” knows everything about the spreadsheet application. Just make sure that when you hear about a function that interests you, that you go ahead and try to implement it in your current work. Otherwise, you will not remember how to use it.
I have worked with formulas before, so this assignment wasn’t too tough. This was my first time delving into Pivot Tables. I’ve got to find a way to start using them at work. They’re a great tool to have. They make it so much easier to present and manipulate data, like this pivot table I did for Average of Percent Increase:
I’m not a data freak, but I enjoy using Excel spreadsheets at work occasionally. For the past three weeks we've been using a 70 tabbed spreadsheet at work to calculate pricing for a very important project. Sometimes these spreadsheets can get unwieldy, but this one was invaluable when it came to “scrubbing the numbers.” That’s one of the great things about Excel is that it allows you to tweak certain variables (costs) and then you can watch the effects propagate through the rest of the data. Excel is great for stress test analysis. Having doubts about certain costs or revenues. Just change them and watch and look at the result. Sometime the have very little effect. At other times they are large.
No comments:
Post a Comment