Buy online or Call 800-BUY-MYHP

Microsoft® Excel 2007: intermediate

Free, online classes, available 24/7: www.hp.com/go/learningcenter

Class overview

You have no Flash player installed. Click here to download and install the Adobe© Flash plugin.

Your browser may require a restart after installing.

Take your Microsoft Excel skills to the next level! Packed with useful tips for the intermediate Excel user, this class explains how to get the results you want from Excel formulas and functions, how to find data more easily with sorts and filters, how to manage multi-sheet workbooks, how to apply page formatting such as headers and footers and much more.

280 Ratings

Current class sessions

What you'll learn

  • Learn to select the appropriate formula or function for the task at hand
  • Create formulas that include absolute references and named ranges
  • Sort data by single or multiple columns
  • Filter data by single or multiple criteria via examples and forms
  • Manage a multisheet workbook and refer to 3D ranges in formulas
  • Create custom page headers and footers
  • Apply styles and conditional formatting
» Preview the first lesson

Lessons

» Lesson 1: Microsoft Excel tutorial: functions
Microsoft Excel offers hundreds of functions. In this lesson, you'll try the most useful ones and learn how to get help with others you might need. You'll also explore absolute cell referencing and its role in formula copying.
Lesson 2: Microsoft Excel tutorial: working with multiple worksheets
A Microsoft Excel workbook is more than just a single sheet. In this lesson, you'll go 3D and learn how to use multiple sheets, name and format sheet tabs and create formula and function references to cells on multiple sheets.
Lesson 3: Microsoft Excel tutorial: finding, sorting and filtering data
Long lists of data can be intimidating, but Microsoft Excel has excellent sorting and filtering capabilities to help bring that data under control. This Microsoft Excel tutorial shows you several strategies for finding and organizing data.
Lesson 4: Microsoft Excel tutorial: advanced formatting
In this lesson, you'll learn powerful formatting skills, such as styles, custom headers and footers and conditional formatting, for making your Microsoft Excel workbooks the best they can be.

Instructor

» Don Freidkin
20 Ratings

Don Freidkin is a writer with an extensive background in film and video writing, producing, and directing. One of his favorite projects was producing, directing, and co-writing "The Sea Above," a series of 26 half-hour shows on popular astronomy for KERA-TV in Dallas. He's also done live coverage of events ranging from NBA exhibition games to state political conventions to San Antonio's series of Fiesta parades. Don has taught writing for media at the University of the Incarnate Word in San Antonio, manages the online discussion community for the award-winning site, NewCafe.org, and has written and instructed numerous online courses on a variety of topics.

» Interact with Don and other students on the message board

Top message board topics

  • No current topics
»  View the message board
»  View the message board archive

Related classes

»  Microsoft® Excel 2007: introduction
»  Microsoft® Windows Vista: troubleshooting and maintenance
»  Microsoft® Word 2007: intermediate

Class reviews

Feb 9, 2010
(Edited about 6 hours ago)

Excel 2007 Intermediate

This clas was very well written,Flowed well, and informative. I have Excel 2002 and the sample videos where very helpful.

Feb 9, 2010
(Edited about 7 hours ago)

NEW USER

WORKING ON ACCESS TO COURSE MATERIAL

Feb 9, 2010

EXCEL 2007 INTERMEDIATE

THIS COURSE IS GOOD FOR ME

Feb 8, 2010

Excel Intermediate

Does what it says on the tin! I have used Excel a lot but some of these areas I didn't know. Roll on the Advanced course.

» Read all 107 reviews

Write a review

» Please login to review
Printable versionPrintable version » Bookmark the Learning center E-mail this page Email this site
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2010 Hewlett-Packard Development Company, L.P.