home Future Students Current Students Faculty and Staff Business and Community Online Courses
 
Computer Application Workshops

“When we needed a training course in Microsoft Access we turned to MCC Business and Training Services. Throughout the preparation and delivery of the training the staff was professional, efficient and flexible. Our instructor was very good—she was able to adapt her delivery to a group of people with varying degrees of computer experience and took the time to answer all of our questions. We will definitely keep BTS in mind for our future training needs.”
- John LaMar, Overland Products Company

Business & Training Services is pleased to offer a variety Computer Application half-day and full-day Continuing Education workshops that are in high demand by area businesses. If you don’t see one that fits your needs, please give us a call—we’ll be glad to custom-build one just for you.

Access 2003, Level I
This workshop will introduce you to database terminology and the Access 2003 environment. You will learn the basic components of a database through hands-on activities. You will create and use tables, simple queries forms and reports and become familiar with the interrelationships between these components.

Access 2007, Level I
This course covers the basic functions and features of Microsoft Access 2007 software.  The student learns how to design and create databases; work with tables, fields, records; sort and filter data; create queries, forms, and reports.

Access 2007, Level II
This course builds on the skills and concepts taught in Access I.  The student learns how to normalize data; work with Lookup fields and sub datasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts.

Back to Menu

Computer Skills, Basic I
This course introduces the student to microcomputer fundamentals, terminology, keyboard functions, introduction to several selected applications as well as the Windows XP operating system.

Computer Skills, Basic II
This course goes a step further dealing with PowerPoint, Publisher and excel for the beginning student.

Email Formatting Using HTML
This full-day workshop shows you how to create and format email documents using HTML. Layout, typesetting, color selection and backgrounds will be presented.

Back to Menu

Excel 2003, Level I
Microsoft Excel is the world’s leading spreadsheet software. In this introductory hands-on workshop, you will learn how to create a spreadsheet, enter text and numbers in cells, add columns of numbers automatically, average numbers and find the largest and smallest number in a range.

Excel 2007, Level I
Learn the basics of Excel 2007, including opening, navigating, entering text and numbers, and closing workbooks or program.  Enter, edit, find, and replace information.  Work with formulas and basic functions to cut, copy and paste.  Format, print, and create charts.

Excel 2007, Level II
This course picks up where Excel Level I left off. New topics include linking worksheets and workbooks, using multiple worksheets, viewing and printing large worksheets.  Advanced formatting, managing lists and advanced charting is also covered.  The student learns how to protect worksheets, insert comments, and create templates.

Back to Menu

Microsoft Office 2007, Overview
Are you currently using 2003 and are ready to switch to 2007?  Come learn about this software update in this one session mini course.

Microsoft Office 2007
Learn the many time-saving features of the new Office 2007 user interface. Components presented include Navigation, Microsoft Word 2007, PowerPoint 2007, Outlook 2007 and Security. New features highlighted include Ribbon interface, command tabs, contextual tabs, the Office menu, galleries and the Live Preview.

Back to Menu

PowerPoint 2003
Enhance your meetings and presentations using Microsoft PowerPoint 2003.  You will learn to navigate through a presentation, create and edit bullet slides, use drawing tools, incorporate ClipArt and WordArt objects and prepare organizational charts.  More tricks and tips discussed in class.

PowerPoint 2007
Learn the basics of creating an attention grabbing presentation using PowerPoint 2007.  Learn to develop your presentation, use templates and work with wizards.  Enter, rearrange, enhance and delete text and graphics; add pictures and objects, adjust colors and backgrounds.  Take your show on the road with this beginning class on the leading presentation software.

Back to Menu

QuickBooks, Intro Level I
This course instructs the student in the basic operations of QuickBooks and the accounting principals behind the scenes.  The student creates a company accounting system from the ground up; builds lists to include all the information necessary to operate a company’s operations on a day-to-day basis.  These lists include the Chart of Accounts, list of Items & Services, Customer and Vendor Lists and an Employee list.  The student learns both the invoicing/receivables side of business; how to write checks, pay bills and learns to reconcile bank statements.  Reference manual is available for $20.

QuickBooks, Level II
This class picks up where level 1 leaves off.  We will learn more about Items & Services and setting them up; the Chart of Accounts including credit card, asset and liability accounts.  We'll learn how to write off bad debts and accept customer deposits on account; how to record “barter” or traded services where no cash traded hands; how to memorize repetitive transactions  and set up accounts when making new purchases (assets) with new loans (liabilities).  All things payroll will be taught. Reports available through QuickBooks will be included. We will learn to customize Iconbar and Forms (e.g., invoices, sales receipts, statements, etc.). Class tracking will be discussed along with Job Cost accounting and setting up budgets.  Finally, we'll learn about inventory, including functions and reports. Reference manual is available for $20.

Back to Menu

SQL Overview
This course is designed to give the student the skills needed to access and manipulate data in a relational database management system.  Topics covered:  Creating Tables, Inserting Data, Creating Constraints,
Selecting Information, Deleting and Updating Information, Scalar Functions, Aggregate Functions, Joining Tables, Subqueries, and Views

Word 2007, Level I
The student is introduced to the basic functions and features of Word 2007. The student learns how to enter and edit text, and save and browse documents. Enhancing the appearance of a document by using various formatting options is also covered. The student also creates tables, inserts headers and footers, proofs and prints documents, and inserts graphics.

Word 2007, Level II
This course builds on the skills and concepts taught in Microsoft Word 2007 Level I. The student works with styles, sections, and columns. Formatting tables, printing labels and envelopes, and working with graphics are covered.  The student uses document templates, manages document revisions, and works with Web features.

Back to Menu


How to Register

To Register contact BTS to schedule the workshop of your choice. Minimum class size is five (5) registrants.

Email: sdickson@mccneb.edu
Phone: 402-457-2592

Please be ready to provide the following information upon registration:

  • Workshop title
  • Registrant(s) full name(s)
  • Business name (if applicable)
  • Business /individual mailing, email and billing addresses
  • Business/individual phone number
  • Birth date of registrant(s)

Cancellation and Rescheduling:
MCC Business & Training Services reserves the right to cancel and/or reschedule a workshop. In this instance, the registrant will be notified in advance by email, and the registrant has the option of attending a rescheduled workshop or cancelling their registration.


Pricing

Continuing Education workshops are priced per person. The registering organization or individual will be invoiced upon Workshop completion. Payment is due 30 days from invoice date.

Continuing Education Half-Day Workshop - $99 / person
Continuing Education Full-Day - $149 / person

Multi-Session

  • Community Spanish: A Survival Guide for English Speakers - $149 / person
  • Command Spanish for Nursing - $159 / person
  • English for Spanish Speakers - $159 / person
  • Command Spanish for School Teachers and Parents - $169 / person



Back to Top
 
 
 
Contact Us