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.
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
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.
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
Character Formatting
Paragraph Formatting
Bulleted and Numbered Lists
Page and Document Attributes
Document Views
Custom Margins and Page Layout
Page Numbers, Headers and Footers
Page Breaks
Tables and Styles
Tables
Columns
Mail merge
Graphics
Drawing Bar
Inserting Objects Vs Linking Objects
Editing and Formatting Graphics
Table of Contents and Printing
To compile a table of contents by using built-in heading styles:
List of Figures
Table of Index
Printing
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
Editing a worksheet
Functions and formula
Calculation operators:
Using various functions
Goal seek
Sorting and filtering
Sorting
Filtering
Auto filter
Advanced filter
Subtotal
Data validation
Steps of creating a chart
Types of charts
Creating a pivot table
Formatting charts
Setting print area, page setup and passwords
Page setup and printing
Repeating titles in every page (column labels)
Print order/ print area
To protect your work book / work sheet
To protect a work book
Data forms
Errors values
Freeze pane
Split panes
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
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
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 tool
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
Edit master slide(s)
Adjust presentation timing, action buttons, and looping
Import animations, sounds, and multimedia from other files/applications (such as background music and visual organizers)
Create presentations using navigation buttons and non-linear design
Work in various modes/views (such as outline, notes, and presentation)
Use function keys and keyboard shortcuts
Adjust page/slide views
Troubleshoot formatting problems -- use Help feature
Modify tool bars to reflect current use for tool(s)
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
Social Media Security
Drop box
Google Drive
Emails
Viruses
Definitions
Types of viruses
Software Bugs.
Trojan Horses.
Software Chameleons.
Software Bombs.
Logic Bombs.
Time Bombs.
Resident viruses
Non-resident viruses
Vectors and hosts
History of Viruses
Ways in which a virus can infect a computer
Different Approaches of Dealing with Virus
Dictionary approach
Suspicious approach
Heuristic approach
Sandbox approach
File type approach
White listing approach
Issues of Concern
Replication strategy
Types of transmission media and files commonly targeted by viruses.
Methods that viruses use to avoid detection
Vulnerable computer spots
Virus Detection
What to do if infected
Introduction to antivirus soft wares
Types of antivirus soft wares
How antivirus soft wares work
Installing, managing, updating and using antivirus soft wares
Preventive measures
Counter measures (user education)
Recovery methods
Policies that can be implemented to control virus risk in computers
Boosting The Microsoft Office skills and use of Technology in an easiest way of Service Delivery
Find subjects you're passionate about by browsing our online course categories. Start
learning with top courses Built With Industry Experts.