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.

More on this topic: