Transition From Excel 2003 to Excel 2007

Excel spreadsheets (.xls)

I’ve talked about the upcoming cloud based Excel that will be launching in a few months and I’m certainly excited to try out the upcoming version. That being said, I’m not exactly running the most recent version of excel. In fact, I currently use Excel on a few computers:

-Work computer: Excel 2003
-Home computer #1: Excel 2007
-Home computer #2: Excel 2010
-Wife’s Mac computer: Excel for Mac

This week, they upgraded my Excel at work from 2003 to 2007 (enterprise is a always lagging a bit) and I was reminded of how drastically different those 2 are. Despite already being an Excel 2007 user, I was caught off guard. So today I thought I’d go over a few of the excel options that I looked into to get me comfortable again:)

The big difference of course is that the top menus are completely different (the ribbon menus they are called) and I would argue that more clicks are required and I sometimes feel like I lose time using it. So first off, where can Excel options be found?

First off, I decided to change the color scheme to add a bit of character, see how I did here:

Here is what it looks like:

The critical part in my opinion is finding the excel functions that you use most often and putting an icon on your top bar through the options:

You can add them here:

For example I added the “sort” function here:

Once you are able to add the most popular functions, you suddenly start seeing that Excel 2007’s power makes it a no-brainer upgrade. It’s faster, manages data a lot more efficiently and is just a big upgrade overall.

Have you upgraded to Microsoft Excel 2007? If so, how did it go?


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss