Southern Colorado
Introduction to HTML
Submitted by AndyWhere: CPCD
This is an introductory class meant to introduce the concepts and semantics of HTML. It is aimed at beginners.
This class will not make you an expert, but hopefully you will take away some solid basics.
We will cover:
- What HTML is and how it works
- How to write basic pages by hand, including
- Page headers, body
- Text formatting, links, images
- Lists and tables (as time permits)
- The role of editors like Dreamweaver, FrontPage, Komposer, etc.
Volunteer Spotlight on Tricia Haas
Submitted by Lisa on Thu, 05/22/2008 - 4:13pm.If you are an MS Office user in Colorado Springs and, like many of us, know just enough to get into trouble, then we'd like to introduce you to some of the brilliant volunteers at our software training program. Tricia Haas is one of our generous volunteers who are experts in their fields and willing to share their knowledge and skill sets with us.
More About Excel
Submitted by LisaWhere: CPCD
Students should already have some working knowledge of Excel. This is not a beginner’s class. Students will learn how to:
• Use lists
• Charts and graphs
• Customize your toolbars and menus
• Use Auto filter
• Use intermediate formulas
Access Queries
Submitted by LisaWhere: CPCD
This class is for students who are already familiar with Access tables and basic navigation of Access. Students will learn how to:
- Create, run, modify and save queries using design view
- Specify criteria in a query
- Select, sort, group, calculate and concatenate
- The SQL statement
Basics in PowerPoint
Submitted by LisaWhere: CPCD
Students will learn how to:
- Add new slides
- Work with text
- Navigate between slides
- Add notes
- Use design templates
- Copy slides
- Insert Clip Art
- Add animation
HTML - Getting your Feet Wet
Submitted by BrianThis introductory class will provide you with the concepts and semantics of HTML. It is aimed at beginners. This class will not make you an expert, but hopefully you will take away some solid basics.
Access: Intro to the Basics
Submitted by Lisa
This class is considered a beginner class.
Topics include:
- What is a Relational Database?
- Basic MS Access Toolbars?
- The Database Foundation--Tables
- Have a question, Answer it with a Query
- Capture Data in Style - Basics on Forms
- Display it--Reports
- Improve your Efficiency--Intro to Macros
- MS Access User Groups
- Experience Discussion/Demo
PowerPoint: Basic Things to Know
Submitted by LisaThis class will use Microsoft Power Point for straightforward visual presentations.
This workshop will cover the following:
- Use of Templates and Formatting
- Just because you can does not mean you should
- Working with pictures and clip art
- And, of course, printing
Please bring your questions and you're sure to leave with new skills you can put to use as soon as you're back in the office.
Excel: Data Organization
Submitted by LisaThis workshop will cover the following:
- Expediting data entry
- Importing data from other sources
- Filling in data based on existing data
- Using Paste Special
- Changing the appearance of cells
- General formatting
- Formatting based on cell contents
- Copying another cell's format
- Organizing data
- Hiding/Unhiding
- Sorting
- Filtering
- Grouping
Mail Merge: Using the Wizard
Submitted by LisaThis workshop will cover the following:
- Concepts and uses of a mail merge
- Create data sources using various programs
- Create and modify form letters
- Sort and/or select data for the merge
- Create and print envelopes
This class assumes a basic understanding of MS Word.
Excel: Calculations and Charts
Submitted by LisaThis workshop will cover the following:
- Calculations
- Entering formulas to perform calculations
- Using cell references to automatically update formula results
- Understanding how functions simplify formulas
- Charts
- Using the Chart Wizard to Create a New Chart
- Modifying Existing Charts
Excel: Before Basics
Submitted by LisaThis workshop will cover the following:
- "I want to use Excel, Where do I start?"
- Understanding and moving around the spreadsheet
- Formatting the cells
- Understanding the Menu Items
- Tips on how to let Excel "do the work"
Organizing Outlook
Submitted by LisaThis workshop will cover the following:
- Import and Export Address Book
- Organizing Incoming Email by Sender, Topic, Discussion
- Organizing Email With Flare, Folders, Flags, and Follow-up
- Organizing Contacts by Category and Views
- Hot Key Shortcuts
Word: Beyond Basics
Submitted by LisaIn this hands-on class, students will explore advanced Word 2003 concepts. Students will learn how to format a document, create a TOC for that document, and add hyperlinks, headers and footers.
This Workshop will cover the following:
- Headers and Footers
- Styles and Formatting
- Table of Contents
- Hyperlinks
This class is for those who feel comfortable using Word 2003 features and want to learn more.
Intro to Excel
Submitted by LisaThis workshop will cover the following:
- The Basics
- Terminology
- Parts of the Window
- Setting Up a Workbook and Getting Around In It
- Page setup
- Working with sheets
- Manipulating columns and row
- Modifying the view
- Using Help
- Entering data
- Simple formulas
Outlook for Beginners
Submitted by LisaThis workshop will cover the following:
- Navigating Outlook
- Setting Outlook Preferences for Mail
T4T Social
Submitted by LisaT4T in Colorado Springs is hosting a Member Agency Social to meet current and future member agencies and introduce new staff members, volunteers and partners. In addition, we will also be announcing our exciting new programs for the coming year! We hope you attend! The Social will be held at the Pikes Peak United Way (518 N. Nevada Ave.) from 4:00 pm to 5:00 pm. Please RSVP to Lisa Leibold at 719-955-0746 or lleibold@t4tcolorado.org.
Word Workshop: Templates
Submitted by LisaT4T in Colorado Springs is conducting its first software training workshop in MS Word. The topic is Template Creation and Usage and will cover the following:
- What are templates? Where would they be beneficial?
- Design a template for use in your agency
- Create and modify the template
- Use the template to generate a document
- Organization of templates and documents
The workshop will run 9:00am to 10:30am at the Business of Art Center in Manitou Springs, CO. Space is limited so sign up now. The cost is FREE!
Workshop: Basic Functions in Outlook
Submitted by LisaT4T Colorado Springs is conducting a software training workshop in MS Outlook.
The class will cover the following topics:
- Personalizing messages
- Voting requests, appointments, and meeting requests
- Creating Signatures
- Creating a distribution list
- Creating a Out-of-Office Assistant
PowerPoint Workshop
Submitted by LisaIs your audience a small group or a large group? Is your audience internal or external? Does the audience like information presented short and to the point? Do they like information presented visually? Will the information be viewed on screen, as a printout or both? Will the information be view by individuals on their own computer? Will the information be viewed by a group in a conference setting?
This Workshop will also cover the following topics:
- Using the Slide Master
- Using Footers/Headers
- Formatting Text
- Using the Pictures Toolbar
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Workshop: Excel Tips and Tricks
Submitted by LisaHow can Microsoft Excel make your job easier? Learn some easy Excel tips and tricks that will save you time and energy.
Topics covered:
- Sorting Data
- Writing basic formulas and functions
- Copying formulas and functions
- Freezing panes
- How to convert data into charts and graphs
- Printing functions (How to print only the data you want, and how to format your printed data so that it is easy for you and others to understand)
Mail Merge Workshop
Submitted by LisaThis workshop will cover the following:
- Concepts and uses of a mail merge
- Create data sources using various programs
- Create and modify form letters
- Sort and/or select data for the merge
- Create and print envelopes
This class assumes a basic understanding of MS Word.
Workshop: Beginning Publisher
Submitted by LisaThis workshop will cover the following:
- Create a Quick Publication
- Print Your Work
- Selecting and Manipulating Objects
- Using Text Boxes
- Using the Selection Tool
- Insert the Current Date and Time
- Change the Paper and Fold Type
- Insert Pages
- Delete Pages
- Text Attributes
PowerPoint Workshop: Beginner
Submitted by LisaThis workshop will cover the following:
- Using the Slide Master
- Using Footers/Headers
- Formatting Text
- Using the Pictures Toolbar
- Inserting Images (Clip Art, Pictures from File or CD)
- Formatting Images (Resize, Recolor)
- Customizing Bullets
- Line Spacing
- Save as Types: Presentation (.ppt) and PowerPoint Show (.pps)
- Inserting a Slide from Another File
- Creating and Formatting Tables
- Using Action Buttons
- Custom Shows
- Using PowerPoint Templates
Workshop: Advanced Excel
Submitted by LisaThis hands-on class is designed for students who have prior experience working with Excel
- Importing/exporting data
- Pivot tables
- Passwords and Security
- Using email and Outlook features in Excel
- Working with multiple Worksheets
Workshop: Introduction to the Internet
Submitted by LisaThis workshop will cover the following:
- The Browser
- World Wide Web
- Searching the WWW
- Search Strategies
- Search Engines
- Directories
- Internet Security
Workshop: Advanced Excel
Submitted by LisaThis hands-on class is designed for students who have prior experience working with Excel
- Importing/exporting data
- Pivot tables
- Passwords and Security
- Using email and Outlook features in Excel
- Working with multiple Worksheets
Excel Workshop: Beginner
Submitted by LisaThis workshop will cover the following:
- Basic Formulas (Add, Subtract, Multiple, Divide - Rows and Columns)
- Format (column, row, font, text wrap, merge cells)
- Basic Graphs/Charts
- Sort Cells and Data Filters
- Creating a Data Entry Form
- Adding, Edit and Deleting Comments
- Worksheets (Name, Move, Copy)
- Page Setup Options and Page Breaks
Mail Merge Workshop
Submitted by LisaThis workshop will cover the following:
- Concepts and uses of a mail merge
- Create data sources using various programs
- Create and modify form letters
- Sort and/or select data for the merge
- Create and print envelopes
Workshop: Basic Access
Submitted by LisaIn this hands-on class, students will create a database from scratch and learn about all the main Access object types (Tables, Queries, Forms, Reports). No prior experience with Access is required. This course will cover the following topics:
- What is a relational database and what are the benefits or using one?
- Creating Tables and setting data types
- Write a basic Query
- Design a Form
- Design a Report
Workshop: Intermediate Word
Submitted by LisaThis workshop will cover the following:
- Headers and Footers
- Styles and Formatting
- Table of Contents
- Hyperlinks
- Inserting and customizing images
- WordArt
Workshop: Intermediate Publisher
Submitted by LisaThis workshop will teach you to:
- Create Bulleted Lists
- Create Numbered Lists
- Insert Clip Art
- Insert a Picture from a File
- Create WordArt
- Use a Flyer Template
- Create a Greeting Card
- Create Business Cards
- Use the Newsletter Wizard
- Enter Your Own Content in the Newsletter
- Use the Postcard Wizard
PowerPoint Workshop: Continuing to Enhance Your Presentation
Submitted by LisaThis workshop will cover the following:
- Animation. Hands-on Projects
- Slide Show Setup Options
- Drawing and AutoShape Objects
- Formatting (Font, Autoshape, Lines and Tables)
Access Workshop: Introduction to Forms
Submitted by LisaThis class assumes the student understands basic navigation of the Access database, creating tables, and creating and running queries.
Topics include:
- Planning and creating a form
- Modifying tab order
- Using the toolbox to modify a form
- Understanding and formatting objects
- Entering, editing, searching and filtering records
- Creating a form based upon a query
Workshop: Advanced Excel
Submitted by LisaThis hands-on class is designed for students who have prior experience working with Excel.
- Importing/exporting data
- Pivot tables
- Passwords and Security
- Using email and Outlook features in Excel
- Working with multiple Worksheets
Access Workshop: Introduction
Submitted by LisaThis workshop will cover the following:
- Intro to Access
- Creating Tables – Datasheet
- Design View
- Field Properties
- Primary Key
- Adding and Deleting Records
- Creating and Running Queries
Workshop: Navigating Windows XP
Submitted by LisaThis workshop will cover the following:
- Why use Windows XP
- How to navigate Windows XP
-
- -Windows Explorer, Control Panel, etc.
- Installing programs and deleting programs
- Folder management and security
- Managing users
Access Workshop: Introduction
Submitted by LisaThis workshop will cover the following:
- Intro to Access
- Creating Tables – Datasheet
- Design View
- Field Properties
- Primary Key
- Adding and Deleting Records
- Creating and Running Queries
Access Workshop: Introduction
Submitted by LisaThis workshop will cover the following:
- Intro to Access
- Creating Tables – Datasheet
- Design View
- Field Properties
- Primary Key
- Adding and Deleting Records
- Creating and Running Queries
Workshop: Advanced Publisher
Submitted by LisaThis workshop will cover the following:
- Create a Brochure
- Create an E-Mail Publication
- Insert an E-mail Hyperlink
- Send an E-Mail Publication
- Create a 3-page Web Site
- Use the Easy Web Site Builder
- Add Pages Manually
- Remove Pages
- Customize a Page Layout
PowerPoint Workshop: Enhancing Your Presentation
Submitted by LisaThis workshop will cover the following:
- Using the Slide Master
- Using Footers/Headers
- Formatting Text
- Using the Pictures Toolbar
- Inserting Images (Clip Art, Pictures from File or CD)
- Formatting Images (Resize, Recolor)
- Customizing Bullets
- Line Spacing
- Save as Types: Presentation (.ppt) and PowerPoint Show (.pps)
- Inserting a Slide from Another File
- Creating and Formatting Tables
- Using Action Buttons
- Custom Shows
- Using PowerPoint Templates
Access Workshop: Introduction to Queries and Reports
Submitted by LisaThis class assumes the student understands basic navigation of the access database, creating tables, creating and running queries, creating forms.
Topics include:
- Introduction to relationships
- Adding a subform to a form
- Joining Tables in a Query
- Creating a Parameter Query
- Designing and modifying a report based on a Table or Query
Excel Workshop: Basic Functions
Submitted by LisaThis workshop will cover the following:
- Basic Formulas (Add, Subtract, Multiple, Divide - Rows and Columns)
- Functions (IF, AND, OR, NOT, MATCH, TRUE, FALSE)
- Vlook Up / Hlook Up
- Pivot Tables
- Creating Fill-In Forms
- Protecting Cells
Mail Merge Workshop: Using the Wizard
Submitted by LisaThis workshop will cover the following:
- Concepts and uses of a mail merge
- Create data sources using various programs
- Create and modify form letters
- Sort and/or select data for the merge
- Create and print envelopes
This class assumes a basic understanding of MS Word.
