Microsoft Applications & QuickBooks
Microsoft Office
| Course Information | Cr Hrs | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Windows 8 Learn about the basic functions and features of Windows 8.
|
|||||||||||||
| 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. This is an online class. Classes begin monthly; go to www.ed2go.com/otc 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. This is an online class. Classes begin monthly; go to www.ed2go.com/otc 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. This is an online class. Classes begin monthly; go to www.ed2go.com/otc 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc 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 Word
| Course Information | Cr Hrs | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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!
|
||||||||||||||||
| Word 2010 - Level 1
|
||||||||||||||||
| Word 2010 - Level 2
|
||||||||||||||||
| Word 2010 - Level 3
|
||||||||||||||||
| 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 Excel
| Course Information | Cr Hrs | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Excel 2007 - Level 1 User interface, values and formulas, edit and format a worksheet and chart creation.
|
||||||||||||||||
| Excel 2007 - Level 2 Create and edit charts, manage workbooks, work with page layout and printing.
|
||||||||||||||||
| Excel 2007 - Level 3 Learn more about Macros, integrating with programs, and complex analysis using PivotTables, database functions, lookup functions, and workbook security.
|
||||||||||||||||
| Excel Tips & Tricks Learn great techniques to improve your use of Excel 2007.
|
||||||||||||||||
| Microsoft Excel 2007 in the Classroom First, we'll cover all the important Excel fundamentals: Using tabs, formatting cells and worksheets, inserting formulas for addition, subtraction, multiplication, and division, and creating colorful charts and graphs. Then we'll move on to more advanced Excel features such as sorting and analyzing student test data for differentiated instruction, writing powerful mathematical formulas, and using 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Excel 2010 - Level 1
|
||||||||||||||||
| Excel 2010 - Level 2
|
||||||||||||||||
| Excel 2010 - Level 3
|
||||||||||||||||
| 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information! |
PowerPoint
| Course Information | Cr Hrs | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PowerPoint 2007 - Level 1Create presentations using templates, themes, and learn to apply slide layouts, charts, tables, pictures and animation. Also covers how to use text, graphics, and sound creatively.
|
|||||||||||
| Intro to PowerPoint 2007 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 the middle of every month; go to www.ed2go.com/otc for more information! |
|||||||||||
| Microsoft PowerPoint 2007 in the Classroom First, we'll cover the basics of this MS Office program including creating slides, using templates, inserting text, changing background colors, creating WordArt titles, and adding slide transitions. Then you'll develop advanced skills such as inserting graphics, sound, video, custom animations, timed transitions, and hyperlinks. We'll walk step-by-step through several different types of classroom presentations, including lectures and interactive narrations for your students' independent use on computer stations. By the end of the course, you'll be able to publish your presentation on a school Web site or even take your PowerPoint shows on the road. Along the way, we'll talk about how you can help your students develop their own PowerPoint and presentation skills. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
|||||||||||
| 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 the middle of every month; go to www.ed2go.com/otc 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 the middle of every month; go to www.ed2go.com/otc for more information!
|
QuickBooks
| Course Information | Cr Hrs | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| QuickBooks 2010 - Level 1 Get the basics of QuickBooks Pro and review the software tools to help manage your business. Learn how to set up your files with some hands-on practice.
|
||||||||||||||||
| QuickBooks 2010 - Level 2 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.
|
||||||||||||||||
| QuickBooks 2010 - Level 3 Learn about inventory, sales tax, payroll and payroll taxes. Prerequisite: Previous QuickBooks experience or Level 2 class.
|
||||||||||||||||
| QuickBooks 2010 - Level 4 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.
|
||||||||||||||||
| Introduction to QuickBooks 2011 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Performing Payroll in QuickBooks 2011 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Introduction to QuickBooks 2012 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Intermediate QuickBooks 2012 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Performing Payroll in QuickBooks 2012 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| QuickBooks 2012 for Contractors 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Introduction to QuickBooks 2013 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Intermediate QuickBooks 2013 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| Performing Payroll in QuickBooks 2013 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|
||||||||||||||||
| QuickBooks 2013 for Contractors 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. This is an online class. Classes begin the middle of every month; go to www.ed2go.com/otc for more information!
|