or Connect
Styleforum › Forums › Culture › Business, Careers & Education › Cool stuff you use MS Excel for?
New Posts  All Forums:Forum Nav:

Cool stuff you use MS Excel for? - Page 3

post #31 of 32
Quote:
Originally Posted by imschatz View Post

When I started my current job back in August the expectation was marginal excel skills. My boss gave us a day to play around on this website:
http://datapigtechnologies.com/ExcelMain.htm
There is lots in the "basics" but also gets into the more advanced stuff like Pivot Tables and VBA macros. Lots of cool videos, and it's based in 2003 so it makes you think about the problem a bit more as many of the features have changed (somewhat) since 2011. The basics are all the same though.

http://datapigtechnologies.com/flashfiles/pivot10.html
So far for me .. this is the SINGLE best excel trick when it comes to setting up reports for management. I've replaced close to a hundred daily use excel spreadsheets using this macro/pivot combo.

As for youtube .. same thing. Lots of youtube videos. Youtube "Excel Pivot Table Tutorial" or "Excel Macro".
post #32 of 32
Thanks a lot. Yes pivot tables is a mystery to me. In fact, now that I am trying to improve my skills, I think I even overestimated my self.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Business, Careers & Education
Styleforum › Forums › Culture › Business, Careers & Education › Cool stuff you use MS Excel for?