Excel Introduction The Essentials



This one-day course is for those new to Excel or who have some experience editing data but are not confident creating calculations and charts.


By the end of the course delegates will be confident using the essential features of Excel to create, edit, format and print worksheets, construct simple formulas. Delegates will also be able to create basic charts; sort and filter data.


At the end of the course delegates will be able to:

  • Create, save, close, open and print worksheets
  • Apply page setups to print and read worksheets on screen and print out
  • Insert and delete rows or columns and move data
  • Use Excel’s SUM function to add up numbers automatically
  • Construct and copy formulae using relative and absolute cell references
  • Sort lists into order and filter to show only the data you need
  • Format the appearance and layout of numbers and text
  • Introduction to Charts and Graphs


Excel Introduction

  • The Interface and Workspace
  • Navigating a Worksheet
  • Understanding Excel Mouse pointers
  • Enter, Edit and Delete Data
  • The Undo and Redo command
  • Adjusting Column Widths
  • Autofill
  • Working with Ranges
  • Inserting/deleting Columns, Rows and Cells
  • Moving and copying data
  • Saving and file formats


  • Font formatting, borders and shading
  • Alignment of data, Wrap Text, Merge Cells
  • Number formats - Date, Currency and Text Formats
  • Clear Formats

Simple Calculations

  • Construct, edit and view formula
  • Write formula with both Relative and Absolute Cell References
  • Copy a formula
  • Good worksheet design

Introduction To Simple Functions

  • Generate statistics using SUM, AVERAGE, COUNT, MIN and MAX functions

Printing And Previewing

  • Setting up the printed page
  • Viewing and scaling Worksheet
  • Headers and Footers
  • Printing

Uunderstanding Worksheets

  • Inserting, deleting, renaming worksheets
  • Colour sheet tab
  • Move and Copy worksheets

Managing Lists

  • Sorting
  • Filtering


  • Types of Charts
  • Create and modify charts
  • Printing Chart

Show the next months in

Location Dates Time Price exc. VAT   Status
Contact Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This