Page 1 of 28PREVNEXT

So that's how! Great Excel features

Great Excel features
Learn five great Microsoft® Excel features that will help you to work faster and easier.

About this course

This course includes:

  • Five self-paced lessons and five practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Freeze the upper and left panes to keep column or row titles in view while you scroll through data.
  • Compare two workbooks at the same time by using the new Compare Side by Side feature in Microsoft Office Excel 2003.
  • Add up numbers just by selecting them.
  • Use the fill handle instead of typing to complete repetitive series of numbers, dates, or text.
  • Make formatting changes automatically when values are at a certain point by using conditional formatting.

Isn't it great when something turns out to be easier than you thought? Like keeping titles in view when you scroll down a worksheet, adding up numbers just by selecting them, or formatting cells so that content automatically changes color if the conditions are right?

In this course you'll learn about five great Excel features, including the new Compare Side by Side feature. Perhaps you'll be revisiting a few features that you've used before but have forgotten.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 28PREVNEXT