Walks through the transition from Excel 2003 to Excel 2010.
(air whooshing) - 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 the 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, so many topics to cover, it's time to get started.
- 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