COURSE OUTLINES
FOUNDATION LEVEL COURSE OUTLINE
MICROSOFT WORD
The Microsoft Word Screen
Starting Microsoft Word
The Microsoft Word Opening Screen
To Create a New Blank Document
The Levels of Command Organisation
The File Tab
Ribbon Tabs
Groups
Dialog Box Launcher
Starting to Use Microsoft Word
Using the Default Microsoft Word Document
Saving Microsoft Word Documents
Opening and Closing Documents
Save As
Creating a New, Blank Document Using a Keyboard Shortcut
Using Help within Microsoft Word
Alt Key Help
Closing Microsoft Word
Using Templates to Create Documents
Creating New Documents Using Different Templates
Using Online Templates
Manipulating Text
Select, Then Format
Selecting Text
Inserting, Deleting, Undo and Redo
Insert and Overtype Mode
Copying Text within a Document
Moving (Cutting) Text within a Document
Pining Files and Folders and Opening Documents
Pinning
Recently Open Documents
Viewing a Document Where You Left Off
Microsoft Word Text Formatting
What Is Text Formatting?
Font Type
Font Size
Decrease and Increase Font Size Icons
Font Size Keyboard Shortcut
Bold, Italic and Underline
Subscript and Superscript
Case Changing
Highlighting
Font Colour
Copying Text Formatting
Removing Formatting
Using Zoom
Inserting Special Characters and Symbols
Microsoft Word Paragraph Formatting
Paragraph Marks
Soft Paragraph (Line Break) Marks
Recommended Techniques for Aligning and Indenting Text
Aligning Text
Indenting Paragraphs
Applying Single or Double Line Spacing within Paragraphs
Applying Spacing Above or Below Paragraphs
Using Paragraph Spacing Rather Than Using the Return Key
Applying Bullets to a List
Applying Numbering a List
Modifying Bullet and Numbering Formatting
Removing Bullet or Numbering Formatting
Borders and Shading within Microsoft Word
Using Borders and Shading
Adding a Border
Modifying Borders
Adding Shading
Modifying Your Shading
Applying Borders to Selected Text
Tabs
Tab Stops
Displaying the Ruler
Setting and Removing Tabs Using the Ruler
Viewing Tab Marks Using the Show/Hide Icon
Microsoft Word Styles
What Are Styles?
Applying Styles
Using Word Design Themes
Applying a Theme Colour
Apply a Customised Font
Microsoft Word Page Formatting
What Is Page Formatting?
Page Orientation and Paper Size
Changing the Page Size
Page Margins
Inserting Page Breaks
Deleting Page Breaks
Use Page Breaks Rather Than Repeatedly Pressing the Return Key
Headers and Footers
Easy Header and Footer Creation
Page Numbering
Header and Footer Fields
Editing Text within a Header or Footer
Cover Pages
Applying Automatic Hyphenation
Word Views and Document Navigation
Switching between Word Views
Using the Zoom Tool
Navigating Through Documents
Tables
Using Tables
Inserting a Table
Navigating within a Table
Selecting and Editing Text within a Table
Selecting Cells, Rows, Columns or the Entire Table
Inserting and Deleting Rows and Columns
Modifying Column Width or Row Height
Modifying the Table Width
Modifying Table Styles
Using Illustrations within Microsoft Word
Types of Illustrations That You Can Insert within Word
Inserting Pictures
Inserting Online Pictures
Inserting Shapes
Inserting SmartArt
Inserting a Chart
Modifying the Chart Type
Modifying the Chart Style
Modifying the Chart Data
Inserting a Screenshot
Selecting, Resizing and Deleting Illustrations
Copying or Moving Graphics
Finding and Replacing Text within a Microsoft Document
Using Find and Replace
Finding Text
Replacing Text
Using Multiple Open Documents
Multitasking With Word
Switching between Open Documents
Tiling or Cascading Documents on Your Screen
Comparing Documents Side By Side
Copying or Moving Selected Items between Documents
Microsoft Word Mail Merge
What Is Mail Merging?
Starting the Mail Merge Wizard
Creating a Mailing List to Be Used within a Mail Merge
Merging a Mailing List to Produce Labels
MICROSOFT EXCEL
Getting Started With Excel
Starting Excel
Selecting the Blank Worksheet Template
The Excel Cell Referencing System
Entering Numbers and Text
Default Text and Number Alignment
Summing a Column of Numbers
Entering a Date
Worksheets and Workbooks
Saving a Workbook to Your Hard Disk
Closing a Workbook
Creating a New Workbook
Opening a Workbook
Opening a Recently Used Workbook
Pinning Files and Folders
Switching between Workbooks
Saving a Workbook Using another Name
Saving a Workbook Using a Different File Type
Getting Help within Excel
Searching For Help
The Help 'Table of Contents'
Printing a Help Topic
Alt Key Help
Using Other Excel Templates
Excel Selection Techniques
Why Are Selection Techniques Important?
Selecting a Cell
Selecting a Range of Connecting Cells
Selecting a Range of Non-Connecting Cells
Selecting the Entire Worksheet
Selecting a Row
Selecting a Range of Connecting Rows
Selecting a Range of Non-Connected Rows
Selecting a Column
Selecting a Range of Connecting Columns
Selecting a Range of Non-Connecting Columns
Recommended Techniques When Creating or Editing Lists
Manipulating Rows and Columns within Excel
Inserting Rows into a Worksheet
Inserting Columns into a Worksheet
Deleting Rows within a Worksheet
Deleting Columns within a Worksheet
Modifying Column Widths
Modifying Column Widths Using 'Drag and Drop'
Automatically Resizing the Column Width to Fit Contents
Modifying Row Heights
Manipulating Cells and Cell Content within Excel
Copying a Cell or Range Contents within a Workbook
Deleting Cell Contents
Moving the Contents of a Cell or Range within a Workbook
Editing Cell Content
Undo and Redo
Copying Data between Worksheets (Within the Same Workbook)
Moving Data between Worksheets (Within the Same Workbook)
Moving Data Worksheets (Between Different Workbooks)
Copying Data between Worksheets (In Different Workbooks)
AutoFill
Copying a Data Range Using AutoFill
Sorting a Cell Range
Searching and Replacing Data
Excel Worksheets
Switching between Worksheets
Renaming a Worksheet
Recommended Techniques with Naming Worksheets
Inserting a New Worksheet
Deleting a Worksheet
Copying a Worksheet within a Workbook
Moving a Worksheet within a Workbook
Copying or Moving Worksheets between Workbooks
Font Formatting within Excel
Font Formatting Options
Font Type
Font Size
Bold, Italic, Underline Formatting
Cell Border Formatting
Formatting the Background Colour
Formatting the Font Colour
Alignment Formatting within Excel
Horizontally Aligning Contents in a Cell Range
Centring a Title over a Cell Range
Cell Orientation
Text Wrapping within a Cell
Aligning Cell Contents Vertically
Format Painter
Number Formatting within Excel
Number Formatting
Decimal Point Display
Applying and Removing Comma Style Formatting (To Indicate Thousands)
Currency Symbol
Date Styles
Percentages
Freezing Row and Column Titles
Freezing Row and Column Titles
Excel Formulas
Creating Formulas
The Easy Way to Create Formulas
Copying Formulas
Operators
Using Operators in Formulas
Formula Error Messages
Relative Cell Referencing within Formulas
Absolute Cell Referencing within Formulas
Excel Functions
What Are Functions?
Common Functions
Sum Function
Average Function
Max Function
Min Function
Count Function
The Counta Function
The Countblank Function
What Are 'If Functions'?
Using the If Function
Excel Charts
Inserting a Column Chart
Inserting a Line Chart
Inserting a Bar Chart
Inserting a Pie Chart
Resizing a Chart
Deleting a Chart
Chart Title or Labels
Changing the Column, Bar, Line or Pie Slice Colours in a Chart
Modifying the Legend Fill Colour
Changing the Chart Type
Modifying Charts Using the Layout Tab
Copying and Moving Charts within a Worksheet
Copying and Moving Charts between Worksheets
Copying and Moving Charts between Workbooks
Customising Excel
Modifying Basic Excel Options
MICROSOFT POWERPOINT
Using PowerPoint
Opening PowerPoint
Opening a Presentation
Navigating between Slides
Using the Zoom Tool
Changing PowerPoint Views
Using Help
Searching For Help
Using the Help Table of Contents
Saving a Presentation
Closing a Presentation
Closing PowerPoint
Opening Multiple Presentations
Switching between Multiple Presentations
Creating a PowerPoint Presentation
Creating a New Presentation
Inserting a New Slide
Recommended Techniques When Creating Slide Content
Undo and Redo
Saving a Presentation
Saving a Presentation Using a Different Name
Manipulating Slides within PowerPoint
Inserting Slides with a Particular Slide Layout
Modifying the Slide Layout
Changing the Background Colour on the Active Slide
Changing Background Colour on All the Slides within a Presentation
PowerPoint Design Themes
Applying a Theme to a Presentation
Modifying the Theme Colours
Modifying the Theme Fonts
Text Boxes (Placeholders)
Editing Text Boxes (Placeholders)
Resizing a Text Box (Placeholder)
Moving a Text Box (Placeholder)
Manipulating Text in PowerPoint
Selecting Text
Moving Text within a Slide
Moving Text between Slides within a Presentation or between Presentations
Copying Text within a Slide
Copying Text between Slides within a Presentation or between Presentations
Deleting Text
Using Find
Using Replace
Font Formatting within PowerPoint
Font Formatting Options
Changing the Font Type
Changing Font Size
Increasing or Decreasing the Font Size
Bold, Italic or Underline Formatting
Strikethrough Effects
Shadow Effects
Character Spacing
Changing Case
Font Colour
Clearing All Text Formatting
Paragraph Formatting within PowerPoint
Text Alignment
Columns
Modifying Bullet Point Formatting
Using Numbering Instead of Bullet Points
Changing the List Level
Indenting Bulleted Text
Line Spacing Vs. Paragraph Spacing
Line Spacing
Paragraph Spacing
Using Outline View
PowerPoint Presenter Notes
Text Direction
Text Alignment within a Text Box (Placeholder)
Text AutoFit
Using the Format Painter
Tables and PowerPoint
Table Selection Techniques
Column Selection
Row Selection
Entire Table Selection
Creating a Table
Applying a Style to a Table
Cell Background Shading
Applying Table Effects
Adding 'Quick Styles' to Selected Text
Applying Borders to Cells
Deleting a Column
Deleting a Row
Inserting Rows or Columns
Modifying Column Width and Row Height
Distributing Rows and Columns
PowerPoint & Illustrations
Selecting an Illustration
Selecting Multiple Illustrations
Moving an Illustration
Copying an Illustration
Deleting an Illustration
Resizing an Illustration
Stretching an Illustration
Copying Illustrations between Presentations
Moving Illustrations between Presentations
Inserting Illustrations within PowerPoint
Inserting Pictures from Your Hard Disk
Inserting Online Pictures or Clip Art
Inserting Shapes
Inserting Text into a Shape
Inserting Perfect Circles or Perfect Squares
Inserting a Line
Inserting a Free Drawn Line
Inserting an Arrow
Inserting a Text Box
Inserting SmartArt
Manipulating Illustrations within PowerPoint
Formatting the Shape Background Fill Colour Style
Applying a Shadow to an Illustration
Modifying Arrow Line Shapes and Size
Rotating or Flipping an Illustration
Rotating Illustrations by Dragging With the Mouse
Layering Illustrations to the Front or Back
Aligning Graphics Relative to Each Other or Relative to the Slide
Aligning Shapes Relative to the Left of a Slide
Aligning Shapes Relative to the Centre of a Slide
Aligning Shapes Relative to the Right of a Slide
Aligning Shapes Relative to the Top of a Slide
Aligning Shapes Relative to the Bottom of a Slide
Grouping and Ungrouping Objects
Charts in PowerPoint
Inserting Charts and Editing the Chart Data
Changing the Chart Type
Changing the Background Colour in the Chart
Changing the Column, Bar, Line or Pie Slice Colours in the Chart
Chart Title Manipulation
Adding Data Labels to a Chart
Manipulating Slides within PowerPoint
Moving Slides within a Presentation or between Presentations
Copying Slides within a Presentation
Deleting a Slide or Slides
Copying Slides between Presentations
Moving Slides between Presentations
PowerPoint Slide Masters
What Is a Slide Master?
Inserting a Picture (Clipart) Into a Master Slide
Removing a Picture or Shape from a Master Slide
Headers, Footers and Slide Numbering
Creating a Footer
Automatic Slide Numbering
Inserting Dates into the Footer
PowerPoint Slide Shows
Running a Slide Show
Adding Slide Show Transition Effects
Removing Transition Effects
Adding Slide Show Animation Effects
Modifying Slide Show Animation Effects
Removing Animation Effects
Hiding Slides
Displaying Hidden Slides within a Slide Show
Video Creation Using PowerPoint
Inserting Hyperlinks into Slides
Converting a PowerPoint Presentation into a Video
Uploading a Video to YouTube
Printing and Proofing In PowerPoint
Spell-Checking a Presentation
Using Portrait or Landscape Slide Orientation
Switching between Standard and Widescreen Formats
Selecting Your Output Format
Visually Inspect Each Slide before Printing
Printing Options
Setting the Number of Copies to Print
Selecting a Different Printer
Printing Selected Slides
Setting the Number of Slides per Page to Be Printed
Single or Double Sided (Duplex) Printing
To Print a Presentation
MICROSOFT OUTLOOK
A FIRST LOOK AT OUTLOOK
Starting outlook
The Microsoft outlook screen
Help in outlook
Printing help sheets
Microsoft outlook navigation pane
Microsoft outlook ribbon
Closing outlook
TERMINOLOGY & CONCEPTS
What is email?
The structure of an email address
The advantages of using email
SMS (Short Message Service)
Voice over internet protocol (VOIP)
Instant messaging
Online (virtual) communities
Social networking websites
Internet forums
Chat rooms
Online computer games
SECURITY ISSUES
Spam
Viruses
Phishing
Digital signatures
SENDING MESSAGES
Creating and sending your first email
Checking that your email was sent
Sending emails to more than one person
Receiving and reading emails
Sending a copy of a message to another address
What is a blind carbon copy?
Sending a copy of a message to another address using blind carbon copy (bcc)
Think about the message subject – short and descriptive
Spell checking your messages
Attaching a file to a message
Deleting an attached file
Issues when sending file attachments
Setting message importance
Setting message sensitivity
Saving a draft copy of an email
RECEIVING, READING AND REPLYING TO MESSAGES
The inbox folder
Opening the inbox folder
The inbox screen
Selecting a message
Reading a message
Switching between open message windows
Forwarding a message
Opening or saving an attached file
Replying to the sender of a message
Replying to the sender and all recipients of a message
Setting message reply options so that the original message is inserted, or not inserted
Printing a message
Printing options
MANIPULATING TEXT AND FILES
Selecting a word within the message window
Selecting a line within the message window
Selecting a paragraph within the message window
Selecting all text within the message window
Selecting text using the mouse
Copying text to the clipboard from a message
Pasting text from the clipboard into a message
Copying text from one message to another
Cutting text to the clipboard from a message
Moving text from one message to another
Deleting text in a message
Deleting text to the left of the insertion point
Deleting text to the right of the insertion point
PEOPLE AND CONTACTS
What are people contacts?
Opening the people folder
Creating a contact
Adding the sender of a message to your contacts list
Addressing an email to a contact
Deleting a contact
What is a contact group?
Creating a new contact group
Adding an email address to a customised contact group
Removing an email address from a contact list
Sending an email to an entire contact group list
ORGANISING MAIL
Searching for a particular email message
Searching for messages by sender, subject or content
Creating a new mail folder
Moving a message to a different folder
Deleting a mail folder
Sorting the contents of the inbox
Deleting a message
Opening the ‘deleted items’ folder
Restoring a message from the ‘deleted items’ folder
Emptying the ‘deleted items’ folder
Automatically emptying the ‘deleted items’ folder when you exit outlook
Flagging a message
Removing a flag mark from a mail message
Marking a message as unread
Marking a message as read