3 ms·
The change between Excel 2003 and Excel 2007 is pretty significant. There are a few key functions, but mostly the row and column count limits are gone. Also,
by hessenwolf 14y ago
The change between Excel 2003 and Excel 2007 is pretty significant. There are a few key functions, but mostly the row and column count limits are gone.
Also, it's pretty from 2007 on. It's really easy to create something that doesn't burn your eyes out.
There a few additional functions, like iferror, that save on some of the most common inefficiencies in large spreadsheets.
The Ribbon interface means that you can't find any function ever. As opposed to an obvious search algorithm of looking through the toolbar menu, you have to wander your eye around non-linearly hoping to pick up an icon that looks vaguely related to what you are doing.
I don't know if it is 2007, but in Excel 2010 there are sparkcharts and there is also a way to embed a table with a barchart - which is actually a pretty awesome visualisation.
It's in my opinion a significant forward shift, not counting the ribbon. I still feel dirty using it though.