This class will teach participants how to:

• Advanced data management: Text to columns, combining and separating fields, etc
• Linking worksheets
• Popular formulas
• Pivot tables

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

This course will be taught using MS Excel 2003.

Has your organization already made the switch to Excel 2007? You can still join us! Everything taught in this class can be accomplished in the newer version!

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

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.

This course will be taught using MS Excel 2003.

Topics will include:

• Block Text Formatting - color, indenting, centering, etc
• Image Processing (resizing images in HTML)
• Tables

This is an intermediate course. Participants must have either taken a T4T beginning HTML course or have prior knowledge of and experience using basic HTML tags to format text, add links, and embed images.

And as always, T4T courses are only $10 for employees of nonprofit organizations!

CLASS POSTPONED - will be rescheduled in October.

This class will teach participants how to:

• Advanced data management: Text to columns, combining and separating fields, etc
• Linking worksheets
• Popular formulas
• Pivot tables

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

This course will be taught using MS Excel 2003.

And as always, T4T courses are only $10 for employees of nonprofit organizations!

CLASS POSTPONED - will be rescheduled in October.

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

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.

This is an advanced class for students who need to analyze and report on the data in Access 200/2003. Students will create more advanced queries with multiple criteria and calculations. Students will run a wide variety of queries and there will be plenty of time to answer questions.

Students will use the query wizard to answer basic questions like, “Who made a donation last year?” or “List all employees in alphabetical order with phone numbers.” Students will learn how to use the query as the basis for a nicely formatted report. Students will also learn how to export the data to Excel.

In this class, you will learn how to create a table to store information needed by your non-profit (e.g. donors, grants).
Then, you will create a form which makes it easy to add, modify, delete or view the data.

This class will be an entry level introduction to MS Excel 2007.

Topics will include:

• Functionality overview
• Basic navigation
• Worksheets and Workbooks
• Adding and editing data
• Introduction to formulas
• Formatting data
• Help function

And as always, T4T courses are only $10 for employees of nonprofit organizations!

This is an entry-level workshop which presumes no knowledge of Publisher 2007.

In this class, you will be introduced to

Join Steve Kessler, your Denver DataMan, on the 2nd and 4th Tuesday of the month from 8:30 to 9:30 at Starbucks at Tamarac Square Mall. Denver DataMan will answer your computer questions^*. This is a great time to ask advice about buying a new computer, creating a blog, getting on Facebook or just needing help finding a button in Office 2007.

Prior to registering for the class, please take a moment to fill out this quick survey. This will help us ensure that the class material is relevant to the participants.

This class will teach users how to create tables in Microsoft Access (2000/2003) to store information about donors, or other nonprofit constituent groups. Users will also learn how to create forms to maintain the accuracy of the information using functions such as add, modify, delete, or view a record.

This class will teach participants how to use the MS Access (2000/2003) Report Wizard to create basic reports about donors or other nonprofit constituents. We will also cover switching to Design View in order to customize reports. Advanced reporting and charting techniques will be covered as time allows.

This workshop will introduce users to the new features and updated user interface of the MS Office 2007 Suite, including:

• The Microsoft Office Button
• The Ribbon
• The Quick Access Toolbar
• The Microsoft Office Window Frame
• Dialog Box Launchers
• Galleries
• Live Preview

This workshop will introduce users to the new features and updated user interface of the MS Office 2007 Suite, including:

• The Microsoft Office Button
• The Ribbon
• The Quick Access Toolbar
• The Microsoft Office Window Frame
• Dialog Box Launchers
• Galleries
• Live Preview

This workshop will introduce users to the new features and updated user interface of the MS Office 2007 Suite, including:

• The Microsoft Office Button
• The Ribbon
• The Quick Access Toolbar
• The Microsoft Office Window Frame
• Dialog Box Launchers
• Galleries
• Live Preview

Suppose that you need to send each of your employees a letter containing personal tax withholding and salary information. Or perhaps you want to send a personalized form letter to each of your donors. Creating each letter individually would take hours, but using the mail merge function, all you have to do is create one document, add some placeholders, and Microsoft Word will combine the main document with your unique information to create a set of complete documents.

Join us to learn how to effectively use the mail merge function and you'll save yourself hours of menial work!

This class will teach participants how to use the MS Access (2000/2003) Report Wizard to create basic reports about donors or other nonprofit constituents. We will also cover switching to Design View in order to customize reports. Advanced reporting and charting techniques will be covered as time allows.

This class will teach users how to create tables in Microsoft Access (2000/2003) to store information about donors, or other nonprofit constituent groups. Users will also learn how to create forms to maintain the accuracy of the information using functions such as add, modify, delete, or view a record.

This fun and innovative class will teach you a variety of tips, tricks and shortcuts to use in various Microsoft Office programs including Word, Excel and PowerPoint. If you use Microsoft Office software on a daily basis, you don't want to miss this class!

Microsoft Excel (2000/2003) Basics

This workshop will cover the following:

• Basic formulas
• Basic formatting
• Basic graphs and charts
• Sorting and subtotaling
• Worksheets (name, move, copy)
• Page set up options and page breaks

This workshop assumes some basic knowledge of MS Excel.

Join Denver DataMan Steve Kessler to take a look at email marketing strategies. We will cover list building, the Can SPAM Act, getting your emails opened, drawing hits to your site with email marketing, and other related topics. Constant Contact will be used to frame the discussion.

Blogging Seminar

Not sure what a blog is?
Looking to learn how a blog can help your business?
Want to learn how to find other blogs?

If you answered yes to these questions, then you should consider attending Denver DataMan's Blogging seminar. This seminar will provide a look at what blogs are, why we hear so much about them, how to set up a blog for your business, and how to find other blog content on the Web.

Facebook, LinkedIn, Meetup, Orkut, YouTube and so many more.

Want to learn how to use social networking to market your business?
Join Steve Kessler, your Denver DataMan to learn how to use social networking to advance your business.

Only $10 for nonprofits

Panera Bread

EMAIL-MYSPACE- FACEBOOK-GOOGLE-INSTANT MESSAGING -BLOGS -LIBRARY COMPUTERS -YOU TUBE

With so many different sites YOU need to be aware!

EMAIL-MYSPACE- FACEBOOK-GOOGLE-INSTANT MESSAGING -BLOGS -LIBRARY COMPUTERS -YOU TUBE

With so many different sites YOU need to be aware!

Do you buy things online?

Do you use wireless hot spots?

Do you bank online?

Are you safe online?

Join Steve Kessler, the Denver DataMan, as he presents this class on safely using the Internet to protect your identity and computer from digital predators.

Join Steve Kessler, the Denver DataMan, as he presents this class on the searching the Internet and finding what you are looking for. This class is a must for anyone who needs to find information online. Though the class will cover general Internet seatching an effort will be made to focus on the needs of nonprofit orginizations.

We will be covering more than just Google.

NOTICE: This class was canceled due to low participation. If you would like to see this class offered again, please contact us.

Computer skills rusty? Never learned the basics? The Denver Public Library can help.

Several local library branches are offering bilingual (English/ Spanish) computer classes for absolute beginners, free of charge. Topics include using the mouse, saving and printing documents, working in Microsoft Word, navigating the World Wide Web and using e-mail. The participating branches are Blair-Caldwell, Ford-Warren, Hadley, Hampden, Montbello, Ross-Barnum and Woodbury.

For more information, visit www.denverlibrary.org/classes or go directly to one of the branches listed above. All programs are free and open to the public. No registration required.

The Woodbury branch of the Denver Public Library needs an assistant to help teach basic computer classes to adults. This is a part-time (Tuesdays 5:00 pm – 7:00 pm), paid position ($12 per hour). Applicants must have solid computer skills, speak English and Spanish fluently, and feel comfortable helping teach computer skills to people with varied literacy levels.

Sound like you? Call Yanira or Lisa at 720-865-0930 with further questions or to request an application.

Join Steve Kessler, the Denver DataMan, as he presents this class on the searching the Internet and finding what you are looking for.

We will be covering more than just Google.

If you have a laptop, please bring it.
Internet access is available at the bridge center.

There is plenty of time after class to network

You would not leave your wallet laying out on the street and you should not do the same with your digital identity. This class will cover the basics for keeping yourself safe online.

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, time permitting!):

Intro. FrontPage

This class will cover introductory topics in FrontPage, such as

• page creation
• working with images
• link creation and management
• changing backgrounds
• saving time with templates

Limit: 8 participants.

Office Advanced Tips & Tricks

For the user with Microsoft Office savvy (you don't have to be a pro)...

In this hour-and-a-half, 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. Course content will be customized to fit the group.

Quick tips will be taught throughout the class while focusing on the commonalities among Windows applications.

Limit: 8 participants.

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.

Limit: 8 participants.

Introduction to Mail Merge

Mail Merges allow you to write a letter or email once and then customize it for many recipients automatically. Mail merges are easy and immediately useful.

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.

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.

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.

Advanced Mail Merging Techniques

This workshop is for the user who has a basic 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

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.

Outlook -- More than Just Mail

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

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.

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.

Are you using the standard PowerPoint templates, creating presentations with pages upon pages of text, and would like your presentations to be more creative? Then this is the class for you.

This class is designed to teach you how to use PowerPoint as a “visual aid” tool to keep your audience's attention and help deliver your message in a clear, concise and CREATIVE way.

This class assumes a working knowledge of PowerPoint. This is not a beginner class.

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.