Topics

Computer Basics

Microsoft Word

Part 1
Learn the Word interface, Ribbon, OneDrive integration, and how to create, format, print, convert to PDF, and upload documents.

Part 2
Covers basic text editing: cut, copy, paste, formatting text, adjusting spacing, using Find and Replace, and creating lists.

Part 3
Learn to format documents with hyperlinks, columns, headers, footers, page numbers, and structured headings.

Part 4
Enhance documents with images, text boxes, tables, charts, and watermarks; includes formatting and image tools.

Part 5
Covers indents, tabs, comments, track changes, writing tools, document protection, and mail merge for personalized content.

Microsoft Excel

Part 1: 
Opening, saving, managing workbooks, formatting cells, sorting/filtering data, using Find and Replace, and preparing files for printing. 

Part 2:  
Boost efficiency with features like Paste Special, basic formulas (SUM, AVERAGE, COUNT), text functions (LEFT, MID, RIGHT, TRIM), chart creation, and keyboard shortcuts. 

Part 3:  
Use “Go to Special” for quick data selection and create pivot tables to summarize and analyze large datasets. 

Part 4:  
Enhance organization with templates, named ranges, drop-down lists, and conditional formatting for dynamic cell styling. 

Part 5:
Improve data management with Excel tables, Flash Fill, column splitting, CONCATENATE, Quick Analysis, and Sparklines for visual trends.

Part 6:
Master advanced functions: IF, COUNTIF, SUMIF, IFERROR, VLOOKUP, and INDEX MATCH. Learn Power Query to clean, merge, and manage complex data.

Microsoft PowerPoint

2016

Microsoft Publisher

2016

Internet

Email

Special Topics

Our Mission: The Akron-Summit County Public Library provides resources for learning and leisure, information services, meeting spaces, and programs for all ages that support, improve, and enrich individual, family, and community life.