home |
2010 SkillMaster Computer Courses
|
email us
|
*Email us to request Microsoft Word format brochures.
Introduction to Computers course is designed for beginners. It will cover the following topics:
Start computer and access basic system information & features
Computer functions
Navigate and manipulate desktop environment using mouse and keyboard
Organise basic directory and folder structures
Storage devices and basic categories
Organise files for user and/or organisational requirements
Basic parts of a computer and various hardware components
Basic keyboarding skills
Saving and retrieving files to various locations
Reading and writing at a level where basic workplace documents are understood
Interpretation of user manuals and help functions
Learn about computer security and virus protection
Operating Health and Safety issues
Conservation techniques in the office
Copyright
Computer terminology
Professional Ethics
Computer Jobs
Shut down
Design
and create newsletters and columns using Microsoft Word
Create
Flyers
Import
and modify graphics (drawings and photographs)
Create a
booklet
Create
invitations and cards
Create
business cards
Work with
forms
Create mass
mailings and merges
Create a Logo
Work advanced tables
Work
Section Breaks
Advanced
Headers and Footers
Work with
Tabs
Work with
Watermarks
Work with
WordArt
Work with
Templates
with autofeatures
Work with
borders
and lines
Work with
Text
Boxes and Callouts
Work with
forms and advanced tables
Create Table of
Contents
Create Index
and Table of Figures
Create
Comments and Footnotes
Create a Webpage
in Word
Create a booklet
Autocorrect
and Autotext
Import/Export to PowerPoint, Photoshop and other programs
Use Word
shortcuts
Desktop
manipulation
Multitasking - Work with several applications
Customise
the Start Button and the Taskbar
Customise
Toolbars
Controlling,
tiling and sizing Windows
Organising Files
Work with
a
CD/DVD/USB
Recycle
Bin
Customize
Desktop (screen saver, colours, etc)
Printer
installation and management
Disk
Cleanup and freeing of space
Hard Disk
maintenance: ScanDisk
Disk
Defragmenter
Create a
Startup Disk
Add and
Remove Windows Components
Compress
folders and files and graphics
Change
System Settings
Plug and
Play
Hibernation and Standby
Shortcuts
and "Scraps"
Import
and compress graphics from camera/scanner
Create
Folders and subfolders
Backup and
System Restoration
Change
Date/Time
Languages
Support
Security
with Passwords
Spy cookie
removal
Virus
Protection
Finding
Files
Work with
Windows Explorer and
My Computer
Control
Panel
Get Help in
Windows
Install
Drivers
Customise
Icons
Customise
Send to Menu
The Network
Neighbourhood
Work with
Fonts
Accessories:
Calculator, Notepad, Clipboard, Paint
Install and
Remove Software
Internet software;
privacy, crime and social
concerns
CD/DVD/Floppy care and management
Ergonomics
Input and
Output devices, computer system connection
|
|
Revision of Excel Basics |
|
|
Excel Auto features |
|
|
Right Mouse Button Fill |
|
|
Left Mouse Button AutoFill |
|
|
Creating a Custom List |
|
|
Page Layout Features |
|
|
Relative and Absolute References |
|
|
Filter the List (Database) |
|
|
Subtotal List (Database) |
|
|
Consolidate Data |
|
|
Name ranges and Worsksheets |
|
|
Group and Outlining |
|
|
3D Formulas (file and sheet linking) |
|
|
Excel Charts |
|
|
Insert Comments |
|
|
Track Changes |
|
|
Paste Special |
|
|
Find and Replace |
|
|
Conditional Formatting |
|
|
Statistical and Math Functions |
|
|
Logical functions |
|
|
Dates functions |
|
|
Text functions |
|
|
Pivot tables |
|
|
Create Pivot Charts |
 |
Working with Range names |
|
|
Nesting functions with IF |
|
|
SUMIF functions |
|
|
ROUND functions |
|
|
Using the PMT function |
|
|
Using the VLOOKUP, MATCH, and INDEX functions |
|
|
Using data tables |
|
|
Validating data |
|
|
Using database functions |
|
|
Importing/exporting data to text files |
|
|
Object Linking and Embedding |
|
|
Using Goal Seek |
|
|
Using Solver |
|
|
Installing Analysis ToolPak |
|
|
Creating Views |
|
|
Creating Scenarios |
|
|
Working with macros and VBA |
|
|
Creating custom functions |
|
|
Creating Document Workspaces |
|
|
SharePoint server |
|
|
Web Query |
|
|
Templates |
|
|
Pivot Tables and Pivot Charts |
|
|
Security |
|
|
File Password Protection |
 |
Create letters, fax forms and multi-page documents |
|
|
Format text and tables |
|
|
Insert graphics |
|
|
Spell Check and Grammar Check |
|
|
Work in Print Preview |
|
|
Autocorrect and Autoformat |
|
|
Work with shortcuts |
|
|
Tabs |
|
|
Page Setup and Page breaks |
|
|
Headers and Footers |
|
|
Work with various views |
|
|
Date and Time |
|
|
Copy and Paste data |
|
|
Find and Replace data |
|
|
Undo mistakes |
|
|
Work with bullets |
|
|
Create a newsletter, a flier and forms |
|
|
Mail Merge |
|
|
Format Painter |
|
|
Advanced Tables |
|
|
Formulas |
|
|
Sorting data |
|
|
WordArt |
|
|
Create forms |
|
|
Drop Caps |
|
|
Work with formulas and sorting |
|
|
Import external data (PowerPoint, Excel, Explorer) |
|
|
Drawing Toolbar |
|
|
Create labels and business cards |
|
|
Autoformat |
|
|
Autotext and Spike |
|
|
Work with multiple windows |
|
|
Insert Symbols |
|
|
Import and modify graphics (drawings and photographs) |
|
|
Work with forms |
|
|
Create mass mailings and merges |
|
|
Advanced tables |
|
|
Section Breaks |
|
|
Advanced Headers and Footers |
|
|
Work with Tabs |
|
|
Work with Watermarks |
|
|
Work with WordArt |
|
|
Work with Templates with auto features |
|
|
Work with borders and lines |
|
|
Work with Text Boxes and Callouts |
|
|
Work with forms |
|
|
Create Table of Contents |
|
|
Create Index and Table of Figures |
|
|
Create Comments and Footnotes |
|
|
Create a Webpage in Word |
|
|
Autocorrect |
|
|
Autotext and Spike |
|
|
Import/Export to PowerPoint, Photoshop and other programs |
|
|
Use Word shortcuts |
|
|
Work with styles |
|
|
Work with fill-in form fields |
|
|
Track Changes |
|
|
Customise screen and toolbars |
|
|
Macros |
|
|
Document Protection |
|
|
Work with multiple toolbars |
|
|
Insert Footnotes |
|
|
Insert Comments |
|
|
Bookmarks |
|
|
Create Master document and subdocuments |
|
|
Advanced document layout and formatting |
|
|
Work in Print Preview |
|
|
Autoformat |
|
|
Work with shortcuts |
|
|
Page Setup and Page breaks |
|
|
Work with various views |
|
|
Date and Time |
|
|
Copy and Paste data |
|
|
Find and Replace data |
|
|
Customise bullets |
|
|
Format Painter |
|
|
Sorting data |
|
|
WordArt |
|
|
Create forms |
|
|
Drop Caps |
|
|
Work with formulas and sorting |
|
|
Import external data (PowerPoint, Excel, Explorer) |
|
|
Drawing Toolbar |
|
|
Create labels and business cards |
|
|
Work with multiple windows |
|
|
Insert Symbols |
|
|
Documents Compare |
|
|
Research facilities |
|
|
Create text, bullet and title charts |
|
|
Format text, backgrounds and objects |
|
|
Work in various views |
|
|
Create organisational charts |
|
|
Create graphs |
|
|
Create flowcharts |
|
|
Design and manipulate graphics |
|
|
Create special animation and sound effects |
|
|
Create a web page |
|
|
Create slide show |
|
|
Create Tables |
|
|
Create Photo Album |
|
|
Work with Diagrams |
|
|
Work with WordArt |
|
|
Work with Graphs |
|
|
Slide Transitions and Animations |
|
|
Speaker Notes |
|
|
Templates |
|
|
Master Slides |
|
|
Headers and Footers |
|
|
Print Handouts options |
|
|
Create Webpage |
|
|
Shortcuts |
|
|
Copy/Paste/Delete Slides |
|
|
Import/Export Word/Excel |
|
|
Create PowerPoint Show Files |
Creating
a Web
-Overview of Web Development
-Design a Web Page Layout
-Create a New Web Site
-Create and Format Web Page Text
-Import Web Pages
Creating
Links
-Add Hyperlinks
-Add Bookmark Links
-Link from an Image
Adding
and modifying Tables
Create
customised bullets
Create
Navigation Bar
Use lines
and dividers
Work with
graphics (JPG and GIF)
Work with
Frames
Formatting a Web Page
-Work with Themes
-Set the Background
Publishing a Web
-Optimise page for search engines
-Downloading process of the page
-Web Page Hosting and Name Registration
|
|
|
|
Tables: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Queries: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forms: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Reports: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tables: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Queries: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forms: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. Outlook Screen Components |
|
|
2. Use Mail |
|
|
Use Address Book and Contact lists |
|
|
Calendar |
|
|
Task Management |
|
|
Outlook Rules and Out-of-Office Assistant |
|
|
Mail Merge with Outlook |
|
|
Journal |
|
|
Notes |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The Access Screen and the Database Window | |
| Planning your design |
|
| Create Tables |
|
| Filter Tables |
|
| Querying Tables |
|
| Work with Forms |
|
| Create Reports |
|
| What is a Spreadsheet? |
|
| Basic Operations |
|
| Manipulate Data |
|
| Automating Data Entry |
|
| Formulas |
|
| Charts |
|
| Printing |
|
| What is Word Processing? | |
| Word's Screen |
|
| Using Help in Word | |
| Create documents |
|
| Format text | |
| Manipulate text |
|
| Work with multiple Windows |
|
| Save | |
| Page Setup | |
| Work with Indents | |
| Paragraphs' techniques | |
| Managing documents |
|
| Spell check and Grammar Check | |
| Selecting text techniques | |
| Find and Replace text | |
| Undo mistakes | |
| Autocorrect | |
| Printing and Print preview | |
| Page Breaks | |
| Work with bullets and paragraph numbering | |
| Work with paragraph borders and shading | |
| Introduction to Graphics | |
| Keyboard Shortcuts | |
| Page Numbering | |
| Headers and Footers |
| What is the Internet and World Wide Web? |
|
| Browsing the Internet |
|
| Manipulate data |
|
| Search for Information |
|
| Transferring Files |
|
| Security |
|
| Blogs and Forums | |
| Shopping On-line |
|
| Electronic Banking | |
| Chat Rooms and Newsgroups | |
| Using Skype and communication software |
|
| Work with multimedia |
|
| On-line Subscriptions | |
| Remote logon | |
| Home Page | |
| History | |
| Bookmarks and Favorites | |
| Internet Options | |
| Menus |
|
|
|
| Putting your pages on the web |
|
home SkillMaster Computer Training |
rustran@gmail.com |
We offer your staff electronic version of our training manuals for
