Workshops

Learning Groups

Management Training Series

Library Leadership Ohio

Microsoft Excel Advanced

Thursday, October 23, 2022
9:00:00 AM - 4:00:00 PM

Location:
Cuyahoga County Public Library--Administration Building
Electronic Classroom
Map

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

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

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

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.