In Excel 2010, Excel users have to select different tabs to find and click on the icon for a specific command. The change in interface means I have to increase the number of steps that I have to take to activate a command as compared to the toolbar interface (Excel 2003 and below) where everything can be found within 2 rows of icons and activate with one click. This increase the number of steps that I have to take before I can activate the command I want.
This doesn't seem to take up a lot of extra time if you view each command you wish to activate in isolation. But as a heavy user of Excel, the extra steps add up quickly and within 10 mins, I will have to click two to three hundred times more to perform the same actions I would have done with the older version of Excel (2003 and below).
If this is what you are experiencing in Excel 2010, then I have good news for you. In Excel 2010 came with the ability to customise your own ribbon. So if you are constantly working with some commands in Excel, you can create a new personalised tab and add these commands into this new tab. With the personalised tab, you do not have to jump from tab to tab to find the commands that you need.
You can watch this video to find out how to customise your Excel Ribbon or read the steps below:
To customise or personlise your Ribbon, follow the steps below:
Another change you can do with Excel 2010 and 2007 is the quick access toolbar. By placing the toolbar below the Tab instead of above, you are likely to click on the quick access toolbar more often. If you are an hard core Excel 2003 fan but is forced to use the new version of Excel 2007 and 2010, this will help you in your transistion. To move the quick access toolbar below the Tab, just click on the inverted triangle next to the quick acces toolbar and select "Show Below Ribbon". That's it.