Microsoft Office. All the office productivity tools you need.

Master the MS Office suite and learn to share data between these applications. This short course will allow you to become productive by acquiring a basic understanding of Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook, for everyday professional use.

This course is designed for those who have some experience using a computer, but may not be familiar with this software.

Outcomes

By the end of this course, you should be able to:

• start Microsoft Office applications and work with the Microsoft Office interface
• create documents in Microsoft Word
• create workbooks in Microsoft Excel
• create presentations in Microsoft PowerPoint
• manage and search emails in Microsoft Outlook
• access and work with calendars in Microsoft Outlook
• work with and use contacts in Microsoft Outlook
• work with and use tasks in Microsoft Outlook
• share data between Microsoft Office applications
• understand Office 365 and the cloud
• work with Microsoft OneDrive to sync files
• work with Microsoft Office Online apps.

Content

Word processing in Microsoft Word

• Understanding word processing
• Creating documents in Word
• Starting Microsoft Word
• Using the blank document template
• Typing text into a document
• Saving your new document
• Typing numbers into your document
• Inserting a date into your document
• Making basic changes to your document
• Checking the spelling in your document
• Saving changes to an existing document
• Printing your document
• Safely closing your document
• Word processing quick reference

Spreadsheets in Microsoft Excel

• How spreadsheets work
• Spreadsheet functionality
• Starting Microsoft Excel
• Understanding workbooks
• Using the blank workbook template
• Typing text into a worksheet
• Saving your new workbook
• Typing numbers into a worksheet
• Typing simple formulas in a worksheet
• Easy formulas
• Typing dates in a worksheet
• Easy formatting
• Checking spelling in a worksheet
• Making and saving changes
• Printing a worksheet
• Charting your data
• Safely closing a workbook
• Spreadsheets quick reference

Presentations in Microsoft PowerPoint

• Understanding electronic presentations
• Starting Microsoft PowerPoint
• The PowerPoint screen
• Creating a new presentation
• Adding text to your presentation
• Saving your new presentation
• Adding more slides using the ribbon
• Typing directly into a slide
• Inserting clip art images
• Safely closing a presentation
• Opening an existing presentation
• Running a presentation slide show
• Printing audience handouts
• Presentations quick reference

Emails in Microsoft Outlook

• Navigating messages in a conversation
• Flagging messages in the message list
• Using instant search
• Search options
• Using a search folder
• Customising predefined search folders
• Creating a custom search folder

Calendars in Microsoft Outlook

• Understanding Outlook
• Starting Outlook
• Common outlook screen elements
• Accessing the calendar
• Changing calendar components
• Displaying specific dates
• Navigating within a calendar
• Scheduling an appointment using click to add
• Scheduling using the appointment window
• Creating recurring appointments
• Scheduling an event
• Printing your calendar
• Calendars quick reference

Contacts in Microsoft Outlook

• Understanding the contact form
• Understanding electronic business cards
• Viewing your contacts
• Creating a new contact
• Entering contact details
• Deleting an unwanted contact
• Printing contact details
• Contacts quick reference

Tasks in Microsoft Outlook

• Viewing tasks
• Creating simple tasks
• Typing tasks directly
• Changing task views
• Sorting tasks
• Completing tasks
• Deleting tasks
• Printing a task list
• Tasks quick reference

Sharing data between Microsoft Office applications

• Understanding data sharing
• Opening files in the documents window
• Using copy and paste
• Capturing the screen
• Drag and drop moving
• Right dragging
• Object embedding
• Updating an embedded object
• Object linking
• Updating a linked source
• Sharing data quick reference

Introduction to Office 365

• Working in the cloud
• What Is Office 365
• Office 365 versus Office 2016
• Office 365 apps and services
• Understanding Office online

OneDrive for Business

• Understanding and accessing OneDrive for Business
• Uploading files
• Syncing files
• Creating a new folder
• Editing OneDrive files
• Selecting and moving files in OneDrive
• Sharing files in OneDrive

Starting with Office online

• Understanding Office online
• Creating a new document
• Saving a document
• Opening an existing file
• Accessing desktop versions in Office online

Due to the comparative complexity of each application in the MS Office suite, the time spent on each application will vary and will be guided by participants’ needs.

Intended audience

This course provides an introduction to Microsoft Office. It assumes little or no knowledge of Microsoft software, however you must have some experience using a computer before attending.

Prerequisites

You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers.

Delivery mode

Face-to-face, presenter-taught training in a computer lab.

You do not need to bring your own device. Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.

Materials

You will be provided with a link to access and download your personalised eBook prior to class.