Start learning with our library of video tutorials taught by experts. Get started
In Migrating from Excel 2003 to Excel 2010, author David Rivers walks through the switch to Excel 2010 from Excel 2003. The course covers key differences in Excel 2010, including the Ribbon interface and the Office Open XML file format, and shows how to perform common Excel 2003 tasks in Excel 2010. Exercise files accompany the course.
Hi, and welcome to Migrating from Excel 2003 to Excel 2010. I'm David Rivers. Microsoft has incorporated some major changes and improvements in Excel 2010, so if you plan on migrating from Excel 2003, this course will help to make your transition to Excel 2010 as smooth and seamless as possible. We'll begin with our tour of the new and improved fluent user interface, focusing mainly on the Ribbon, the Quick Access Toolbar and Backstage view.
We'll also examine ways to take advantage of keyboard shortcuts in Excel 2010. And working in an environment where some people are using Excel 2010 while others continue to use older versions of Excel, can present challenges. We'll cover those challenges and how to overcome them when working in this type of mixed environment. This will involve understanding file formats and Compatibility mode. Many of the common functions and commands found in Excel 2003 may be performed in a different manner in Excel 2010.
So we'll be sure to investigate items like the Quick Access Toolbar and customization options to help you work more efficiently. Then it's on to some of the common features that you may be accustomed to using in Excel 2003 that have changed here in Excel 2010, features like the ones you'll use to create formulas and functions now in Excel 2010, or the new ways to make your workbook stand out with formatting, including conditional formatting and how to create macro-enabled workbooks and templates in Excel 2010.
So, with so many topics to cover, it's time to get started.
There are currently no FAQs about Migrating from Excel 2003 to Excel 2010.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.