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

 

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.

CEUs   3.2      HRS: 32

 

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.

CEUs 1.6     Hrs - 16

 

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.

CEUs   1.6  HRS: 16

 

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.

CEUs4.8      HRS: 48

 

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.

CEUs   1.6  HRS: 16

 

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.

 

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

 

MOS EXCEL 1

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.

CEUs 4.0    HRS: 40

 

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

 

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.

CEUs 4.0       HRS: 40

 

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

 

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.

CEUs   1.6  HRS: 16

 

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.

CEUs   1.6  HRS: 16

Not scheduled at this time.