Microsoft Applications & QuickBooks

Microsoft Office

Course Information Cr Hrs
Windows 8

Learn about the basic functions and features of Windows 8.

Course Dates Times Location Cost
WDC 298 Mar 30; M 8:30-3:30pm GRF 125 $99

Register Online

Windows File Management

Learn how to set up files, rename, copy, move and delete files.

Course Dates Times Location Cost
WDC 437 Mar 31; T 8:30-12:30pm GRF 123 $69

 

Register Online

Introduction to Windows 8

Welcome to the world of Microsoft Windows 8!  It's a robust, powerful operating system that gives you an efficient way to manage all the apps, programs, files, and folders you use regularly. In this course, you'll learn the basics so you can make the most of this operating system for both work and fun.

Classes begin monthly! Go to Ed2Go for more information!

Introduction to Windows 7

If you're new to computers, or just new to Microsoft Windows 7, this course will get you up to speed fast. In just six weeks, you'll make the transition from helpless beginner to happy PC user.

 

Classes begin monthly! Go to Ed2Go for more information!
What's New in Microsoft Office 2010

Get up to speed on the latest version of Microsoft Office 2010! In these lessons, you'll explore all the new features of Office as you work with Word documents, Excel spreadsheets, PowerPoint presentations, and Access databases.

Classes begin monthly! Go to Ed2Go for more information!

What's New in MS Office 2007

Get comfortable creating Word documents, Excel spreadsheets, PowerPoint presentations, and an Access database. This is an online class.

Classes begin monthly! Go to Ed2Go for more information!

 

Applications Courses

We offer several classes that make it easy for you to learn everything you need to know about many popular applications.

Microsoft Excel

Course Information Cr Hrs
Excel 2010 - Level 1

Work with Excel Basics.  Gain a solid understanding of Excel.  Learn how to navigate around a worksheet.  Enter and edit various types of data.  Use formatting, copy and paste, proofing and editing as well as save and print your document.

Course Dates Times Location Price
WDC 745 Apr 06; M 8:30-3:30pm GRF 123 $99

Register online

Excel 2010 - Level 2

Create and use multiple sheets in workbooks.  Learn grouping and linking sheets. Work with Headers and Footers.  Create, edit and format charts.

Course Dates Times Location Price
WDC 746 Apr 13; M 8:30-3:30pm GRF 123 $99

Register online

Excel 2010 - Level 3

Use more Advanced Formulas.  Learn how to create PivotTables and Macros.  Create Drop-Down Lists for data entry.  Create custom Templates as well as use predesigned Templates.  Use Excel with other Office Applications.  Customize Toolbars and Ribbons.

Course Dates Times Location Price
WDC 747 Apr 20; M 8:30-3:30pm GRF 123 $99

Register online

Excel 2010 Tips and Tricks

Course Dates Times Location Price
WDC 752 Dec 4; Th 1-4pm GRF 123 $59

 

Register Online

Introduction to Microsoft Excel 2010

These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. 

Classes begin the middle of every month! Go to Ed2Go for more information.

 

Intermediate Microsoft Excel 2010

In these hands-on lessons, you'll learn how to create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Classes begin every month! Go to Ed2Go for more information!

Advanced Microsoft Excel 2010

You'll see how to work with the additional analytical tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. Become adept at consolidating and importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. 

Classes begin every month! Go to Ed2Go for more information!

Microsoft 2010 in the Classroom

First, you'll cover the Excel fundamentals that making student grading and data collection a snap: Using tabs, formatting cells and worksheets, and inserting formulas for mathematical calculations. In addition, you’ll learn how to create colorful charts and graphs to enhance reports and projects. 

Then you’ll move on to more advanced Excel features that allow you to easily sort and analyze student test data for differentiated instruction or even manage school fund-raisers. You’ll write powerful mathematical formulas and use Excel to automatically calculate student averages and other statistics. You'll finish the course by creating a customizable grade book that you can use in your own classroom to group students for differentiated instruction, reading groups, team sports, or special education programs.

By the end of the course, you'll have a solid understanding of this powerful Microsoft Office program. You’ll also have a whole new set of time-saving classroom management tools, and a wealth of ideas for integrating technology into your lesson plans across your curriculum.

Classes begin the middle of every month! Go to Ed2Go for more information!

Microsoft Word

Course Information Cr Hrs
Word 2010 - Level 1

Work with Word Basics.  Learn how to start Word, use the Interface, Navigate through documents, enter and edit text, formatting, copy and paste, use the proofing and editing tools as well as save and print your document.  Create a simple report.

Course Dates Times Location Price
WDC 742 Jan 12; M 8:30-3:30pm GRF 123 $99
 

Register Online

Word 2010 - Level 2

Use graphic tools. You will work with WordArt, ClipArt, SmartArt, and picture styles.  Use Word’s galleries to format graphic images.  Work with Templates.  Learn Mail Merge.

Course Dates Times Location Price
WDC 743 Jan 26; M 8:30-3:30pm GRF 123 $99

Register online

Word 2010 - Level 3

Create and edit Tables. Use Headers and Footers.  Work with Table of Contents, Index, and cross-references.  Insert Comments.  Personalize Word using Word Options, Customize Toolbars and Ribbons.  Use Word with other Office Applications.

Course Dates Times Location Price
WDC 744 Feb 02; M 8:30-3:30pm GRF 123 $99

Register online

Introduction to Microsoft Word 2007

Learn to use the word processor PC Magazine ranked as one of the 'strongest and most intelligent programs ever written.' In this hands-on workshop, you'll learn how to add, move through, and edit text, move words from one part of your document to another, work on two or more documents simultaneously, change the size or appearance of text, change margins and tab settings, automatically center, right align, justify, and indent text; run the integrated grammar and spelling checker; use the thesaurus, and save, retrieve, copy, organize, and print your documents.

This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!

 

Intermediate Microsoft Word 2007

In the first part of the course, you'll see how to perform a mail merge, and we'll explore macros, styles, and templates. Macros let you type repetitive words and phrases quickly and accurately at the touch of a button. Styles let you save text formatting. Templates let you create documents that contain predefined formatting and text, making it a snap to create documents that look right every time.

This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!

 

Microsoft Word 2007 in the Classroom

Mastering Microsoft Word can make you a more productive and creative teacher. You'll learn how to create, open, edit, and save documents, as well as how to create tabs, margins, and spacing. Then you'll make your classroom documents come to life. You'll add borders, clip art, and WordArt. You'll even insert shapes, pictures, tables, and complete a host of other exciting tasks that you can teach your students. As you get more familiar with this program, you'll find that it enhances your teaching in ways you didn't think possible, and you'll have a host of ideas for curriculum-related classroom projects.

This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!

 

Introduction to Microsoft Word 2010Master the basics of the word processor PC Magazine ranked as one of the “strongest and most intelligent programs ever written.” In this hands-on workshop, you’ll learn how to add, move through, and edit text; move words from one part of your document to another; work on two or more documents simultaneously; change the size or appearance of text; change margins and tab settings; automatically center, right align, justify, and indent text; run the integrated grammar and spelling checker; use the thesaurus; and save, retrieve, copy, organize, and print your documents. By the time you’re done with the step-by-step lessons and hands-on activities in this course, you’ll be able to use Word confidently at home or on the job

 

This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!

Intermediate Microsoft Word 2010

You'll learn how to perform a mail merge, and we'll explore shortcuts, styles, and templates. Shortcut keys and macros let you type repetitive words and phrases quickly and accurately at the touch of a button. Styles let you save text formatting. Templates let you create documents that contain predefined formatting and text, making it a snap to create documents that look right every time.

This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!

 

Microsoft Word 2010 in the Classroom

Master Microsoft Word, and be a more productive and creative teacher! This powerful software can make your documents come to life and help you integrate technology in your classroom. 

You'll start by learning how to create, open, edit, and save your documents. Next, you'll become skilled at using formatting tools including tabs, margins, and spacing. In addition, you'll find out how to add borders, clip art, WordArt, shapes, pictures, and tables. You'll even learn how to make your own student-of-the-week certificates!

 

This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!

Microsoft Access

Course Information Cr Hrs
Introduction to Microsoft Access 2007

Learn how Microsoft's powerful and award-winning database can help you manage, store, search, analyze, and display important information you've collected about your business, home, community, or any other entity. In this practical and project oriented hands-on workshop, you'll learn how to create tables filled with fields and records. You'll build relationships between the tables to eliminate redundancies and slash data entry time. You'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. You'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros.

Classes begin monthly! Go to Ed2Go for more information!

Intermediate Microsoft Access 2007

In this course, you'll master the tools and techniques required to create user-friendly Access 2007 databases. You'll learn to design one-to-many and many-to-many databases and create queries, forms, and reports to reflect those relationships. You'll find out how to create a switchboard form, change database settings, and use macros to make a database easy and intuitive enough for even a computer novice to use.

Classes begin the middle of every month! Go to Ed2Go for more information!

Introduction to Microsoft Access 2010

In these practical and project-oriented lessons, you'll learn how to use this award-winning MS Office software to create and customize tables. You'll build relationships between your tables to eliminate redundancies and slash data entry time. And you'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. 

In addition, you'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros.

By the time you've finished this course, you'll know how to create an effective database for any information you need to store, document, and manage—at home or on the job.

Classes begin every month! Go to Ed2Go  for more information!

Intermediate Microsoft Access 2010

You'll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you'll add and update key fields that allow you to build relationships among the tables. Then you'll master the steps for building complex yet easy-to-use forms to manage table data. 

The course offers you tips and techniques for optimizing your database, including ways to build crosstab and summary queries so you can access information quickly and easily. You'll also learn about outer table joins that can make you queries more effective.

Once you've built your database, you'll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you'll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.

Classes begin the middle of every month! Go to Ed2Go for more information!

 

PowerPoint

Course Information Cr Hrs
Powerpoint 2010

Course Dates Times Location Price
WDC 750 Oct 27; M 8:30-3:30pm Graff 123 $99

 

Register Online

Intro to PowerPoint 2010

Create dazzling slide presentations with slides that contain text, objects, animation, slide transitions, sounds, charts, outlines, media clips, clip art, and hyperlinks. You'll learn how to work with the new PowerPoint ribbon, task panes, the clip organizer, and how to access Microsoft's website to download clip art and templates for your presentations. This is an online class.

Classes begin every month! Go to Ed2Go for more information!

 

Microsoft PowerPoint 2010 in the Classroom

First, you'll cover the basics of this MS Office program including creating slides, using templates, inserting text, changing background colors, creating WordArt titles, using SmartArt graphics, and adding slide transitions. Then you'll develop advanced skills such as inserting graphics, sound, video, custom animations, timed transitions, and hyperlinks.

You'll get step-by-step instructions for creating several different types of classroom presentations, including lectures and interactive narrations for your students' independent use at computer stations. You'll also see how PowerPoint helps you address different learning styles, making it much easier to reach every student. And you'll discover how to upload your presentation to a Web server, email a slide show, broadcast a presentation in real time, and take your PowerPoint shows on the road. 

By the time you're done, you'll be an expert at using PowerPoint to add appeal to any lesson—and you'll even find out how you can help your students develop their own PowerPoint skills!

Classes begin monthly! Go to Ed2Go for more information!

 

Publisher

Course Information Cr Hrs
Publisher 2010

Course Dates Times Location Price
WDC 751 Dec 08; M 8:30-3:30pm Graff 123 $99

 

Register Online

QuickBooks

Course Information Cr Hrs
QuickBooks - Level 1

This is a seated class. Get the basics of QuickBooks and review the software tools to help manage your business. Learn how to set up your files with some hands-on practice.

Course Dates Times Location Cost
WDC 325 Apr 29; M 8:30-3:30pm Graff 123 $129

Register online

QuickBooks - Level 2

This is a seated class. Learn about working with QuickBooks accounts, reconciliations, credit card transactions, accounts receivable, accounts payable and basic reports. Prerequisite: Previous QuickBooks experience or Level 1 class.

Summer Dates will be posted Spring of 2015.

Register online

QuickBooks - Level 3

This is a seated class. Learn about inventory, sales tax, payroll and payroll taxes. Prerequisite: Previous QuickBooks experience or Level 2 class.

Summer Dates will be posted Spring of 2015.

 

Register Online

QuickBooks - Level 4

This is a seated class. Learn about analyzing financial data, time tracking, progress invoicing, customizing forms, fixed assets, depreciation, loan managers and budgets. Prerequisite: Previous QuickBooks experience or Level 3 class.

Course Dates Times Location Cost
WDC 483 Nov 24; M 8:30-3:30pm Graff 123 $129

 

Register Online

Introduction to QuickBooks 2011

This is an online class. In these lessons, you’ll learn how to set up a chart of accounts, pay bills, invoice customers, create receipts, and reconcile your checking account. In addition, you’ll discover how to track your accounts payable and receivable, manage your assets, control inventory, and generate estimates and reports.

Classes begin every month! Go to Ed2Go for more information!

 

 

Performing Payroll in QuickBooks 2011

This is an online class. In this course, you’ll master all the steps for setting up your payroll system. You’ll learn how to access IRS information, create entries for new employees, and enter employee time and job cost data. And what about all those required forms and reports, from W-2s to Federal forms 940 and 941? No problem—they’re a cinch when you have the power of QuickBooks on your side. 

Classes being every month! Go to Ed2Go for more information!

 

Introduction to QuickBooks 2012

This is an online class. In these lessons, you'll learn how to set up a chart of accounts, pay bills, invoice customers, create receipts, and reconcile your checking account. In addition, you'll discover how to track your accounts payable and receivable, manage your assets, control inventory, and generate estimates and reports.

QuickBooks is designed for small to midsized businesses that want to incorporate powerful, effective software with a traditional approach to accounting. Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will equip you to quickly and efficiently gain control over the financial aspects of your business.

Each class is 6 weeks long. This is an online class.

Classes begin every month! Go to Ed2Go for more information!

 

Intermediate QuickBooks 2012

This is an online class. You'll learn how to manage multiple company files and how to export and import list data from one file to the next. You'll also learn how to enter price levels and track discounts and credits. If your business handles inventory, you'll learn to enter units you've purchased and track them all the way through to sale. You'll even learn how to enter and track mileage for any vehicles that you use in your business.

Classes begin every month! Go to Ed2Go for more information!

 

Performing Payroll in QuickBooks 2012

This is an online class. In this course, you'll master all the steps for setting up your payroll system. You'll learn how to access IRS information, create entries for new employees, and enter employee time and job cost data. And what about all those required forms and reports, from W-2s to Federal forms 940 and 941? No problem—they're a cinch when you have the power of QuickBooks on your side. 

Classes begin every month! Go to Ed2Go for more information!

 

QuickBooks 2012 for Contractors

This is an online class. In this six-week course, you'll learn how to use the Premier Contractor Edition of QuickBooks 2012 to run your business more efficiently. Lessons are clearly illustrated and include step-by-step instructions written so you can get hands-on practice with the features you're sure to use every day. You'll discover how to create custom and professional-looking contract estimates, track time and materials, and properly set up accounts, customers, and jobs. You'll also learn the different methods for billing your clients, including the QuickBooks progress invoicing and job-costing features.

Classes begin the middle of every month! Go to Ed2Go for more information!

 

Introduction to QuickBooks 2013

This is an online class. In 12 lessons, you'll master the tools you'll need 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.

Classes begin the middle of every month! Go to Ed2Go for more information!

 

Intermediate QuickBooks 2013

This is an online class. You'll learn how to manage multiple company files and how to export and import list data from one file to the next.  If your business handles inventory, you'll learn how to enter price levels and track discounts and credits.  You'll even learn how to enter and track mileage that you incur on any vehicles that you use in your business.

Classes begin the middle of every month! Go to Ed2Go for more information!

 

Performing Payroll in QuickBooks 2013

This is an online class. You'll start by learning how to prepare for the payroll process by finding the information you need on the Internal Revenue Service website, from the details of complying with withholding requirements for taxes to the process for applying for an employer identification number.

Then you'll review all aspects of how to set up and maintain payroll information for your employees in Quickbooks. You'll learn how to track work and vacation time; produce job costing reports; generate W-2, W-3, and 1099 forms; create paychecks; and much more. And once you've mastered the basics, you'll gain troubleshooting tips and solutions to help you solve common problems and mistakes to simplify the whole payroll process. By the end of the course, you'll be ready to process payroll in QuickBooks and solve many of the problems that can pop up along the way.

Classes begin every month! Go to Ed2Go for more information!

 

QuickBooks 2013 for Contractors

This is an online class. In this six-week course, you'll learn how to use the Premier Contractor Edition of QuickBooks 2013 to run your business more efficiently. Lessons are clearly illustrated and include step-by-step instructions to give you hands-on practice with the features you're sure to use every day. You'll discover how to create custom, professional-looking contract estimates and perform time tracking, and you'll learn the different methods you can use to bill your clients, including how to use the QuickBooks progress invoicing and job-costing features.

You'll find out how to deal with tricky situations, like change orders and retainage requirements, and you'll learn how to properly set up accounts, items, customers, and jobs. All along the way, you'll discover how to avoid many of the big and often costly mistakes contractors commonly make with QuickBooks. Finally, you'll learn how specific transactions impact all your various accounts, and even gain some techniques to protect your business from fraud, prepare for tax time, and generate useful and dynamic reports.

Classes begin every month! Go to Ed2Go for more information!