Microsoft Excel - Basic

Who should attend

This course is suitable for new users who want to learn some essential elements of Microsoft Excel.

Aim of the course

To improve and expand on your current IT 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

Introduction

· The Excel screen layout

· Task Pane

· Office Help

Create a spreadsheet

· Enter data

· Change column width

· Edit data

· Use Autofill

· Use Cut, copy and paste

· Undo and Redo

Format worksheets

· Horizontal alignment

· Number formats

· Font style, size and colour

· Apply borders

· Apply shading

· Bold and italic formatting

· Insert / delete columns and rows

Perform calculations

· Sum

· Multiply

· Divide

· Subtract

· Use Autosum

· Show formulas

Work with worksheets

· Rename worksheets

· Move, copy and delete worksheets

· Tab colour

Create charts

· Select source data

· Use Chart Wizard

· Format charts

Printing

· Insert Headers and Footers

· Page orientation

· Margins

· Print options

Progression

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