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.
247 Ratings

Current class sessions
You can enroll for free at any time!
Enroll now »
»  See all classes

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.
Enroll now »

Instructor
Don Freidkin
Don Freidkin
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
»  Welcome!
»  Lesson 1
»  Excel as a Database
»  Adding Rows and to multiple charts
»  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

ziumi
Nov 23, 2009
(Edited about 1 day ago)

Excel 2007

Great Class Thanks!!!

81563209
Nov 22, 2009

Microsoft Excel 2007 Introduction.

This is great.In the begining I was scary and at the end I feel encouraged to go ahead.Thanks to our Instructor Gaye Sodoma helping completing the course.Now I have enrolled in the Intermediate class. Thanks to HPL center for their helping service.Thanks to Don Freid Kin for being kind to admit me in his class. Regards, Rafiq.

Pradeepkumar
Nov 19, 2009

Excel : Intermediate

really helpful

dbrooks7999
Nov 11, 2009
(Edited about 13 days ago)

exel intermediate

I love this I actually started my own amoritization schedule.
Thanks

» Read all 80 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
© 2009 Hewlett-Packard Development Company, L.P.