I have been avoiding the upgrade to Excel 2007 as long as possible. I have it running on my relatively new laptop (ordered Office 2007 even though I stuck with Windows XP, thank god). However, my office PC, on which I do my extreme Excel work, has stayed with Office 2003.
Until today.
I finally came across a function in 2007 that warranted the upgrade. I have been looking for a solution to this problem forever and did not realize that the solution was in Excel 2007.
Now, it’s not that I dislike the functionality. I have noticed several tools in 2007 that are better than 2003. It’s just that I cannot stand the menu interface.
Until now, none of the added functionality of Excel 2007 made up for the lack of the normal menu bar. I cannot find my way around all of the normal functionality any more, let alone use the keyboard shortcuts (well, they work, but not intuitively as part of a menu). As an Excel power user, it just does not allow for quick, keyboard navigation.
Well, today I finally found the conditional Sumif formula that allows for doing a SUMIF on multiple conditions. There are thousands of uses for this function and I seem to have run into every one of them over the years. It is a blessing, I tell you.
I made the switch and I’m not looking back.
No related posts.
