Computer Applications

Click any title below to view a complete course description including a syllabus, instructor biography, prerequisites, and requirements.

Introduction to Microsoft Word 2007
Instructor: Craig Power

Learn how to create and modify documents in Word 2007, the most popular word-processing program available.

Introduction to Microsoft Excel 2007
Instructor: Craig Power

Discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. Learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, creating custom charts, creating 3-dimensional workbooks, building links, and creating macros and custom toolbar buttons.

Introduction to Microsoft Word 2003
Instructor: Craig Power

Learn how to create and modify documents in Word 2003, the most popular word-processing program available.

Intermediate Microsoft Word 2003
Instructor: Craig Power

Take advantage of Word 2003's publishing capabilities to easily create flyers, newsletters, brochures, and other heavily formatted documents.

Advanced Microsoft Word 2003
Instructor: Craig Power

Learn how to build time-saving macros, customize your toolbars, create shortcut keys, crank out form letters and mailing labels, perform queries, and much more.

Introduction to Microsoft Excel 2003
Instructor: Craig Power

Discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. Learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, creating custom charts, creating 3-dimensional workbooks, building links, and creating macros and custom toolbar buttons.

Intermediate Microsoft Excel 2003
Instructor: Craig Power

Learn how to work faster and more productively by using many of Excel 2003's powerful features, such as the PivotTable, Solver, and AutoFilter. Build worksheets with decision-making capabilities, and learn to use advanced graphing techniques.

Advanced Microsoft Excel 2003
Instructor: Chad Wambolt

Maximize your investment in Microsoft Excel by learning advanced techniques that most users don't even know exist. In this practical, hands-on course, you'll learn how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced pivot table techniques, like creating calculated fields and calculated items. You'll be able to use validation to protect the integrity of your worksheets from other, less experienced users. You'll become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything Excel has to offer.

Introduction to Microsoft Access 2003
Instructor: Craig Power

Learn how to use this powerful and award-winning database to store, locate, print, and automate access to just about any type of important information.

Intermediate Microsoft Access 2003
Instructor: Alan Simpson

Learn how to create real-world business databases using Microsoft Access 2003. Master the secrets of making the computer--not people--do all the work. Create tables, queries, forms, reports, and macros for managing contacts, products, orders, invoices, and receipts. Pull all the pieces together with a single, easy-to-use switchboard.

Introduction to Microsoft PowerPoint 2003
Instructor: Kathy Van Pelt

Learn how to use Microsoft PowerPoint 2003 to create impressive slide presentations filled with formatted text, images, video, audio, animation, charts, and links to the Web. You'll also learn how to save your presentations in HTML so they can be shared with others over the Web, and you'll discover some of the exciting new features exclusive to PowerPoint 2003, such as the Package-for-CD feature, the Research task pane, and the updated PowerPoint Viewer.

Introduction to Microsoft Visio 2003
Instructor: Amy Westlake

In today's fast-paced, technology-driven workplace, you need clear communication to get ahead. Learning to create professional-looking diagrams in Microsoft Visio 2003 will take your skills set to the next level. Follow along as a seasoned industry professional leads you through easy-to-follow projects and exercises to design diagrams based on industry standards and best practices. You'll learn how to use Visio's many features and functions to make your diagrams pop.

Introduction to Microsoft Project 2003
Instructor: Tony Swaim

Discover how to effectively plan, implement, and control projects using Microsoft Project 2003. In this hands-on course, you will find out how to apply the world's most popular project management software to your needs. You'll convert lists and schedules into an integrated plan you can be proud of, and you'll see how Microsoft Project can walk you through any project by helping you organize details, sequence tasks, produce a baseline, assign resources and costs, track progress, identify and analyze variances, revise your project plan, create schedules, and share everything with your customers and coworkers.

Introduction to Microsoft Publisher 2003
Instructor: Allyson Hart Benavides

Learn how Microsoft's comprehensive, yet easy-to-use, desktop publishing package can help you create and publish a wide variety of stunning documents. This hands on, project oriented course will give you valuable experience in designing, developing, and publishing newsletters, Web sites, and brochures. And if you're new to graphic design, you'll receive plenty of expert guidance in selecting and using images, colors, and layouts.

Introduction to Microsoft Outlook 2003
Instructor: Bill Mann

Harness the communication and information management power of Microsoft Office Outlook 2003. Take advantage of its redesigned interface and new features to become more organized and productive than ever before.

Introduction to QuickBooks 2007
Instructor: Craig Power

Learn how QuickBooks makes it easy to set up a chart of accounts, reconcile your checking account, create and print invoices, receipts, and statements, track your payables, inventory, and receivables, create estimates and generate reports.

QuickBooks 2007 for Contractors
Instructor: Scott Paxton

Designed specifically for contractors, this course addresses the specific accounting needs of the construction industry. We'll focus on how to use the Premier Contractor Edition of QuickBooks 2007 to run your contracting business more efficiently. Clear lessons and step-by-step instructions written in plain language will give you hands-on practice using the features that you're sure to use on a daily basis.

QuickBooks 2006 for Contractors
Instructor: Scott Paxton

Designed specifically for the construction industry, QuickBooks for Contractors uses the Premier Contractor Edition of QuickBooks to show you how to utilize this powerful program to create estimates, progress invoices, and even job cost reports. You'll avoid making common mistakes by learning the proper file setup techniques for contractors, and you'll discover the secrets to help you create useful and dynamic management reports.

Performing Payroll in QuickBooks 2009
Instructor: Scott Paxton

Learn how to use QuickBooks 2009 to process payroll quickly and easily. You'll discover all the steps you need to take to properly set up your payroll system, troubleshoot common problems, and avoid mistakes.

Performing Payroll in QuickBooks 2007
Instructor: Scott Paxton

Learn how to use QuickBooks software to process payroll quickly and easily. You'll discover all the steps you need to properly set up your payroll system, troubleshoot common problems, and avoid mistakes.

Introduction to Crystal Reports 10
Instructor: Allen Taylor

Learn how to use Crystal Reports to convert raw database or accounting data into meaningful and readable reports. Impress your peers, clients, and superiors by discovering new ways to convey information. By the time you finish this course, you'll be able to create a wide variety of handsome and sophisticated reports that communicate more--much more--than mere facts. You'll also be able to use charts and maps to present information visually, and cross-tabs to show correlations between loosely related data items. You'll even find out how to save yourself time and effort by creating a library of custom functions you can use over and over in report after report.

Introduction to Microsoft Access 2007
Instructor: Craig Power

Learn how Microsoft's powerful and award-winning database can help you manage, store, search, analyze, and display important business, personal, or scientific data. You'll gain practical, hands-on experience with tables, relationships, custom data entry forms, queries, mailing labels, macros, and more. Increase productivity, reduce data entry errors, conduct comprehensive searches, and produce handsome and professionally formatted reports.

Introduction to Microsoft Outlook 2007
Instructor: Bill Mann

Learn the essentials of Microsoft Outlook 2007 from an expert instructor who's already helped thousands become productive and confident with previous versions of Outlook. Get up and running quickly with the most important aspects of the program, and even create a Google Gmail account for class assignments and personal use.

Introduction to Microsoft PowerPoint 2007
Instructor:

Learn how to use Microsoft PowerPoint 2007 to create impressive slide presentations filled with formatted text, images, video, audio, animation, charts, and hyperlinks. Find out how to save your presentations so you can share them with others over the Web or on CDs.

Introduction to Microsoft Project 2007
Instructor: Tony Swaim

Discover how to effectively plan, implement, and control projects using Microsoft Project 2007. In this hands-on course, you'll find out how to apply the world's most popular project management software to your needs. You'll convert lists and schedules into an integrated plan you can be proud of, and you'll see how Microsoft Project can walk you through any project by helping you organize details, sequence tasks, produce a baseline, assign resources and costs, track progress, identify and analyze variances, revise your project plan, create schedules, and share everything with your customers and coworkers.

Introduction to Microsoft Publisher 2007
Instructor: Allyson Hart Benavides

In this hands-on, project-oriented class for beginners, you'll learn how to design, create, and publish a wide variety of stunning documents using Microsoft Publisher 2007. If you're looking for a quick, easy, and inexpensive way to produce professional brochures, newsletters, flyers, or even a Web site, Microsoft Publisher 2007 is your solution! This affordable and functionality-packed program can take you to levels of design expertise you never dreamed possible.

Introduction to Microsoft Visio 2007
Instructor: Amy Westlake

Get the training you need to create professional-looking flowcharts and diagrams using one of the most popular flowcharting programs on the market, Microsoft Visio 2007. Follow along as a seasoned industry professional leads you through easy-to-follow projects and exercises that teach you how to design diagrams based on industry standards and best practices. You'll learn how to use Visio's many features and functions to make your diagrams pop.

Introduction to QuickBooks 2008
Instructor: Craig Power

Learn how QuickBooks makes it easy to set up a chart of accounts, reconcile your checking account, create and print invoices, receipts, and statements, track your payables, inventory, and receivables, create estimates and generate reports.

Introduction to Microsoft Office Accounting Professional 2008
Instructor: Mary Salzman

Learn how to use Microsoft Office Accounting Professional 2008 from a Certified Public Accountant who specializes in small-business accounting. Because it's tailored for small businesses with fewer than 25 employees, you'll find it easy to set up Microsoft Office Accounting Professional 2008 to meet your specific needs. Through easy-to-follow instructions and hands-on activities, you'll get comfortable with every major accounting task you need to do—from balancing the company checkbook, to preparing financial statements, to creating listings on eBay.

Introduction to Peachtree Accounting 2009
Instructor: Diane Koers

Get the training you need to perform everyday accounting tasks using Peachtree Accounting software. First, you'll set up vendors, customers, and inventory items. Then you'll see how easy it is to record typical tasks such as goods purchased, bills paid, items sold, and payments collected. You'll also learn how to handle end-of-month procedures.

Intermediate Microsoft Excel 2007
Instructor: Chad Wambolt

Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. Learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques. Become adept at using Excel 2007 to gain further insight into your valuable data. Find out how to create macros that eliminate repetitive tasks, and set yourself apart from the casual Excel user by understanding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions. These practical, hands-on lessons are guaranteed to take your Excel skills to the next level!

Introduction to QuickBooks 2009
Instructor: Craig Power

In this QuickBooks class, you'll get the training you need to start using this accounting program to set up a chart of accounts, reconcile your checking account, create and print invoices, receipts, and statements, track your payables, inventory, and receivables, create estimates, and generate reports. You'll learn how to use QuickBooks 2009 to gain control over all financial aspects of your business!

Introduction to InDesign CS3
Instructor: Donna Baker

In this Adobe InDesign CS3 class, you'll get hands-on desktop publishing training and come away knowing how to use this popular page layout software to design and create professional quality letterhead, business cards, brochures, PDF files that play movies, and more. Whether you're a business owner, employee, student, softball coach, or service club member, you need to communicate with others. See the many ways in which Adobe InDesign CS3 can you help design slick, colorful, and useful content. We'll develop a wide range of publications for Natalie's Nautical Emporium, a fictional business. Starting with her logo design in Lesson 1, you'll see how to design multiple types of publications incorporating the same colors, look, and feel for a professional business presentation. By the end of the course, you'll know all about designing documents, as well as numerous ways to work smarter, not harder.

Intermediate Microsoft Access 2007
Instructor: Alan Simpson

Take your Microsoft Access 2007 skills to new heights! In this course, you'll learn the tools and techniques you need to create user-friendly Access 2007 databases. We'll work with multiple tables, one-to-many forms and reports, macros, and much more.

Intermediate Microsoft Word 2007
Instructor: Wallace Wang

Microsoft Word 2007 is a powerful and popular program, yet most people use only a fraction of its features. In this course, you'll learn Microsoft Word's more advanced features, which can make writing easier, faster, and more fun. You'll discover how to create an index, a list of figures, tables of contents, do desktop publishing, perform a mail merge, and use timesaving macros. By the end of the course, you'll know how to use Word both to save lots of time and to set your creativity free!

What's New In Microsoft Office 2007
Instructor: Barbara Clemens

The Microsoft Office 2007 programs--Word, Excel, PowerPoint, and Access--look a lot different than they did in 2003! For one thing, our familiar menus and toolbars have been replaced with the brand new Ribbon. But don’t worry--help is on the way. In this course, you'll learn how to get around the Office 2007 programs and how to use their exciting new features. You'll get comfortable working with Word documents, Excel spreadsheets, PowerPoint presentations, and Access databases. Before you know it, you'll be using each program with ease, accomplishing your work faster, and creating documents that look better than ever.

QuickBooks 2009 for Contractors
Instructor: Scott Paxton

Designed specifically for contractors, this course addresses the unique accounting needs of the construction industry. We'll focus on how to use the Premier Contractor Edition of QuickBooks 2009 to run your contracting business more efficiently. Clear lessons and step-by-step instructions in plain language will give you hands-on practice using the features that you're sure to use on a daily basis. You'll find out how to enter accounting entries, generate powerful reports, maximize efficiencies, and much more.

Photoshop Elements 7 for the Digital Photographer II
Instructor: Beverly Schulz

Adobe's Photoshop Elements 7 is full of outstanding features for advanced editing. Once you've learned the basics, you're ready to see how they all work together for detailed editing, building collages, restoring old photos, and more. This course is designed for those already familiar with cropping, printing, and color adjustments, as well the various selection tools. If you're ready to take your photo-editing skills to the next level, join us and see what more you can do with the advanced features of Elements.

Making Movies with Windows Vista
Instructor: Alan Simpson

If you have Windows Vista on your computer, you have what it takes to make your own digital movies. In this course, you'll learn how to use the Movie Maker program that's part of Vista to create your own movies and slide shows complete with special effects, custom background music, sound effects, and narration. You'll discover how to add your own titles and sound effects. And you'll find out how to share your movies through e-mail, YouTube, CDs, and DVDs.

Advanced Microsoft Excel 2007
Instructor: Chad Wambolt

Maximize your investment in Microsoft Excel 2007 by mastering advanced Excel features that most users don't even know exist. In this practical, hands-on course, you'll discover how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced techniques for PivotTables, like creating calculated fields and calculated items, as well as how to restore the "Classic PivotTable Style" drag-and-drop functionality. You'll see how to use validation to protect the integrity of your worksheets from other, less experienced users. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything MS Excel has to offer!

Introduction to Dreamweaver CS4
Instructor: Robert Fuller

Would you like to learn to use Adobe Dreamweaver CS4 to design, create, and maintain user-friendly Web sites that are full of professional-quality Web pages? Then this is the class for you! You won't need any prior Web design skills or knowledge of code. We'll start at the beginning, and through engaging lessons and hands-on exercises, we'll build a sample site from the ground up. Get ready to discover just how simple and fun Web design can be!

Intermediate Photoshop CS4
Instructor: Sherry London

Are you ready to take your Photoshop skills to the next level? Then join us and learn advanced techniques for using Adobe Photoshop CS4 to edit your images and photos. Imagine being able to undo or revise changes you've already made without losing image quality or needing to start over! If you've already mastered Photoshop's basic tools and commands, you'll find it easy to master the nondestructive editing techniques we'll cover. Once you see what nondestructive editing can do for you, you'll never look back!

Other Subject Areas:
Computers | Writing/Language | Business/Careers | Grants/Nonprofits | Personal | Professional