Migrating from Excel 2003 to Excel 2010
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.
- Comparing the Excel 2003 and 2010 interfaces
- Exploring the Ribbon and Backstage view
- Dealing with file compatibility issues
- Working with formulas and functions
- Using conditional formatting
- Creating macro-enabled workbooks and templates
- Using keyboard shortcuts
- Understanding Compatibility Mode
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.
Excel 2010 Essential Training5,756,965 Views
Excel 2013 Essential Training5,659,883 Views
Access 2010 Essential Training3,079,123 Views
Windows 10 Essential Training725,484 Views
Excel 2010: Pivot Tables in Depth1,309,159 Views
Excel 2010: Advanced Formulas and Functions968,662 Views
PHP with MySQL Essential Training3,907,848 Views
Excel 2010 Power Shortcuts682,939 Views
Foundations of Programming: Fundamentals6,728,971 Views
Deke's Techniques1,435,609 Views