Advanced Computer Skills Training Course

Introduction

The course will purpose to empower participants with Microsoft Office skills to harness the power of computing for their own benefit and gain a great knowledge of computer.

Duration

10 Days

Who Should Attend

This course is designed for anyone who has little or no computer literacy.

Course Content

Module 1: Introduction to Computers and Windows Operating System

• Basic computer terminology.
• What is a computer?
• What is an operating system?
• What are the major physical components of the computer?
• Keyboard
• Mouse
• Cpu
• Monitor
• What is the desktop?
• Quick Launch Toolbar
• Taskbar
• Start menu
• My Computer
• Task Manager
• Windows and its components
• Minimize/Maximize/Close buttons
• Title bar

• Navigating a webpage
• ISP
• URL
• Web site
• Home page
• Bookmark
• Search engine

• Web browsing (Google Chrome, Mozilla)
• Navigation
• Toolbars
• Menu options
• Scrolling
• Minimize, maximize and close
• Favorites
• Highlight
• Print

• File Management
• Create a new folder.
• Copy/Move files from one folder to another.
• Drag and Drop files.
• Create different file types with varying extensions.
• Create a shortcut to an often-used file or application.
• Utilize the hard drive and other drives for file management.
• Rename/Delete a folder or file.
• Use the Recycle Bin appropriately.

Module 2: Microsoft Word

• Introduction
• Starting Microsoft Word
• Quitting Microsoft Word
• File Management
• Creating A New Document
• Saving A Document in Microsoft Word
• Saving To Different Locations
• Opening An Existing Document
• Editing
• Moving around the Document
• Delete Text
• Selecting Text
• Move and Copy Text
• Checking Spelling and Grammar

• Document Enhancements
• Introduction
• Character Formatting
• Paragraph Formatting
• Bulleted and Numbered Lists

• Page and Document Attributes
• Introduction
• Document Views
• Custom Margins and Page Layout
• Page Numbers, Headers and Footers
• Page Breaks

• Tables and Styles
• Introduction
• Tables
• Columns
• Mail merge
• Graphics
• Introduction
• Drawing Bar
• Inserting Objects Vs Linking Objects
• Editing and Formatting Graphics
• Table Of Contents And Printing
• Introduction
• To compile a table of contents by using built-in heading styles:
• List of Figures
• Table of Index
• Printing

Module 3: Microsoft Excel

• Introduction
• Creating a Basic Worksheet
• Performing Calculations
• Modifying a Worksheet
• Formatting a Worksheet
• Printing Workbook Contents
• Data Analysis and Presentation
• Validating and Updating data
• Types of spread sheets
• Examples of spread sheets
• Advantages of electronic spread sheets
• Functions of spread sheets
• Applications of spread sheets
• Getting Started

• To launch Ms Excel 2003;
• Parts of Ms Excel Applications Window
• Features of microsoft excel
• Data entry in ms excel
• Types of formula
• Entering data in a cell
• Selecting data in a work sheet

• Formatting A Worksheet
• Auto formats
• Data reference

• Types of cell reference

• Editing a worksheet
• Functions and formula
• Calculation operators:
• Using various functions

• Data management functions

o    Goal seek

o    Sorting and filtering

o    Sorting

o    Filtering

o    Auto filter

o    Advanced filter

o    Subtotal

o    Data validation

• Microsoft excel charts and graphs

o    Steps of creating a chart

o    Types of charts

o    Creating a pivot table

o    Formatting charts

• Printing

o    Setting print area, page setup and passwords

o    Page setup and printing

o    Repeating titles in every page (column labels)

o    Print order/ print area

• Other functions

o    To protect your work book / work sheet

o    To protect a work book

o    Data forms

o    Errors values

o    Freeze pane

o    Split panes

Module 4: Microsoft Outlook

• How to use features of Outlook
• How to compose and organize your email
• How to work with contacts
• How to use calendar features
• How to do Outlook tasks

Module 5: Microsoft PowerPoint

• New Features of PowerPoint
• Creating presentations with PowerPoint
• Apply pre-production organizational concepts (such as storyboarding and visual organizers)
• Open and close a presentation or presentation template
• Save a presentation file
• Create an original presentation or use a template
• Rearrange slides using slide sorter or a storyboard feature to organize a presentation
• Choose a slide format

• Use icons and menus
• Type/enter text or create a text box
• Change (Font size, Font type, Style or effects, Color )
• Cut, copy, and paste text
• Use undo and redo icons
• Select and resize graphics, pictures, clip art
• Select multimedia clips or sounds
• Use page setup
• Print
• Use slide show tool
• Transitions and animations
• Graphics, clip art, sounds, and multimedia files (including narration)
• Modifying background and layout of presentation slides
• Use of spell check, grammar check, and thesaurus
• Use find, change, and replace tools
• Apply principles and elements of graphic design
• Use tools to rotate, edit, or highlight text
• Insert objects such as graphs, charts, and spreadsheets
• Insert hyperlinks
• Use print preview
• Print audience handouts to support a multimedia presentation
• Insert page/slide numbers
• Manage headers and footers

Module 6: Microsoft Access

• How to create and design Access databases
• How to work with Access tables, relationships, keys and constraints
• How to query data
• How to manage and design interfaces with Access Forms
• How to create basic to advanced reports
• How to automate tasks with Macros and VBA

Module 7: Web Surfing

• Social Media Security
• Drop box
• Google Drive
• Emails

Module 8: Virus Control (Antivirus Management Techniques)

• Viruses
• Definitions
• Types of viruses

o    Software Bugs.

o    Trojan Horses.

o    Software Chameleons.

o    Software Bombs.

o    Logic Bombs.

o    Time Bombs.