Excel Introduction

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

Computer1

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.

computer4

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

Course Content

• 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