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.

$355       CEUs   3.2      HRS: 32

Jan 13 - Mar 3          8:30 am - 12:30 pm       CRN 70292     South Campus        Sat 

Feb 13 - Mar 8         8:30 am - 12:30 pm       CRN 70288     North Campus        TTh

Apr 02 - Apr 25       8:30 am - 12:30 pm       CRN 90324     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. You will first discuss how to analyze data with PivotTables adn 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 will 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 Visual Basic editor, analyze and write code, create a main procedure to then run it.

$230         CEUs 1.6     Hrs - 16

Feb 19 - Feb 28      6:00 pm - 10:00 pm       CRN 70300     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, 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 learn how to insert texts and formulas into cells. You will learn to use simple functions. You will learn the formatting and printing of selected ranges. You will learn to edit workbook properties. You will construct charts for your data. Finally you will learn to create Trendlines and Sparklines on your charts.

$230       CEUs   1.6  HRS: 16

Jan 9 - Jan 18           8:30 am - 12:30 pm        CRN 70284      North Campus       TTh

Jan 22 - Jan 31         6:00 pm - 10:00 pm        CRN 70298     Central Campus      MW

Mar 19 - Mar 28       6:00 pm - 10:00 pm        CRN 90321     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

Jan 22 - Feb 28     6:00 pm - 10:00 pm     CRN 70301     Central 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 to customize your cell contents, work with conditional formatting and name cells and ranges. You will learn to manage multiple-sheet workbooks. You will apply apply advanced functions to create formulas using criteria IF funtions, and the logical functions IF, AND, OR, and NOT. You will then learn to used advanced functions to format text, to create financial solutions and to analyze data. You will increase your skills with tables, structured references, and enhanced sorting and filtering.  Finally, you will learn to use graphics, SmartArt and WordArt to create and modify your own Excel templates.

$230       CEUs   1.6  HRS: 16

Feb 5 - Feb 14      6:00 pm - 10:00 pm     CRN 70299       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.

$480     CEUs 4.0    HRS: 40

Jan 22 - Feb 21    6:00 pm - 10:00 pm     CRN 70291      South Campus        MW

 

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

Not scheduled at this tme.

 

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, 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

Mar 20 - Mar 29      8:30 am - 12:30 pm      CRN 90312    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.