This class will teach participants how to:

• Format and print workbooks
• Customize spreadsheet layouts
• Arrange multiple worksheets on one screen
• Freeze and unfreeze rows and columns
• Hide and unhide worksheets
• Create and modify charts
• Sort and filter data
• Efficiency tricks for adding, moving and deleting data
• Using basic formulas

This is an intermediate level class. Participants must have either taken a T4T beginning Excel course or have prior knowledge of and experience using Excel.

What is Joomla! ?

This workshop will explore ways to leverage email marketing as a valuable tool for marketing your nonprofit. We will discuss becoming a trusted sender, avoiding SPAM filters, and the tools available.

Do you buy things online?

Do you use wireless hot spots?

Do you bank online?

Are you safe online?

This Office Tips and Tricks class will benefit beginner and intermediate Office users alike ... and even the pros may learn a thing or too!

Content Management Systems were all the rage at the 2007 NTEN conference and a frequent topic of nonprofit technology articles and seminars from TechSoup and Idealware and the like.

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
• The role of editors like Dreamweaver, FrontPage, Nvu, GoLive, etc.

By the end of the class you will (hopefully):

1. Build a simple site by hand
2. Make some sense of what Dreamweaver (etc.) generates

Evaluating Hosting Solutions

Evaluating Web Hosting Solutions is a seminar which will give non-profits the tools and knowledge to find a web hosting provider which meets their needs and budget. By the end of the seminar, participants will be able to answer these questions:

• Why does it make a difference which web hosting solution I use?
• How do I know what I do and do not need?
• Should my web designer be my host?
• What can I expect to pay for a web host?
• What should I look for in a web host?

Intelligent Web Design Seminar

This small-group seminar is an excellent opportunity to sit down and talk with a web design professional.

Aimed at webmasters and anyone responsible for online communication, this seminar will address how best to clearly deliver your message to the widest audience, including individuals with special needs.

Topics covered:

• What makes a good website?
• How to make a website simple and easy to navigate
• How much graphic design does a website really need?
• The foundations of making websites usable by anyone

Calendars and Contacts in Outlook

Sure you can send and receive email, but Outlook can do so much more. Do you want to better understand the powerful tool that sits open on your desk everyday? Do you want to manage your address book and calendar with the same finesse you exhibit handling email (and maybe even more)?

Teaming for Technology is pleased to announce its first workshop in the Boulder area!

Do you have lists of names and addresses that you would like to be able to make labels from ... or do even more? This class will help you learn to use Microsoft Mail Merge with Microsoft Word, Excel, Access, and Outlook. Please bring any questions or challenges you may have regarding merging so we may address them. Feel free to bring an address list to work on as well, if you like.

Often, organizations try to organize data in Excel spreadsheets. Perhaps it's only a handful of addresses, maybe a short list of volunteers, or even just some office equipment. As needs grow, however, that short list quickly becomes long, and a handful becomes a hundred! When Excel becomes ungainly and unmanageable, a more robust Access database is often and ideal solution. This workshop delves into the migration from Excel to Access. Bring your own spreadsheet and begin the process immediately, or work with our sample files.

Are you interested in more effectively presenting your information? Want to create zing and make your content come to life meaningfully? Learn how to integrate Word documents, Excel spreadsheets, pictures, and even video and animation into PowerPoint presentations to most effectively deliver your message. This hands-on how-to session will include dos and don’ts appropriate for both live presentations as well as print and email distribution.

This workshop assumes no knowledge of mail merges! All you need is a basic understanding of how to use your computer and the ability to operate Word and Excel at a beginner level. Mail merges are easy and immediately useful.

By the end of this workshop you will:

• Understand mail merges and what they can do for you.
• Be able to manage a mailing list in Excel.
• Merge information from Excel (or Access) into Word using the Wizard.
• Be able to email or print simple, useful group mailings.

This workshop is for the user who has a decent understanding of a mailing list in Excel, Outlook, or Access. No prior mail merge experience is necessary, but the fundamentals of list management will be assumed. If you took the basic class and want to take it to the next level, this is for you!

By the end of the workshop you will:

• Be able to merge without the limitations of Wizards
• Include logical statements to customize and limit
• Merge with Outlook and understand the role of queries in Access

Sure you can send and receive email, but Outlook can do so much more. Do you want to better understand the powerful tool that sits open on your desk everyday? We will cover:

• Mail rules
• Searching strategies
• Cool tools with contacts
• ... and More

eCommunication Seminar: eMarketing

This is the first seminar in our two-part series in Effective Web Communication.

Aimed at anyone responsible for online communication, this is for anyone who knows what the Internet is and how to send an e-mail. Many of the solutions out there will let you start out with templates, and it is as easy any other point-and-click task, once you know where to start.

We will cover:

• Websites
• eNewsletters
• Getting the word out about your website
• And other related topics.

eCommunication Seminar: Effective Website Design

This is the second seminar in our two-part series in Effective Web Communication.

Aimed at webmasters and anyone responsible for online communication, this seminar will address how best to clearly deliver your message to the widest audience, including individuals with special needs.

Topics covered:

• What makes a good website?
• How to make a website simple and easy to navigate
• How much graphic design does a website really need?
• The foundations of making websites usable by anyone

Microsoft Office Tips and Tricks

This class will benefit beginner and intermediate Office users alike!

Whether you are a regular user or relatively new to Microsoft Office, you will gain new tips on increasing your productivity with MS Office. This workshop focuses on techniques that work throughout the MS Office suite -- and even in other Windows applications. Two examples include: compiling resources from multiple applications in a Word document, and quickly turning Word documents into PowerPoint presentations.

Microsoft Office Tips and Tricks

This class will benefit beginner and intermediate Office users alike!

Whether you are a regular user or relatively new to Microsoft Office, you will gain new tips on increasing your productivity with MS Office. This workshop focuses on techniques that work throughout the MS Office suite -- and even in other Windows applications. Two examples include: compiling resources from multiple applications in a Word document, and quickly turning Word documents into PowerPoint presentations.

Looking for a way to more effectively engage your audience for presentations? PowerPoint offers a powerful platform to design and present multi-media presentations. In this two-part series, we will not only learn the PowerPoint application but also talk about its effective use and techniques.

This initial workshop will cover the following:

• Introduction to features and uses of PowerPoint
• Views
• Slides
• • Placing text
  • Placing pictures
  • Placing WordArt

Don't keep doing the same work over and over. Take this class on how to create templates using Word, and eliminate repetitive tasks. Give the whole office access to your electronic forms while preventing users from accidentally saving over your original. Learn how to create fill-in forms or just simple letterhead. It is helpful if you have basic Word skills, but everyone will take away a new skill from this class.

This class will focus on what you need to get you started making Excel spreadsheets that work. You will learn how to create basic formulas, basic charts and how to get printed results that look like what you want. Since most Excel formatting techniques (font, size, etc) are the same as Word we won't focus on formatting, but it will be included in the overall content of the class. If you want a jump start on Excel, this is the class for you. As always, bring your questions, and you're sure to go away with new skills you can use right away.

Looking for a way to more effectively engage your audience for presentations? PowerPoint offers a powerful platform to design and present multi-media presentations. In this two-part series, we will not only learn the PowerPoint application but also talk about its effective use and techniques.

This final workshop will cover the following:

• Slide masters
• Placing and animating graphs
• Layering animation
• Slide transitions
• User question and answer

Ask the DataMan Session

This is an open forum for you to ask your computer questions. Steve, the Denver Dataman, will answer the questions and demonstrate the procedures. Because of the impromptu nature of the event, some questions may require a little research or follow up (which is offered free of charge).

This small-group seminar is an excellent opportunity to sit down and talk with a web design professional.

Aimed at webmasters and anyone responsible for online communication, this seminar will address how best to clearly deliver your message to the widest audience, including individuals with special needs.

Topics covered:

• What makes a good website?
• How to make a website simple and easy to navigate
• How much graphic design does a website really need?
• The foundations of making websites usable by anyone

Looking for a way to more effectively engage your audience for presentations? PowerPoint offers a powerful platform to design and present multi-media presentations. A little prior knowledge of PowerPoint will be helpful; we will not only learn the PowerPoint application, but also talk about its effective use and techniques. (This class is taught on PowerPoint 2003)

This workshop will cover the following:

• Slide masters
• Placing and animating graphs
• Layering animation
• Slide transitions
• User question and answer

This class will benefit beginner and intermediate Office users alike!

Whether you are a regular user or relatively new to Microsoft Office, you will gain new tips on increasing your productivity with MS Office. This workshop focuses on techniques that work throughout the MS Office suite -- and even in other Windows applications. Such techniques may include: compiling resources from multiple applications in a Word document, and quickly turning Word documents into PowerPoint presentations. Course content will be customized to fit the group.

If you want a jump start on Excel, or just a good refresher, this is the class for you.

This class will focus on what you need to get started on making Excel spreadsheets that work. You will learn about the Excel interface, formatting, basic formulas, basic charts and graphs, and producing decent looking print-outs. As always, 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.

Class canceled.

This workshop is about getting a solid start with Access. The focus is on
understanding the building blocks of databases and how to work with them

You will learn:

• Creating and managing tables
• What relations are and connecting your data
• Finding the info you want with queries
• Useful Access Wizards

The idea is to get a good grasp of the fundamentals before you move onto
reports and forms and other fluffy things.

Evaluating Web Hosting Solutions is a seminar which will give non-profits the tools and knowledge to find a web hosting provider which meets their needs and budget. By the end of the seminar, participants will be able to answer these questions:

• Why does it make a difference which web hosting solution I use?
• How do I know what I do and do not need?
• Should my web designer be my host?
• What can I expect to pay for a web host?
• What should I look for in a web host?

Access II

This class will cover creating tables with various data types, managing relationships and forming queries based on more than one table. The class will also cover basic aspects of formatting forms and reports.

This class is canceled because too few participants signed up. We are offering the same class May 29th in Northern Denver. If you're interested, check it out.

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
• The role of editors like Dreamweaver, FrontPage, Nvu, GoLive, etc.

By the end of the class you will (hopefully):

1) Build a simple site by hand
2) Make some sense of what Dreamweaver (etc.) generates