One South Sixth Ave. St. Charles, IL. 60174
MON-THUFRISATSUN
9am - 9pm9am - 8pm9am - 5pm12pm - 5pm
MON-THUFRISATSUN
9am - 9pm9am - 8pm9am - 5pm12pm - 5pm

You are here

Computer Classes

In-Person Computer Classes

Beginning in August, St. Charles Public Library will offer group instruction in our computer lab. Space is limited.  Classes are open to SCPLD cardholders only. Please see our event calendar for class information.  REGISTER

Tuesdays, 6:30–8:00 p.m. Google Apps classes  
  • Docs – online word processor 
  • Sheets – online spreadsheet program 
  • Slides – online presentation program   
Wednesdays, 10:00–11:30 a.m. Basic computer skills classes
Bring your own device. 
  • Windows 10 
  • iPhone and iPad  
Thursdays 6:30-8:00 p.m. Microsoft Office classes
  • Word 2016 – word processor 
  • Excel 2016 – spreadsheet program 
  • PowerPoint 2016 – presentation program 

Self-Study Computer Classes 

St. Charles Public Library offers instructional videos delivered to your email inbox. Watch the video provided by our technology educator to learn how to use Google Apps or Microsoft Office.  You will practice the skills taught in the video using your own document. Work at your own pace, when it’s convenient for you. All videos offer closed captioning. Classes are open to St. Charles Public Library cardholders only. REGISTER 

Please see our event calendar for class information.  

Getting Started with Google: Create a Google Account  

  • Download the Chrome browser 
  • Create a Google account 
  • Manage your account settings 

Google Docs Lesson 1: Introduction to document formatting 
Get to know Google Docs and learn basic word processing skills  

  • Format text 
  • Use tools like spell check and word count 
  • Add lists, columns, and format line spacing 
  • Insert images, tables, page numbers, hyperlinks, and more 
  • Change page orientation, download a pdf and print 

Google Docs Lesson 2: Custom formatting and advanced techniques 
Master advanced word processing techniques 

  • Customize margins, line spacing, columns, and indents 
  • Apply paragraph styles 
  • Insert a Table of Contents 
  • Create internal and external links 
  • Add a chart 
  • Embed a spreadsheet 
  • Share a document 

Google Sheets: Create a spreadsheet to track a home improvement budget 
Learn the basic spreadsheet skills through this scenario-based learning activity 

  • Enter data   
  • Change fonts, adjust column sizes  
  • Use formulas to add a list of numbers and to multiple values   
  • Add a fill color and borders   
  • Print 

Google Sheets: Conditional Formatting
Conditional formatting is a feature that allows you to apply specific formatting to cells that meet the criteria you set 

  • Resize column widths and row heights
  • Apply conditional formatting to selected groups of cells
  • Merge multiple cells, format fonts, and fill cells
  • Create an image and insert an image in a cell
  • Duplicate and rename sheets

Google Sheets: Charts and Pivot Tables 
Charts and tables are a great way to organize data. 

  • Create filters  
  • Use filters 
  • Create charts 
  • Customize and format charts 
  • Make a pivot table 

Google Sheets: Creating Sparklines 
Sparklines are small charts, usually shown without axes, that provide the general shape of the data over time. 

  • Write formulas to create Sparklines 

Google Slides: Create newsletters, fliers, scrapbook pages and more 
Slides is more than a presentation tool. Learn how to use it to create custom documents 

  • Choose a canvas size 
  • Add text boxes and shapes 
  • Change the background 
  • Add photos from your computer and online images 

Google Slides: Using the master slide to modify a template
 
Templates are a great way to create a presentation. Learn how to modify the colors, fonts, and layouts in a template to fit your style. 
  • Change the color theme 
  • Change the layout and fonts in a template 

Google Slides: Animating objects and adding slide transitions
Use animation to help focus the audience’s attention on important information 

  • Add transitions between slides in a presentation 
  • Add animation to objects and text 

Microsoft Word 2016 Lesson 1: Introduction to document formatting  
Get to know Microsoft Word and learn basic word processing skills 

  • Format text 
  • Use spell check and word count 
  • Add lists, columns, and format line spacing 
  • Insert images, tables, page numbers, hyperlinks, and more 
  • Make a table of contents 

Microsoft Word 2016 Lesson 2: Custom formatting and advanced techniques  
Learn advanced document formatting skills  

  • Adjust margins, line spacing, and indents 
  • Customize columns 
  • Add shading, borders, bookmarks, and hyperlinks 
  • Insert a chart 
  • Apply preset styles to the document 

Microsoft Word 2016 Lesson 3: More tools and advanced techniques 
Add even more content to your Word documents 

  • Add internal and external hyperlinks 
  • Use SmartArt, Word Art, and Drop Caps 
  • Take Screenshots, add text boxes and Quick Parts 
  • Use find and replace 
  • Add comments and share a document 

Excel 2016: Create a spreadsheet to track a home improvement budget  
Learn the basic spreadsheet skills through this scenario-based learning activity 

  • Enter data   
  • Change fonts, adjust column sizes  
  • Use formulas to add a list of numbers and to multiple values   
  • Add a fill color and borders   
  • Print 

Excel 2016: Conditional Formatting 
Conditional formatting is a feature that allows you to apply specific formatting to cells that meet the criteria you set. 

  • Resize column widths and row heights 
  • Apply conditional formatting to selected groups of cells 
  • Merge multiple cells, format fonts, and fill cells 
  • Create and image and insert an image in a cell 
  • Duplicate and rename sheets 

Excel 2016: Charts and Pivot table 
Charts and tables are a great way to organize data. 

  • Format data as a table 
  • Use filters 
  • Create charts 
  • Format and customize charts 
  • Make a pivot table 

Excel 2016: Sparklines 
Sparklines are small charts, usually shown without axes that provide the general shape of the data over time. 

  • Create and Format Sparklines 

PowerPoint 2016: Create newsletters, fliers, scrapbook pages and more  
PowerPoint is more than a presentation tool. Learn how to use it to create custom documents 

  • Choose a canvas size 
  • Add text boxes and shapes 
  • Change the background 
  • Add photos from your computer and online images 

PowerPoint 2016: Use slide master to modify a template 
Templates are a great way to create a presentation. Learn how to modify the colors, fonts, and layouts in a template to customize it to fit your style. 

  • Change the color theme 
  • Change the layout and fonts in a template 

PowerPoint 2016: Animating objects in PowerPoint  
Use animation to help focus the audience’s attention on important information 

  • Add transitions between slides in a presentation 
  • Add animation to objects and text