Excel Introduction

• 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