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
- Docs – online word processor
- Sheets – online spreadsheet program
- Slides – online presentation program
Bring your own device.
- Windows 10
- iPhone and iPad
- 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
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
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