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.
242 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
19 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
»  Adding Rows and to multiple charts
»  Importing Int-Practice3A into Excel
»  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

oper09
Nov 5, 2009

Excel Intermediate

A lot of great information. Great class

Jo8888
Nov 4, 2009

MS Excel 2007

Then lessons are up to date and easy to understand with the help of video and practices. Thanks for offering this class.

RickWins
Oct 28, 2009

Excel Introduction

Excellent Introduction

livncin
Oct 27, 2009

Excel 2007 Intermediate

Very helpful

» Read all 76 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.