Join David Rivers for an in-depth discussion in this video Understanding the reasons to switch, part of Migrating from Excel 2003 to Excel 2010.
Excel 2010 offers a number of major changes and enhancements that could make upgrading from Excel 2003 worthwhile. There is a totally revamped fluent user interface, there are new file formats to help make your work more compatible and secure, and there are a number of productivity tools to help you work more efficiently while creating professionally-designed spreadsheets. In this movie, we'll get a brief overview of some of these features before covering them in greater detail later on in this course.
We'll begin with the new fluent user interface, which is designed to help you work more efficiently and improve your productivity. Microsoft's goal with the new Ribbon is to allow you to spend more time doing your work and less time searching for commands, by making them easy to find and use. You'll also find quick and easy access to relevant commands using the Quick Access Toolbar. New file formats will make your work more compatible and secure, especially when it comes to collaborating with others on a workbook and sharing files.
With the new XML-based Open XML file format used in Excel 2010, you'll also notice smaller file sizes, since files are compressed. They will also be more secure, due to the transparent nature of the format. Sensitive information can be readily identified and removed if necessary. And with Excel 2010, you'll be able to produce more sophisticated and attractive workbooks because of the new formatting functionality, Condition Formatting tools and expanded template options.
So I hope this brief overview has helped to show you why you might want to migrate from Excel 2003 to Excel 2010. We'll be exploring these reasons in greater detail as we move through the various chapters in this 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