Excel

  • 5 Excel Tools

    Generally, you should use software tools that have been well tested and provide robust results, but there are times when you just need to do your own thing. Maybe the software doesn’t give you the information you need and you need to dig into the details deeper. Or you need to do some ad hoc…

  • Random Function

    This post will be a short one since I’m working on a project for a friend. The random function in Excel is kind of a neat function. There are two: 1) rand() and randbetween(a,b). Some uses for it are: 1) Randomize your numbers in Monte Carlo simulation; 2) Randomly organize your numbers if you want to…

  • Using Excel

    (Okay, this picture has nothing to do with today’s topic – it’s a copout picture. I’m still trying to set up this website and I am encountering a few problems due to learning to use this tool. And maybe I am being a little too ambitious on what I want to accomplish. Besides, sourcing pictures for…

  • Managing 100+ Projects

     [divider]I once had 150+ projects…[/divider] When I joined this team, they had a lot of project work. At the time, they were mostly in the $10K range, with very few in the $1 million range. All project reporting and analysis were done by spreadsheets. So if you had 150 projects, you had 150 spreadsheets. One…