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
(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.
Migrating from Access 2003 to Access 201024,620 Views
Kim Lee: Digital and Physical Production and Design3,531 Views
Practical Motion Background Workshop131,070 Views
Hanson Hsu with Bobby Owsinski: Radically Rethinking Room Acoustics7,166 Views
Migrating from PowerPoint 2003 to PowerPoint 201029,427 Views
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