!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> Streamline Training & Documentation: HP Intermediate Excel 2007 Course

Thursday, December 03, 2009

HP Intermediate Excel 2007 Course

I have now worked my way through the Intermediate Excel 2007 course mentioned in my post of a week-and-a-half ago outlining the content of the introductory Excel course offered at Hewlett Packard's Learning Center.

The intermediate course matches the introductory course in terms of quality. It is well-organized, offers plenty of well-designed hands-on examples, and provides learning checks at the end of each lesson.

The four lessons are:
  1. Functions — Reviews some of the most commonly used Excel functions (e.g., SUM, AVERAGE, MAX, COUNT, PMT,ROUNDUP, TODAY, and NOW) and explains the Help functionality that eases use of any of the innumerable functions available in the program. The lesson also covers absolute cell referencing and its role in formula copying; and creating named cell ranges.

  2. Working with multiple worksheets — Teaches use of multiple worksheets within a single workbook. Covers naming, creating, and deleting sheets; displaying and arranging sheets; copying and moving sheets; formating sheet tabs; creating formula and function references to cells on multiple sheets; and linking to content from other workbooks.

  3. Finding, sorting and filtering data — Covers Excel's most commonly used sorting and filtering capabilities. Other topics include using Excel to create a flat file database, importing data from other applications, finding and replacing data, splitting data into multiple columns, and concatenating data.

  4. Advanced formatting — Topics include themes, cell styles, sharing custom styles between workbooks, (e.g., by creating a template), creating conditional formatting (e.g., showing a number in red if it is negative), and using custom number formats.
Once you're done with the intermediate tutorial, you might be looking as I am, for the next level of instruction. HP promises that a two-part advanced tutorial is on its way. The first part deals with data analysis, and the second with creating charts and graphics.

You can sign up to be notified when the advanced tutorial becomes available here (Part 1) and here (Part 2). (Judging from what Google turns up, it appears that this course is already available from other sources, but not on-demand and for free.)