The interface for Excel 2007 is substantially different than any earlier version of Excel and many users have been frustrated with the change. It is possible to upgrade with a minimum of inconvenience to your users if you prepare for the change.
Advanced Excel Courses Illustrate the Changes
It's more important than ever that employees receive full training on Excel right up through advanced Excel courses. While the interface might be intuitive to someone who has never laid hands on the software before, people used to doing things a certain way are going to have a hard time with it.
Excel instructors can show where everything went. They can guide users through the new ribbon interface so they can find all of their old functions easily. Users find it much easier to adapt to the new interface with some help rather than hunting around at random.
Along the way your employees might discover something new about the software. Advanced Excel courses are often full of tips and tricks that even experienced users weren't aware of.
Working With The Ribbon
The most obvious feature of the new Excel interface is "the ribbon". Everything is laid out where users need it, but some may be overwhelmed by all of the clutter. There are a couple of ways to handle this.
Pressing CTRL-F1 causes the ribbon to disappear, leaving behind just the tab names. This makes the interface look very much like the menus from old versions of Excel, not to mention opening up a lot more screen real estate. When users click on a tab, then ribbon reappears so they can select a command and then disappears again.
Each person uses different commands so one interface isn't going to be ideal for everyone which is why Microsoft included the Quick Access Toolbar. While this is covered in advanced Excel courses, some users don't understand just how powerful it is. Frequently used commands can be added to the small row of icons located above the tab bar so they are easy to find and access.
Learn The New Features
While many people find the learning curve a bit steep on the new version of Excel most agree, if somewhat reluctantly, that the new interface is easier to use once you get used to it.
Another advantage of advanced Excel courses is that instructors can show students more than just how to do the same old tasks. New features have been added that experienced users can easily overlook. Just like learning Excel the first time, users will be slow with the new functions at first but soon will find them making their jobs easier.
There is no question that Excel 2007 has the steepest transition learning curve of any of the previous versions of Excel. However once people get past the differences, they will find it has more to offer than past versions.
You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
If you do not agree to these terms, please do not use this article.
The British Academy Deputy Head Of International Programmes Stephanie Appleton
"The session was excellent and very informative, just on a narrower focus than I had anticipated. Maybe this is more to do with communication about the scope beforehand. I found the pace a little bit swift - I tend to need a bit more time to practice things to really have them sink in - but I appreciate that making the session any longer would probably impact on engagement, so there's a balance to be struck."
The7Stars Ltd Creative Graduate Aidan Hornsby
"You are doing a fantastic job and so is Martin, really grateful for all the help provided, I am now confident at both Excel and Powerpoint."
RWE Physiotherapist Beverley O'gorman
"This course has shown me the capabilities of Teams and will help me in all areas of my role"
Excel articles
