Microsoft Excel - Intermediate

Who should attend

This course is suitable for existing users who already possess A basic knowledge of Excel.

Aim of the course

To build on existing skills

Benefits to the employer

Investing in your staff will build confidence in using IT and will Improve productivity and efficiency.

Benefits for the attendee

Improvement of IT skills and knowledge ensuring you are more Competent and confident.

Outline programme

Review of basic skills

· Consolidation exercise

Format worksheets

· Rotate and indent text

· Vertical alignment

· Text wrap options

· Decimal places

· Merging cells

· Use Format Painter

· AutoFormat

· Apply colour and style borders

· Apply backgrounds

· Custom number formats

· Conditional formatting

Worksheet options

· Comments

· Freeze panes

· Advanced printing

Sorting data

· Sort ascending / descending

· Multiple-column sorts

Functions

· Basic functions

· IF statements

Cell referencing

· Absolute / relative referencesNamed ranges

· Define and use Names

· Use Names in calculations

Linking

· Link data

· Embed Excel objects

· Link Excel objects

· Hyperlinks

Charts and drawing objects

· Change chart type

· Change source data

· Custom charts

· Trend lines

· Use graphics in charts and worksheets

Filtering data

· Use Autofilter

· Custom filters

Templates

· Use Excel templates

· Create templates

Import and export data

· Import data to Excel

· Export data from Excel

· Publish worksheets and workbooks to web

Progression

Microsoft Excel Advanced or explore the benefits of using other Office applications including Access, Word, Powerpoint, Photoshop, Dreamweaver or Project.