Microsoft Office for Beginners in Word, Excel and Outlook

Course Overview

Microsoft Office for Beginners in Word, Excel and Outlook

This course covers all the fundamental skills required to:

• Create and format simple, professional documents with a variety of layouts in Microsoft Word
• Create and format spreadsheets, automate spreadsheets with formulas and prepare them for printing and other outputs in Microsoft Excel
• Communicate efficiently with colleagues via email and schedule your calendar time with Microsoft Outlook

Course Content

Day 1 – Microsoft Word
Getting Started with Word
• Navigating the Word interface
• The ribbon and commands
• Help and ‘tell me what you want to do’
• Creating new documents
• Saving and updating an existing document

Navigating, Entering, Deleting and Selecting Text
• Moving around a document
• Inserting and deleting text
• Techniques for selecting text

Formatting
• Formatting text
• Copying formats with the format painter
• Paragraph alignment and line spacing

Editing and Proofing Tools
• Cut, copy and paste techniques
• Automatically correcting errors
• Correcting spelling and grammatical errors
• Using the thesaurus

Tabs, Indents, Bullets and Numbers
• Creating, modifying and deleting tab stops
• Indenting text
• Moving and removing indents
• Bulleted and numbered lists
• Applying automatic bullets and numbers

Changing Page Layout
• Adjusting page margins
• Landscape and portrait orientation
• Inserting page breaks
• Inserting page numbers, headers and footers

Viewing and Printing Documents
• Changing view and zoom settings
• Using print preview features
• Printing a document

Day 2 – Microsoft Excel
Spreadsheet Basics
• Spreadsheet concepts
• Exploring the Excel window
• Working with the ribbon and commands

Navigating, Selecting and Entering Data
• Creating, saving, opening and closing spreadsheets
• Moving around a spreadsheet
• Entering, editing and deleting data
• Using Auto Fill and Flash Fill
• Creating custom lists

Editing Data, Columns and Rows
• Inserting and navigating worksheets
• Inserting and deleting rows and columns
• Adjusting column widths and row heights
• Showing and hiding columns and rows
• Cut, copy and paste techniques

Formatting
• Formatting text and sizes
• Aligning text horizontally and vertically in cells
• Applying number and date formats
• Formatting cells with background colours and borders

Basic Formulae & Functions
• Using formulas to add, subtract, divide and multiply numbers
• Using the AutoSum function
• Working with relative and absolute cell references

Data Lists Essentials
• Introducing data lists
• Freezing worksheet titles
• Sorting a list of data
• Filtering data using Auto Filter

Page Setup and Printing
• Using print preview
• Changing page layouts
• Changing and applying print options

Day 3 – Microsoft Outlook
Outlook Essentials
• Overview of Outlook
• Using the folders pane and navigation bar

More About Email
• Working with the reading pane
• Checking spelling and grammar
• Working with file attachments
• Using send options
• Recall and resend messages
• Working with message flags
• Email signatures
• Email tips and tricks

Managing Mail Folders
• Mail folders revision
• Search techniques and search folders
• Working with conversations
• Default and custom archive options
• Retrieving archived items
• Mailbox clean-up tools

Rules and Auto Assistants
• Creating inbox rules
• Automatic replies (out of office assistant)
• Setting out of office rules
• Creating and running quick steps

Using the Calendar
• Tips on viewing and navigating the calendar
• Customising the working week
• Appointments and events
• Planning meetings and responding to meeting requests
• Arranging meetings with calendar groups

People
• Creating, editing and deleting contacts
• Creating and using contact groups

Folders and Permissions
• Sharing Outlook components
• Opening other people’s email, calendar, tasks and contacts
• Setting permissions and delegation rules

The Task List
• The power of tasks
• Recurring tasks
• Assigning, updating and tracking tasks