Workshops

Learning Groups

Management Training Series

Library Leadership Ohio

Excel: Data Management

Tuesday, November 25, 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: Tuesday, November 18, 2022
Limit: 18
Registered Now: 14
Contact Hours: 6

**Notes:
Fee includes materials

Take your spreadsheet skills to the next level by learning Excel’s list management functions, advanced mathematics, and automation techniques. Students will learn powerful applications of Excel’s advanced techniques for manipulating lists of data. Data queries will be created from both internal spreadsheet and external data sources. Advanced formulas such as database functions, nested formulas, and evaluation functions will be taught. Participants will also be taught how to automate routine functions through the use of macros.

Prerequisite: Excel Intermediate

Course Content

Automation techniques
Advanced techniques for manipulating lists of data
Data queries from internal and external data sources
Nested formulas & evaluation functions
Automate functions with Macros

Audience: For those who need more extensive knowledge in the manipulation of data from both internal and external sources, and who want to master advanced mathematical capabilities

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.