Lightbulb

MS Excel 2010 - Intermediate

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