Course Objectives

Upon completion of this course attendees will be able to design, produce and deliver effective presentations.

Learning Outcomes

• Use basic file and window management
• Input text
• Edit, format and print a document
• Proofread a document
• Enter data into a spreadsheet
• Perform basic spreadsheet calculations
• Edit and format spreadsheets
• Use spreadsheet functions
• Communicate effectively by email

Customising the Quick Access Toolbar and Ribbon

• Starting Word
• The Office Ribbon
• Creating a New Blank Document
• Saving a Document
• Closing a Word Document
• Opening an Existing Document
• Using Save As
• Exiting Word

Word Text Entry

• Entering Text
• Moving through a Document
• Inserting New Text
• Selecting Text
• Cut and Paste
• Copy and Paste
• Undo and Redo

Font and Basic Paragraph Formatting

• Font, Font Size and Font Colour
• Bold, Italic and Underline
• Other Font Settings
• Formatting using the Font Dialog
• Font
• Advanced tab
• Paragraph Alignment

Proofreading and Printing

• Spelling and Typographical Errors
• Autocorrect, Automatic check and Manual proofreading
• Different Views
• Zoom
• Printing

Excel Data Entry

• What is Excel?
• The Structure of a Spreadsheet
• The Active Cell
• Entering Text
• Selecting Cells, cell blocks, rows and columns
• Changing Column Widths and Row Heights
• Inserting and Deleting Rows and Columns

Basic Calculations

• Objectives
• Overview
• Cell Addressing
• The Basic Excel Formula
• Entering a Formula
• Using Brackets in a Formula

Basic Editing

• Cut and Paste
• Copy and Paste
• Undo and Redo
• Autofill

Basic Formatting

• General Formatting
• Formatting Buttons on the Ribbon
• The Formatting Dialog
• Number Formatting
• Date and time formatting
• Cells Sustain Formats
• Format Painter

Basic Functions

• The Structure of a Function
• Inserting a Function
• Sum, Max, Min, Average, Count

Outlook Mail Basics

• Mail Essentials
• The nature of an email address
• Outlook Contacts
• Recipient Categories
• To: cc: and bcc List
• Sending mail
• Checking Mail
• Reading Mail
• Replying to Mail
• Forwarding