Workshops

Committee Programs

Management Training Series

Library Leadership Ohio

Microsoft Excel Advanced

Thursday, October 27,
9:00:00 AM - 4:00:00 PM

Location:
Cuyahoga County Public Library--Administration Building
Electronic Classroom
2111 Snow Road Parma, Ohio
Map

Cost:
$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

**Notes:
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

COURSE CONTENTS

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.

Presenter:
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.