Microsoft Office Specialist (MOS) course prepares individuals to support businesses information operations by using computer equipment to enter process and retrieve data for a wide variety of administrative purposes. This course helps to demonstrate that you have the skills needed to get the most our of MS Office as it includes instruction in using basic business software and hardware; business computer networking; principles of desktop publishing; preparing mass mailing; compiling and editing spreadsheets; list maintenance; preparing table and graphs; receipt control; and preparing business performance report. This program is an ideal way to prepare for your Microsoft Office Specialist Certification.


Program Objective:

Develop a practical Knowledge on MS Word, MS Excel, MS Access, MS PowerPoint, MS Outlook. Acquire the Knowledge and skills you need to pass the Microsoft Office Specialist certification exam.


Prerequisites:

High School Diploma; GED.


The Course description:

Fundamentals of Computer Application

  • 1.Keyboarding :
  • Description of Keyboard Components / Fonts
  • Justification, Borders
  • Rules and Typing Tidbits / Row Keys: Home,
  • Top & Bottom / Punctuations Marks;
  • Numbers and Symbols
  • Numeric Keypad
  • E-Mail and Word Processing / Reports / Office Correspondence
  • Employment Documents
  • Skill Building and Skills Assessment
  • 2.Basic Computer Skills & Word Processing (MS Word):
  • Major Parts of the Computer System / Windows Desktop,
  • On Screen icons
  • Windows
  • Dialog Boxes/ How Trouble Shoot Common Windows Problems /
  • Working with Documents: Creating and Editing Documents /Saving and Opening Files
  • Using Proofreading and Research Tools/
  • Document Features: Font, Borders, Graphics, Clip /Word-Art and Colors
  • Paragraph Formatting: Headers, Footers
  • Page numbers and Margins
  • Creating Numbered and Bulleted Lists
  • Columns and sing Word Tables
  • Creating Business Letters and Other Business Form
  • Using Templates and Wizards
  • Personalized Mass Mailings
  • Creating Webpages and Printing Documents

Office Management Skills :

  • 1. Fiscal Record Management (MS Excel):
  • Creating a New Workbook
  • Putting In Data in a Worksheet
  • Basic Computations & Computations with Functions
  • Working on Formulas & Understanding Cell References
  • Different Ways to Systematize Worksheet: Moving, Viewing & Editing
  • Changing Text and Numbers Appearance
  • Putting In Cells and Borders, and Working with Ranges
  • Creating and Eliminating Cells, Rows and Columns
  • Managing the Worksheets
  • Editing, Saving and Printing the Workbook
  • Generating With Large Worksheets
  • 2. Database Management (MS Access):
  • Introduction to Access
  • Generating a New Database
  • Making a Tablet Wizard and Scratch Editing and Entering a Data into a Table
  • Configuring Access Table
  • Making Connections between Tables
  • Creating, Modifying and Adding Special Controls to Forms formation in the Database
  • Sorting, Filtering and Indexing Searching for Information in the Database
  • Sorting. Filtering and indexing Data
  • Generating simple Query and from Scratch
  • Making and Modifying a Report
  • Printing Access Objects
  • 3. Electronic Communication(MS Outlook):
  • Inside Outlook: Mixing, Matching, and Managing information
  • E-mail
  • Essentials and Restrictions
  • Important E-Mail Tools
  • Managing Contacts, Dates, Tasks, and Notes and Journal Entries
  • Feeding on I logs, Podcasts, and News with Outlook RSS
  • How to: Outlook at Home
  • Supercharging Your Sales with Business Contact Manager
  • Organizing and Customizing Outlook at the Office
  • Work with Outlook Web Access Outside of Home or Office
  • The Do's and Don'ts of Using Outlook.

Presentation Skills Enhancement.

  • 1. Business Presentation (MS PowerPoint):
  • Creating a New Presentation & Working with Slides in Different Ways
  • Storyboarding: Pre-Planning and Conceptualizing
  • Slide Transitions and Text Building
  • Using Different design Template, Color Schemes and Background Fill
  • Inserting, Deleting and Copying Slides
  • Reorganizing Slides in a Presentation
  • Putting In Text, Graphics
  • Sounds and Movies to Slide I Constructing Columns, Tables and Lists
  • Creating New Graphics and Images
  • Importing and Saving Graphic Files
  • Presenting an Onscreen Slide Show
  • Printing Presentations, Notes and Handouts
  • 2. Desktop Publishing Application (MS Publisher):
  • Introduction to MS Publisher
  • Creating a New Publication (Using Publication Category Saving the Publication)
  • Using Design Sets (Understanding and Selecting Design Sets - Compelling the Publication - Creating a Publication from Scratch)
  • Viewing and working on Existing Publications (Changing the Publication Display/ Using the Zoom Feature, Ruler and Layout Guides
  • Completing A Design Template Publication
  • Pages to a publication
  • Saving and Closing a Publication Working with Publication Objects (Inserting, Moving, Copying and Grouping Objects/Sizing an Object Frame/Arranging Objects in layers/Adding Border and Colors to Object Frames)
  • Changing How Text Looks (Adding Inserting, Selecting and Deleting Text
  • Working with Fonts: Font Attribute and Colors/Aligning Text in a Text Box/
  • Adding Tables to a Publication Working with Graphics (Inserting a Picture/Using Clip Art/Cropping pictures/Drawing Object)
  • Formatting, Fine Tuning and Printing Publisher Publications

Work Readiness Sessions

  • Workforce Preparation Skills o Setting a goal
  • Job search techniques
  • Research your company
  • Preparing for the interview
  • Dress for success – At interview and at work
  • Your attitude as an interviewee and once hired
  • Sending a follow up/ thank you note after interview
  • Developing a good work ethic/work habits/attendance tips
  • Understanding employer’s expectations and workplace rules
  • Communication Skills
  • Internal/ External Customer service skills
  • Interpersonal Skills