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

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