Workshops Committee Programs Management Training Series Library Leadership Ohio
Microsoft Excel Advanced
Thursday, October 27,
9:00:00 AM - 4:00:00 PM

Cuyahoga County Public Library--Administration Building
Electronic Classroom

2111 Snow Road Parma, Ohio


$75 CAMLS Members
$85 Affiliate Members
$150 Non-members
Free for guests/speakers

Deadline: Thursday, October 20,
Limit: 18
Registered Now: 0
Contact Hours: 6

Fee includes materials only

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


  • Using advanced formulas
  • Customizing spreadsheet displays
  • 3-Dimensional formulas and range names
  • Reporting and analyzing data with Excel
  • Solving for complex values
  • Choose Title

    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: