Courses > Computer Applications

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

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 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.

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.