Author Topic: MS Excel Powerhouse  (Read 2809 times)

0 Members and 1 Guest are viewing this topic.

KMC

  • Moderator
  • *****
  • Posts: 963
  • Gender: Male
    • View Profile
  • Current Gig: Project Manager, Systems Integration
  • Experience: Former SM
MS Excel Powerhouse
« on: Aug 27, 2013, 03:08 pm »
A colleague pointed me to a website today called Chandoo (http://www.chandoo.org) that is a massive resource for Excel instruction, tips, templates, etc...

A lot of the templates and resources are structured for the discipline of project management; seeing as Stage Management is in many ways highly-specified and industry-specific project management I thought I'd share this.  Some of you may find this useful and adaptable to your practices. 

Example:  you want to wish everyone a happy birthday, so you decide to sort everyone in your company by birth day and month, but not year.  If you filter based on date with a traditional mm/dd/yyyy format in ascending order you'll get the earliest yyyy date first, etc...  Here's a quick way to solve that.

At the very least I'd encourage you to check out the site if you come across something you want to do in Excel but you're not quite sure how to get there.

Happy browsing  :)
« Last Edit: Aug 27, 2013, 03:11 pm by kmc307 »
Get action. Do things; be sane; don’t fritter away your time; create, act, take a place wherever you are and be somebody; get action. -T. Roosevelt

Maribeth

  • Superstar!
  • *****
  • Posts: 1056
  • Gender: Female
    • View Profile
  • Affiliations: AEA
  • Experience: Former SM
Re: MS Excel Powerhouse
« Reply #1 on: Aug 27, 2013, 05:13 pm »
Thanks- looking forward to poking around on there.

 

riotous