facebook google plus twitter
Webucator's Free Upgrading to Microsoft Excel 2010 Tutorial

Lesson: Other Important Features in Excel 2010

Welcome to our free Upgrading to Microsoft Excel 2010 tutorial. This tutorial is based on Webucator's Upgrading to Microsoft Excel 2010 course.

In this lesson you will learn about keyboard shortcuts (now called KeyTips) and about working with other versions of word.

Lesson Goals

  • Learn about keyboard shortcuts.
  • Learn about working with other versions of Word.

Keyboard Shortcuts

In Excel 2010, keyboard shortcuts that begin with the CTRL key, such as CTRL+N to create a new, blank workbook and CTRL+F to display the Find and Replace dialog box, remain the same as in previous versions of Excel.

However, shortcuts that in previous Excel versions involved pressing ALT have changed; these are now called KeyTips.

To display KeyTips in your workbook:

  1. Press ALT. Doing this makes KeyTips appear for all of the tabs on the Ribbon.
  2. Now press the corresponding key to open the tab or Quick Access Toolbar you want to use.
  3. Press the letter of the command you wish to execute.

For example, to add a comment in your workbook, you would

  1. Press ALT.
  2. Then press R to display the Review tab.
  3. Then C to insert your comment.

Working with Other Versions of Excel

Excel 2010 workbooks use the .xlsx file extension. Excel 2010 is based on Office Open XML formats (but you do not need to know how to use XML to work in Excel 2010).

The reasoning behind this change is because XML helps keep workbooks safer by

  1. Separating files containing macros or scripts.
  2. Keeping workbook sizes smaller.
  3. Helping to prevent data corruption and loss by making workbooks less susceptible to damage.

Opening Workbooks Created in Previous Excel Versions

You can open workbooks that were created in previous versions of Excel. When you open such a workbook, it will open in Compatibility Mode.

Saving an Excel File Created in a Previous Version

When you save a file that was created originally in a preview version of Excel, the Save As dialog box will open automatically, to save the file with an .xlsx file extension.

Saving an Excel File as a Previous Version

Also, when you save an Excel 2010 file as a previous version, Compatibility Checker will identify any new features that will not work in that version.