You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today’s blog post is brought to you by Anneliese Wirth, who writes about Excel for Office.com.
There are lots of great reasons to step up to Excel 2010 from an earlier version. Some of the new features—sparklines, slicers, PowerPivot—were enough for me to take the plunge personally. If you’ve recently upgraded to Excel 2010, or are just about to do so, I want you to know that we have resources available that can help you through the transition.
If you’re upgrading from Excel 2007, it won’t take you long to figure out Excel 2010. For the highlights, I’d recommend scanning the What’s New in Excel 2010 article or watching the videos in the Make the Switch to Excel 2010 training course.
If you’re upgrading from Excel 2003, you’ll have a steeper learning curve because of the ribbon—the supersized toolbar that replaces the old menus and toolbars. I went through the menu-to-ribbon transition myself after I upgraded to Excel 2007 (when the ribbon was first introduced), so I well understand the challenges here.
Use the following resources to figure out where to find things on the ribbon and get started with Excel 2010.
1. Excel 2010 Menu-to-Ribbon Guide An interactive guide to finding commands on the Excel 2010 ribbon. Click any item on a simulated version of an Excel 2003 menu or toolbar, and the guide reveals the item’s new location on the ribbon. This guide is particularly useful during the first few days after you upgrade.
If you want to share this guide with others in your organization or use it when you’re working offline, feel free to grab the downloadable version here.
2. Excel 2010 Menu-to-Ribbon Mapping Workbook If the interactive guide feels like overkill, we have a simple workbook that maps each command in Excel 2003 to its corresponding location on the ribbon.
3. Excel 2010 Migration Guide This eight-page, printable guide is aimed specifically at Excel 2003 users who are moving to Excel 2010. We’ve reviewed feedback and questions from people who have already upgraded and turned that into a lightweight guide. Their pain, your gain!
4. Make the Switch to Excel 2010 An online training course consisting of 8 instructional videos, a self-assessment module, and a Quick Reference Card.
If you need to train other people to use Excel 2010, you can also download the Make the Switch to Excel 2010 course. This course is available in PowerPoint 2010 (.potx) format. Once you download it, you can add or remove slides, add your own branding elements, or otherwise make it your own.
5. Rev Up to Excel 2010: Upgraders Guide to Excel 2010 A fantastic, FREE 250-page book by Bill Jelen, Excel MVP and author of 32 books about Excel. (Yes, Bill is prolific, and I can’t think of a better person to learn from.) If you want a comprehensive walkthrough from a true Excel expert, this is the resource for you. If 250 pages is too much, just take a look at “Where to find commands in Excel 2010” on page 2 of this book, and you’ll be well on your way.
For more information about Bill’s other books, visit The MrExcel Store.
If you have your own tips to share, or comments about any of these resources, I’d love to hear from you.
Comments: (10) Collapse
I just switched to Office 2010 64-bit and I'm loving almost everything I see, with one or two exceptions. The bits I love include not being hamstrung with a 2GB file size limit.
I'm having some difficulty with CALENDAR controls/ date pickers. MS has removed MS Calendar Control 7 from the available ActiveX controls/ References, in Office 2010. Calendar Control was available with every previous version of Office that I have used. This means I'll have to rewrite some of my code.
An old page on this blog provides an alternative date-picker, which unfortunately I cannot use since it appears not to be compatible with 64-bit Office/VBA:
blogs.msdn.com/.../sam-radakovitz-on-date-pickers.aspx
Any suggestions?
I am not to type letter 'bve' continiusly in MS Excel & Word. It is taking as 'BE'.
what is the reason for this problem.
Balaji. V
I am not to type letter 'bve' continiuosly in MS Excel & Word. It is taking as 'BE'.
I absolutely HATE what you have done with Excel. It is incredibly restrictive and frustrating. Doing a simple spreadsheet that used to take minutes now takes forever, without the functionality it used to have. If it ain't broke, don't fix it. This is like Sesame Street for spreadsheets. You've made it so that it TRIES to do everything for you without giving you the option to do it yourself. This is a huge disappointment - why does everything have to be designed around the dumbest person in the room? Your designers must all be liberals.
I just bought Excel 2010 and I'm glad that our company hasn't changed to Excel 2010. I don't know why Microsoft does not provide the option between classic menu and ribbons (whatever). Wait a minute, I know. You need to "BUY" something to get the classic menu back. Does Microsoft ever consider the users' habit? Take the action of deleting a row. I can just click the button "delete row" from 2003 and older version but with this ribbon thing, I need to click the button and select what I want to delete (row or cell...etc.). I don't see that this is improvement while you need to break one action into several to slow down all the process.
Wonderful blog! I truely love how its easy oh my eyes as well as the details are well written. your blog insisted me to switch over from excel 2007 to 2010.Thanks a lot.....
gloriatech.com/excel-200320072010-sms-addon.aspx
Hope this finds you well. I use excel 2010 and love it. Quick question, what code would I use to make a macro that would change “btw” to “By the way” in excel 2010? I want to make shortcuts for words that I type frequently. - Best regards, Kimberly NJ
It's very frustrated to find out aftter upgraded to Excel 2010 that the pivot tables drop down filter is limited to 10,000 rows. if more than 10,000 are available then a message saying "Not all items showing" is displayed at the bottom of the list.
Clicking on the message would display a message saying: "This field has more than 10,000 items under one or more parent items. Only the first 10,000 items are displayed under each parent item."
Is it possible to disable or increase this limit?
Redesign our DW dimensions (cubes) as a workaround would not a solution. It won’t make any sense to the users and will create more problems for all of them(since most of them are still on MS 2003 or 2007 – which works OK).
Why not leave it the way it used to be - like in the previous versions?
Alex P.
I'm very discouraged/disappointed with Excel 2010. You gussied it up for the small-time user that is impressed by pretty ribbons, and didn't ask regular users what they think. The ribbon is an anchor for regular users. I had hoped that after the Excel 2007 debacle Microsoft would have learned. It's interesting - you say it right up front in the above article "the ribbon—the supersized toolbar " - - That is one of the big problems! Toolbars should be small and not intrude on the workspace (I have 2 24" monitors)! The other problem is that it takes multiple clicks to get to almost any command. For heavy users this is problematic. Why couldn't you have left the menus alone - - I'm not sure you could have improved them over 2003. They were compact, and they allowed the user to personalize the commands. I had hoped that 2010 would at least have a larger space for frequently used commands (like 2003) - but you can only use 1 row for command icons. I work with Excel developing complex spreadsheets every day. I am occasionally stuck on a machine that has Excel 2007 or 2010 - but whenever I am going to do serious work, I go back to Excel 2003. Thank goodness the default save in 2007 and 2010 can still be set to 2003!
I haven't seen any replies to the issues to upgrding to Excel 2010, that is unfortunate. We've actually LOST the ability to work with dual monitors in the same fashion as we did in earlier versions. I think it is a combo of the PIN feature of Win7 and both 2007 / 2010 Excell operate a little differently. There is a public fix for 2007 and dual mionitors to allow workbook compare but nothing for 2010?
Comments: (loading) Collapse