Logo Picture

Tel: 0330 333 9 230 (Local Land Line Call Rate)

Computer1

Excel Introduction

This comprehensive introduction course in Excel teaches participants how to create and enhance spreadsheets, use charts, formulas and functions, and formatting a spreadsheet effectively. This 1-day Excel Introduction course will assist delegates to develop their skills in creating and formatting professional looking spreadsheets.

Who Should Attend

 

This course is designed for any delegates who would like to learn how to create, format a professional spreadsheet and learn how to use and create basic formulas and functions in a spreadsheet.

Course content

Course Content

• Screen layout & features

 

• Using workbooks & worksheets

 

• Navigating a spreadsheet

 

• Highlighting cells and ranges of cells

 

• Entering text and numbers

 

• Entering days and months using AutoFill

 

• Resizing rows and columns

 

• Inserting new rows and columns

 

• Calculations using AutoSum

 

• Font type – Font size – Font colour

 

• Bold - Italics - Underline

 

• Align: Left – Centre – Right – Merge cells

 

• Currency – Percentage - Decimals

 

• Creating cell borders

• Formatting cells as a date or time

 

• Using print preview

 

• Set up landscape & portrait

 

• Scaling – adjust a print out size

 

• Applying headers and footers

 

• Creating a new folder or subfolder

 

• Average, Maximum, Minimum and Count formulae

 

• Using absolute cell referencing

 

• Sort alphabetically or numerically

 

• Sort in Ascending or Descending

 

• Creating a simple graph or chart

 

• Format appearance & colour

 

• Adding legends & data labels

 

• Adding/removing data

 

• Changing the chart type

CLICK ON THE BUTTON BELOW TO VIEW COURSE DATES AT YOUR CHOSEN LOCATION

computer4

+ VAT

Booking Form Online Enquiry

Duration: 1 day

Venues: At your own offices or our luxury training venues in Cardiff, Langstone (Nr Celtic Manor), Bristol or Swindon (Please state your choice of venue when booking)

ONSITE TRAINING

FROM

£650 + VAT

   

Newport & Cardiff Bristol Swindon

PRICES FROM £150 + VAT

PER

DELEGATE