Workshops Learning Groups Management Training Series Library Leadership Ohio
Microsoft Excel Advanced
Thursday, October 23, 2003
9:00:00 AM - 4:00:00 PM

Cuyahoga County Public Library--Administration Building
Electronic Classroom


$65 CAMLS Members
$75 Affiliate Members
$130 Non-members
Free for guests/speakers

Deadline: Thursday, October 16, 2003
Limit: 18
Registered Now: 9
Contact Hours: 6

Fee includes materials.

Participants will learn to use conditional formulas such as SumIf and CountIf, as well as how to utilize three-dimensional formulas and range names. Student will create multiple spreadsheet variations within a single file using Scenario Manager, and customized displays using View Manager. Spreadsheet data will be analyzed through a combination of outlines, Pivot Tables, Data Tables, and Subtotals. Finally, students will learn to solve for complex target values using Goal Seek and Solver.

Prerequisite: Microsoft Excel Intermediate

Course Content

  • Using advanced formulas
  • Customizing spreadsheet displays
  • 3-Dimensional formulas and range names
  • Reporting and analyzing data with Excel
  • Solving for complex values
Audience: This course is for anyone wishing to learn Excel’s reporting and analytical capabilities, and advanced formulas.
John Paul is the President and owner of Winsoft, a software training firm. He has been a professional speaker for over eight years. He routinely conducts computer seminars nationwide and is an expert in the Microsoft Office product line.

More on this topic: