Lightbulb

This course is designed to build professional level skills using MS Excel 2010 to create sophisticated and automated spreadsheets to analyse and display data.

Entry Requirements

Students will require a basic level of computer skills and some experience with MS Excel is essential.

Student Instructions

Please bring a 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:
Basic Excel 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 2:
Charts

• Create
• Modify
• Format

Page set up

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

Printing

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

Lesson 3:
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 4:
Functions

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

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 Excel

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
Charts

• Create
• Modify
• Format

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

This course is designed to build professional level skills using MS Excel 2010 to manage messages and for time management.

Entry Requirements

Students will require a basic level of computer skills and some experience with MS Outlook is essential.

Topics

The below lessons are structured around 3 hours sessions.

Lesson 9:
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:
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

This course is designed to build professional level skills using MS Excel 2010to create and deliver professional presentations.

Entry Requirements

Students will require a basic level of computer skills as well as an Intermediate level of understanding in Word. This 3 hour course is intensive and the pre-requisites are essentials to gain full benefit of this course.

Topics

Lesson 1:
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

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

This course is designed to build professional level skills using MS Word to create advanced level documents.

Entry Requirements

Students will require a basic level of computer skills and some experience with MS Word is essential

Student Instructions

Please bring a 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:
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:
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:
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

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 Word

Organise and retrieve data effortlessly using Access databases. Learn the basics including tables, reports and queries. Sound computer knowledge required.

Entry Requirements

a solid understanding of computers is essential

Student Instructions

Pen and paper for note taking. Optional but highly recommended – a Memory stick/USB flash drive as this is the most efficient way of saving and retaining your work.

Topics

Working with Database objects including table, query, form and report
Managing data, relationships and primary keys
Creating and customising queries, creating and customising forms, creating useful reports.
Setting field properties and optimising relationships

Career Prospects

office work

Delivery Style

Teacher instruction, followed by independent student work using a text book. This course is information based and designed to cater to a wide range of learner needs. It is predominately self paced with facilitator assistance.

Outcomes

Students will gain basic knowledge and skills in producing an Access database

Microsoft Excel is the most popular spreadsheet application in use today. This course is an introduction to creating, formatting and printing basic spreadsheets such as budgets and lists and includes converting your spreadsheets into basic charts. Basic Computer knowledge is essential.

Two course Special Offer

Enrol in both the MS Excel 2007 Essential and Advanced courses and receive a discount of $25. Contact the office on 5581–8301 or enquiries@lightbulb.edu.au to take advantage of this offer!

Entry Requirements

Basic Computer knowledge; able to use Windows XP for File management

Student Instructions

Bring a blue or black pen, pencil and writing paper. A Memory stick/USB flash drive for saving your work and taking your files home.

Topics

What are spread-sheets, Excel orientation, selecting ranges, create formulas, functions, copying and filing, create and modify charts, printing.

Career Prospects

help gain employment in an office situation.

Delivery Style

An easy to follow manual with appropriate activities for each topic is used, together with Excel computer software. This course is information based and designed to cater to a wide range of learner needs. It is predominately self paced with facilitator assistance.

Outcomes

Students will gain confidence learning the basics of Excel. Students are awarded a Certificate of Attendance, if they have attended 80% or more of the course.

MS Advanced Excel is for those looking to take their Excel skills to the next level. This course will suit data driven professionals using complex level spreadsheets in their daily work, and looking to become an advanced level user.

Entry Requirements

Students must have a solid base of experience in using MS Excel either in 2007 or 2010 versions, and should be able to create new spreadsheets from scratch, apply high level formatting and intermediate functions and features of excel.

Student Instructions

Please bring a blue or black pen, pencil and writing paper, highlighter pen, A Memory stick/USB flash drive for saving your work and taking your files home.

Topics

Lesson 1:
Tables

• Apply table styles
• Create calculations
• Insert, delete rows
• Resize a table
• Convert to a range
• Sort

AutoFilter

• Apply a filter
• Customise a filter

Advanced Filter

• Criteria range
• Use autofilter

Database Functions

• Sum, max, min, count

Lesson 2:
VLookup

• Vlookup
• Exact vs closest match lookup

PivotTables

• Create a PivotTable
• Arrange information
• Filter
• Calculated fields
• PivotTable options
• PivotChart

Lesson 3:
Protection

• Protect worksheet
• Unlock cells
• Protect workbook

Decision making tools

• What If Tables
• Scenarios
• Goal seek
• Solver
• Comments

Lesson 4:
Sharing workbooks
Macros

• Recording macros
• Assigning macros
• Running macros
• Where to edit code
• Relative macro

Exporting, importing data

Career Prospects

help gain employment in an office situation

Delivery Style

An easy to follow manual with appropriate activities for each topic is used, together with Excel computer software. This course is information based and designed to cater to a wide range of learner needs. It is predominately self-paced with facilitator assistance.

Outcomes

At the completion of this course you will know about the more advanced features and techniques of Excel

Build on your basic Outlook knowledge. Learn how to get the most out of calendars, organise contacts and other personal information, manage your time and activities and manage junk mail. Give a professional look to your customised emails for both business and personal communications. Basic working knowledge of Outlook is necessary.

Entry Requirements

Basic Computer knowledge; able to use Windows XP for File management and a working knowledge of Outlook basics

Student Instructions

Bring a blue or black pen, pencil and writing paper

Topics

Getting familiar with Outlook basics like creating and sending electronic mail, receiving and reading messages, working with attachments, working with messages and printing before moving onto working with contacts, using the address book and distribution lists, scheduling events, working with the calendar, basics of meetings, tasks, notes and journal entries, ‘out of office’ assistant, stationery, personalised signatures and automated replies, manage junk mail and SPAM’s

Career Prospects

help gain employment in an office situation

Delivery Style

An easy to follow manual with appropriate activities for each topic is used, together with Outlook computer software. This course is information based and designed to cater to a wide range of learner needs.

Outcomes

With this knowledge of Outlook you will be able create and organise contact information, create a distribution list, schedule appointments and events, manage and organise activities within the calendar, avoid annoying junk emails, record, track and organise your activities, give a professional look to your customised emails.

PowerPoint creates professional presentation of ideas and reports. Sound computer knowledge is required.

Entry Requirements

Must have basic computer knowledge

Student Instructions

Student to bring pen and notebook. A Memory stick/USB flash drive for saving your work and taking your files home.

Topics

• Using PowerPoint create professional presentations for your ideas and reports.
• Integrate publications for a professional approach to animated slide shows
• Learn how to automate a show.

Career Prospects

Not applicable

Delivery Style

This course is information based and designed to cater to a wide range of learner needs. It is predominantly self-paced with facilitator assistance. You will use PowerPoint 2007 software.