Lightbulb

MS Office is an intensive course designed to build professional level skills using the most common Microsoft Office programs such as MS Word, Excel, Outlook and PowerPoint.
Through this course, students will learn professional skills using the Microsoft Office suit and become a proficient computer operator. By the end of this course, students will develop professional level skills in Microsoft Word to create advanced level documents; Microsoft Excel to create sophisticated and automated spreadsheets to analyse and display data; Microsoft Outlook to manage messages and for time management; and Microsoft PowerPoint to create and deliver professional presentations.

Entry Requirements

Students will require a basic level of computer skills and some experience using the above Microsoft Office programs primarily in being able to create new documents from scratch and apply basic level modifications and formatting to create simple projects. Computer skills – basics or equivilent knowledge is required.

Student Instructions

Please bring a twin ring folder (for manuals) pen and exercise book/paper for note taking. You will need a Memory stick/USB flash drive (512 Mb/1Gb is ideal) for saving your work and taking your files home to practice with.

Topics

The below lessons are structured around 3 hours sessions.

Lesson 1: Word 2010
Formatting paragraphs

• Alignment
• Indenting
• Bulleted and numbered lists
• Lines spacing
• Borders and shading
• Formatting the page

Page set up
Margins
Section breaks
Headers and footer
Print preview

Lesson 2: Word 2010
Tabs

• Setting left, right, centre, decimal and bar tabs
• Adjust tab position and type
• Tab leaders
• Delete tabs

Tables

• Insert a table
• Change column width and row height
• Insert and delete columns and rows
• Table styles
• Borders and shading
• Convert a table to text
• Convert text to a table
• Calculations

Lesson 3: Word 2010
Styles

• Applying character styles
• Applying paragraph styles
• Modifying styles
• Creating a table of contents

Automating features

• AutoCorrect
• Quick Spelling and Grammar
• Building Blocks
• Cover page

Lesson 4: PowerPoint 2010
Creating new presentations

• Create a new blank presentation
• Change slide layouts
• Using the normal view
• Using the slide sorter
• Bullets

Slide effects

• Apply slide transition effects
• Modify slide effects
• Animation effects
• Add sound and modify speeds

Lesson 5: Excel 2010
Basic skills

• Move, drag, copy
• Paste options
• Insert, delete rows and columns
• Insert, delete cells
• Rename worksheets
• Copy, move worksheets
• Hide, unhide worksheets
• Sheet background and tab formatting

Formatting worksheets

• Adjust column width and row height
• Hide, unhide columns and rows
• Freeze panes
• Split

Formatting cells

• Font type, size, colour, italics, underline
• Alignment and indent
• Wrap text
• Format as currency, date, number, text
• Borders and shading
• Table AutoFormat

Lesson 6: Excel 2010
Using Data Validation And Tracing Invalid Data
Using the VLOOKUP Function
Page set up

• Orientation
• Margins
• Alignment
• Header and footer
• Watermark

Printing

• Page breaks
• Print preview
• Page break preview
• Print settings

Lesson 7: Excel 2010
Protection

• Protect worksheet
• Unlock cells
• Protect workbook

Custom formatting

• Customized number and date formats
• Conditional formatting

Cell styles

• Apply, modify cell styles
• Apply themes

Data outlining
Range names
Working across multiple worksheets

• Select multiple worksheets
• 3D formulas
• Combine data
• Links

Lesson 8: Excel 2010
Functions

• PMT function
• ABS function
• Logical test
• IF functions
• Nested IF functions
• OR, AND and COUNTIF functions

Lesson 9: Outlook 2010
Email messages

• Read, reply forward messages
• Preview messages
• Print a message
• Attach a message
• Preview, open, save, remove attachments

Organising messages

• Add flags
• Assign categories
• Use conversations
• Change message views
• Search
• Filter
• Colour code messages
• Quick steps
• Create and use folders

Lesson 10: Outlook 2010
Calendars

• Share calendars by email
• Share calendars using MS Exchange server
• Calendar permissions
• Open a shared calendar
• Working with multiple calendars

Meetings

• Schedule a meeting
• Accept, decline, cancel meetings

Tasks

• Create a new task from multiple locations
• View, sort, prioritise tasks
• Organise tasks
• Assign tasks
• Share tasks

Career Prospects

Working in an Office environment.

Delivery Style

Teacher instruction, complemented by independent student work using a work book supplied as part of the course. This course is information based and designed to cater to a wide range of learner needs with facilitator assistance

Outcomes

Students will gain the ability to create and modify high level professional documents and apply sohisticated formatting in the MS Suite

A student quote . . . My understanding of Excel has increased greatly. The learning I have done in this course has given me confidence to keep going in my computer studies. PowerPoint is very enjoyable and I have learnt much that will help me in the future. – L Welsh

Location

Ashmore

Room

D.04.008 ASH

Room D.04.008
Fourth Floor
’D’ Block

Address

Corner Heeb St and Benowa Road Ashmore 4214

Show location map