You are here
Computer Classes
New! Virtual Computer Instructional Videos Delivered to Your Email
Choose a topic and select the date you’d like to receive the learning material. A link to an instructional video will be emailed to you along with a participant guide, and the instructor’s contact information. Watch the videos at your convenience. The technology educator will check in with you, via email, throughout the week. Assistance is available as needed. All videos offer closed captioning. For more information, please contact Sarah Pistilli at spistilli@scpld.org
- Classes are open to St. Charles Public Library cardholders only
- REGISTER online, by phone or in person at any service desk.
- Class size is limited to 15.
On the chosen date, you will receive an initial email from our Technology Educator, Sarah Pistilli, containing directions, a link to an online video, and a participant guide. Sarah will send you a second email on the Thursday of that week to check in with you. On the following Monday, you will receive a final email to wrap up the learning experience.
Google Docs Lesson 1: Introduction to document formatting
In this instructional video, you will learn how to
- 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
Learn advanced document formatting skills in this instructional video
- Customize margins, line spacing, columns, and indents
- Apply paragraph styles
- Create internal and external links
- 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
Apply formatting automatically based on conditions that you define in advance
- 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 Slides: Create newsletters, flyers, 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
Animating objects in Google Slides
This instructional video shows you how to
- Add transitions between slides in a presentation
- Add animation to objects and text
Microsoft Word 2016 Lesson 1: Introduction to document formatting
In this instructional video, you will learn how to
- 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 in this instructional video
- 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
Learn how to add even more content to your Word documents in this instructional video
- 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
Apply formatting automatically based on conditions that you define in advance
- 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
PowerPoint: 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: 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
Animating objects in PowerPoint
This instructional video shows you how to
- Add transitions between slides in a presentation
- Add animation to objects and text
Check our calendar for this month's computer classes.