Basic Computer Online for Intermediate trainees by Systems Domain - Vijaya Nagar

Microsoft Word Basic
1. Explore Word
• Working in the user interface
• Creating, editing text and saving documents
o Creating a new blank document
o Entering text
o Saving the document
o Saving into a new folder
o Compatibility with older versions
• Opening, Moving around in and closing Documents
• Viewing documents in different ways
o Switching between different views
o Displaying non-printing characters
o Zooming in the document
o Switching between different word documents
o Arranging windows of open documents
o Displaying rulers in document window
• Accessing help feature

2. Editing and Proofread Text

• Making text changes
o Selecting text
o Deleting text
o Drag and drop
o Cut, Copy and Paste
o Paste Options
o Undo and redo
• Office clipboard
• Find and replace text
o Using find and replace
o Navigation pane
• Fine-tuning text
o Thesaurus
o Mini-translator
• Correcting spelling and grammatical errors
o Spell check
o Auto Correct
• Viewing document statistics
• Inserting saved text
o Building Blocks
o Create a new building block
• Inserting one document into another

3. Changing the Look of Text

• Quickly formatting text
o Paragraph styles
o Character Styles
• Changing a documents theme
o Switching between different themes
o Table style
o Manual formatting

5. Add Simple Graphic Elements

• Inserting and modifying pictures
o Insert Picture
o Resize and crop a picture
o Picture corrections and picture styles
o Artistic effects
• About ClipArt
• Changing a document background
• Inserting Building Blocks
o Inserting a Cover page
o Inserting Page Numbers
o Headers and Footers
• Drawing text boxes
• Adding Word Art
o Insert Word Art into the document
o Wrap text around Word Art
• Formatting the first letter of a paragraph

6. Preview, Print and Distribute Documents

• Previewing and adjusting page layout
o Adjusting Page size and orientation
o Setting up margins
• Controlling what happens on each page
o Page breaks
o Section breaks
• Printing documents
• Preparing documents for electronic distribution
o Document properties
o Document inspector
o Marking a document as

o Saving a new theme
• Manually changing the look of characters
o Changing font, font size and font colour
o Bold, Italic and Underline
o Using the Mini Toolbar
o Format Painter
o Font dialog box
o Highlight text
o Clear Formatting
• Manually changing the look of paragraphs
o Indenting
o First Line and hanging indents
o Paragraph alignment
o Setting up Tabs
o Adjusting line spacing
o Paragraph spacing
o Borders and Shading
• Character formatting and case considerations
• Find and replace formatting
• Creating and modifying lists
o Bullets and Numbering
o Customizing bullets and numbering
o Sorting lists
• Formatting text as you type

4. Organizing Information in Columns and Tables

• Presenting information in columns
o Inserting columns
o Justify paragraphs
o Column options
• Creating tabbed lists
• Presenting info in tables
o Inserting a table
o Inserting and deleting columns and rows
o Resizing columns
o Merge cells
o Table alignment
o Converting text to table
• Performing calculations in tables
• Other layout options
• Formatting tables

Microsoft Excel Basic
1. Setting up a workbook

• Creating Workbooks
o Excel Terminology
o Excel Environment
o Customizing Quick Access Toolbar
o Creating a New Workbook
o Entering Data into Workbook
o Saving a workbook
o Open a workbook
o Zoom
o Insert a new worksheet
o Renaming a new worksheet
o Changing the tab colour of worksheet
o Rearranging the order of worksheets
o Move or Copy worksheet
o Hide/Unhide Worksheet
o Switch Windows

• Modifying Workbooks and Worksheets
o Changing column widths and row heights
o Insert Columns/Rows
o Delete Columns/ Rows
o Hide/Unhide columns or rows
o Insert Cells
o Moving Data by dragging

• Customizing Excel
o Arranging multiple workbook windows
o Customizing the ribbon
o Minimizing the ribbon

2. Working with Data and Excel Tables

• Entering Data
• Copy, Cut and Paste
• Pick from drop down list
• Find and Replace data
• Spell Check
• Thesaurus

• Defining an Excel Table
o Format as table
o Table design
• Basic Formulas
o How to create a basic formula
o Operators
o Copy Formula down
o Absolute cell reference
• Basic Functions
o What is the difference between formulas and functions
o Insert a function
o AutoSum, sum, min, max and average

3. Changing Workbook Appearance

• Format Cells
o Changing Font, Font size and Font Colour
o Borders
o Bold, Italic and Underline
o Fill Colour
• Themes
• Format Numbers as percentage, currency and general
• Insert a Picture
• Picture Styles, remove background, picture effects
• Insert Background

4. Printing

• Inserting Headers and Footers
• Print Preview
• Page Setup
• Page break preview
• Print active worksheets
• Print entire workbook
• Print Selection
• Print titles
• Set Print Area
• Centre data on page

Microsoft PowerPoint Basic
1. Explore PowerPoint

• Working with the user interface
• Creating and saving presentations
• Compatibility with earlier versions
• Opening, Moving around in, and closing presentations
• Viewing presentations in different ways

2. Working with Slides

• Adding and Deleting slides
• Adding slides with ready-made content
• Slide Libraries
• Exporting presentations as outlines
• Dividing presentations into section
• Rearranging slides and sections

3. Working with Slide content

• Entering text into placeholders
• Adding text boxes
• Changing the default font for text boxes
• Editing text
• Clipboard
• Correcting and sizing text while typing
• Checking spelling and choosing the best words
• Research information
• Find and Replacing text and fonts

4. Format Slides

• Appling themes
• Using different theme colours and fonts
• Changing the slide background
• Changing the look of placeholders
• Changing the alignment, spacing, size and look of text

5. Add Simple Visual Enhancements

• Insert Picture and ClipArt images
• Inserting Diagrams
• Graphic formats
• Converting existing bullets into a diagram
• Inserting charts
• Inserting shapes
• Connecting shapes
• Adding transitions
Basics
1. Internet Introduction

• How Does the Internet Work?
• A Tour of a Typical Website

2. Browser Basics

• Using Multiple Windows
• Using Tabs
• Using the Search Box
• Downloading
o Saving pictures and files
o Using a Download Manager
• Printing a webpage

3. Internet Explorer

• Menu Bar
• Change your home page
• To add a new search provider
• To empty the Temporary Internet Files folder (cache)
• Clear the browsing history
• To save a webpage onto your computer
• Bookmarks

4. Searching

• Search Engines
• Finding what you need
• Useful websites

5. Internet Safety

• Storing your passwords and login details
• Allowing and blocking pop-ups
• InPrivate mode
• Parental Controls
• Viruses and Trojans

6. Review and Deliver Presentation

• Setting up a presentation for delivery
• Previewing and Printing Presentation
• Preparing speaker notes and Handouts
• Enhanced Handouts
• Finalizing Presentation
• Setting up presenter view
• Delivering a presentation