Microsoft Office and Business Applications

ACCESS BASIC SKILLS

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.

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

$300        CEUs   3.2      HRS: 32

Jan 17 - Feb 14        8:30 am - 12:30 pm       CRN 70156     North Campus       TTh  

Jan 21 - Mar 11       8:30 am - 12:30 pm       CRN 70164      South Campus        Sat

May 1 - May 24       6:00 pm - 10:00 pm       CRN 90136     Central Campus      MW

 

EXCEL ADVANCED SKILLS

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.

Not scheduled at this time.

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.

$180        CEUs   1.6  HRS: 16

Mar 20 - Mar 29       6:00 pm - 10:00 pm       CRN 90134     Central Campus       MW

Mar 21 - Mar 30       6:00 pm - 10:00 pm       CRN 90131     South Campus        TTh

EXCEL INTERMEDIATE SKILLS

Excel Basic Skills or equivalent knowledge      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.

$180        CEUs   1.6  HRS: 16

Apr 17 - Apr 26      6:00 pm - 10:00 pm     CRN 90135       Central Campus        MW

May 8 - May 17       8:30 am - 12:30 pm     CRN 90126       North Campus          MW

MICROSOFT PROJECT-INTRODUCTORY SKILLS

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.

$245       CEUs 1.6     HRS: 16

Not scheduled at this time.

MOS ACCESS

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.

$440      CEUs 4.0    HRS: 40

Not scheduled at this time.

MOS EXCEL

Prerequisite: Windows for the desktop or equivalent knowledge and type 20 wpm    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.

$440     CEUs 4.0    HRS: 40

No Class Scheduled at this time.

MOS POWERPOINT

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.

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

$440     CEUs 4.0       HRS: 40

Not scheduled at this time

MOS WORD

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.

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

$180        CEUs   1.6  HRS: 16

Jan 17 - Jan 26        8:30 am - 12:30 pm      CRN 70170    Central Campus     TTh

Feb 21 - Mar 2        8:30 am - 12:30 pm      CRN 70159    North Campus        TTh

WORD INTERMEDIATE SKILLS

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.

$180        CEUs   1.6  HRS: 16

Not scheduled at this time.