Microsoft Office and Business Applications

ACCESS BASIC SKILLS

Prerequisite: Windows for the Desktop or Equivalent Knowlege     Textbook required, flash drive recommended

In this course, you will work with Access, a powerful database application to store and retrieve data. You will begin with learning basic database terminology. You will learn the objects used in Access, how to construct tables, use forms to display data, create queries to select data and to format reports for data that is retrieved from the database. You will use the wizards to create tables, primary keys, date formats, adn youwill be able to link tables to create queries. Begin to acquire skills and knowledge to pass the optional MOS exam in Access.

         CEUs 2.4       HRS: 24

No classes scheduled for spring.

 

BASIC BUSINESS APPLICATIONS

Prerequisite: Windows for the Desktop or Equivalent Knowlege     Textbook required, flash drive recommended

Learn the commonalities of the Microsoft Office Program and practice using the basic features of Windows Microsoft Word, Excel, and PowerPoint programs.

$375       CEUs   3.2      HRS: 32

Sept 26 - Oct 18       8:30 am - 12:30 pm       CRN 50511     North Campus        TTh  

Sept 9 - Oct 28         8:30 am - 12:30 pm       CRN 50523     South Campus        Sat

Nov 27 - Dec 20       6:00 pm - 10:00 pm       CRN 70035     Central Campus      MW

 

EXCEL ADVANCED SKILLS

Prerequisite: Excel Intermediate or equivilant knowledge; Windows for the Desktop and type 20 wpm     Textbook required, flash drive recommended

As a student in this course, you will learn the most important topics of Microsoft Excel 2013. You will first discuss how to analyze data with PivotTables and how to create a PivotChart report. You will then have an introductory unit on exchanging data with other programs like Word, PowerPoint and Access. From there you’ll move into the different aspects of the application such as sharing Excel files and incorporating web information. You will then go over how to customize excel and advanced worksheet management. You will learn to audit a worksheet, create cell comments, custom autofill lists and create and apply templates. You will wrap up the course with how to program with Excel. You will be introduced to the Visual Basic editor, analyze and write code, create a main procedure then run it.

$230         CEUs 1.6     Hrs - 16

Oct 09 - Oct 18       6:00 pm - 10:00 pm       CRN 50534     Central Campus       MW

 

EXCEL BASIC SKILLS

Prerequisite: Windows for the Desktop or Equivalent Knowlege     Textbook required, flash drive recommended

In this course, you will work with Excel 2013, a powerful spreadsheet application. You will begin with preparing and formatting techniques. You will learn how to insert texts and formulas into cells. You will use simple functions.  You will construct charts for your data. You will learn formatting and printing of selected ranges. You will learn about workbooks and moving data between workbooks.

$230       CEUs   1.6  HRS: 16

Sept 11- Sept 20      6:00 pm - 10:00 pm       CRN 50532      Central Campus     MW

Sept 05 - Sept 14     8:30 am - 12:30 pm       CRN 50509     North Campus        TTh

Dec 04 - Dec 13       6:00 pm - 10:00 pm       CRN 70033      South Campus       MW

 

EXCEL COMPLETE

Prerequisite: Windows for the desktop or equivilant knowledge and type 20 wpm.

Note: Textbook Required.

This course provides the concepts and skills to be productive with Microsoft Excel starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Excel. You will benefit most from this course if you want to use Excel to perform real-world tasks, from common workplace tasks to complex operations with large amounts of data. The course assumes students know how to use a computer and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.

$510      CEUs4.8      HRS: 48

Sept 11 - Oct 18     6:00 pm - 10:00 pm     CRN 50535     South Campus    MW

 

EXCEL INTERMEDIATE SKILLS

Prerequisite: Excel Basic Skills or equivalent knowledge   Note: Textbook required, flash drive recommended

As a student in this course, you will learn the most important topics of Microsoft Excel 2013. First you will go over how to manage workbook data and data using tables. Next you will move onto how to analyze table data. Then you will read about automating worksheet tasks. You will wrap up the course with how to enhance charts and use What-If analysis. You will gain skills to freeze columns and rows, sort data in tables using conditional formatting, to use the DGET,HLOOKUP and MATCH functions; create, run and edit macros; and to use the Goal Seek feature to perform a what-if-analysis.

$230       CEUs   1.6  HRS: 16

Sept 25- Oct 04      6:00 pm - 10:00 pm     CRN 50533       Central Campus        MW

 

MICROSOFT PROJECT-INTRODUCTORY SKILLS

Prerequisite: Windows for the Desktop or Equivalent Knowlege     Textbook required, flash drive recommended

Learn the introductory topics needed to effectively use Microsoft Project software in home or business situations.   You will learn to create a new project plan, manage project tasks and resources. Finally you will learn to finalize a plan and set it as a baseline.

       CEUs 1.6     HRS: 16

Not scheduled at this time.

 

MOS ACCESS

Prerequisite: Basic computer skills and type 20 wpm    Note: Textbook required, flash drive recommended

MOS Access teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional databases for a variety of purposes and situations. You will learn to create and modify database tables. You will learn to create and modify forms, queries and reports.

      CEUs 4.0    HRS: 40

Not scheduled at this time.

 

MOS EXCEL

Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm    Note: Textbook required, Flash drive recommended

MOS Excel teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations.  You will learn to construct cell data, format worksheets, work with charts and graphics.  This course teaches the skills you will need to successfully complete the MOS Excel Certification Core Exam.

$490     CEUs 4.0    HRS: 40

Oct 09 - Nov 24     6:00 pm - 10:00 pm     CRN 50522      South Campus        MTWTh

 

MOS POWERPOINT

Prerequisite: Basic computer skills and type 20 wpm    Note: Textbook required, flash drive recommended

MOS PowerPoint teaches the information worker how to create and manage presentations using a variety of core and advanced features.  You will use PowerPoint to create and edit professional-looking presentations for a variety of purposes and situations, as well as explore different ways to share the information with internal and external customers.  You will learn to work with text, illustrations, media, charts, and tables.  In this course you will have reviewed all of the exam objectives necessary to prepare for the Microsoft PowerPoint Core Exam.

      CEUs 2.4      HRS: 24

Not scheduled at this time

 

MOS PROJECT

Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm    Textbook required, Flash drive recommended

MOS Project class uses the Microsoft Official Academic Course (MOAC) textbook. This course is designed to re-enforce workforce skills. In this course students learn to manage project resources, task assignments and scheduling.  They will also learn about the intergration and tracking of muliple projects and programs. Skills mastery of Microsoft Project can help students with classwork and differentiate job hunters in today's competitive job market.

$490     CEUs 4.0       HRS: 40

Oct 17  - Nov 16      6:00 pm - 10:00 pm   CRN 50540    Central Campus   TTh

 

MOS WORD

Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm    Textbook required, Flash drive recommended

MOS word teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and format business documents such as letters, forms, newsletters, memos and proposals.  As you begin to build your skills, you will then create a variety of flyers and other promotional materials as well as explore different ways to share the information with internal and external customers.  These are skills needed to successfully complete the MOS Word Certification Core Exam.

      CEUs 4.0     HRS: 40

Not scheduled at this time

 

WORD BASIC SKILLS

Prerequisite: Windows for the Desktop or Equivalent Knowlege     Textbook required, flash drive recommended

In this course, you will work with Word 2010, a powerful application to create and format documents. You will begin with preparing and editing techniques. You will learn how to format, save and print a document. You will be using fonts, keyboard shortcuts, manipulating tabs, cut, copy, and paste text. You will learn page setup - margins, page orientation, inserting page numbers, page breaks, headers, footers, date, time, symbols and other images. You will learn to create tables, populating and formatting them. You must be able to type.  Begin to acquire skills and knowledge needed to pass the optional MOS Core certification exam in Word.

$230       CEUs   1.6  HRS: 16

Oct 24 - Nov 02      8:30 am - 12:30 pm      CRN 50514    North Campus      TTh

 

WORD INTERMEDIATE SKILLS

Prerequisite: Word Basic Skills or equivalent knowledge and type 20 wpm    Textbook required, Flash drive recommended

First, you will go over how to illustrate documents with graphics. You will learn to insert, position, size and scale a graphic. You will learn to create a text box, WordArt and draw shapes.  Next, you will move onto working with themes and building blocks where you will learn to insert a sidebar and Quick Parts. Then you will learn about merging Word documents and developing multipage documents. You will understand mail merge as you create a main document, design a data source, enter, and edit records.  You will add merge fields, merge data and create labels. You will wrap up the course with how to work with styles, documents, and references.

$230      CEUs   1.6  HRS: 16

Not scheduled at this time.