Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Audio course: So that's how! Great Excel features 
 
  Overview  
 Show/Hide lesson sections Freeze!
 Show/Hide lesson sections Compare side by side
 Show/Hide lesson sections Sum it up, and more
 Show/Hide lesson sections Type less, get more
 Show/Hide lesson sections Call attention to the good or the bad
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Overview
Great Excel features  

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

  • Length: 40–50 minutes
  

Next

GOALS

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.
  
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.
AUDIO TEXT

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.
  Go to previous page (disabled)    Next Go to next page
advertisement