Excel - Introduction


Learn the essential skills of using Microsoft Excel.

Once completed, students will be able to create Excel workbooks and worksheets, navigate around them, use time saving features such as AutoSum, AutoFill, create simple formulas and format worksheets.

1 Day

We assume you have an understanding of Microsoft Windows. You will have an ability to work with multiple windows and navigate the desktop, as well as having an understanding of computer file storage (i.e. drives, files and folders).

Course Contents

Getting to Know Excel

  • The Excel Workbook Screen
  • Using the Ribbon
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Understanding the Quick Access
  • Understanding the Status Bar

Creating a New Workbook

  • Understanding Workbooks
  • Typing Text, Numbers, Dates, Formulas
  • Making Basic Changes
  • Printing a Worksheet
  • Selecting Ranges
  • Understanding Cells and Ranges
  • Selecting Contiguous Ranges
  • Selecting Non Contiguous Ranges
  • Using Special Selection Techniques
  • Selecting Rows and Columns
  • Creating an Input Range
  • Understanding Data Editing
  • Overwriting Cell Contents
  • Clearing Cells
  • Deleting Data

Filling Data

  • Understanding Filling
  • Filling a Series
  • Filling a Growth Series
  • Creating, Modifying, Deleting a Custom Fill List

Formulas and Functions

  • Understanding Formulas
  • Creating Simple Formulas
  • Understanding Functions
  • Using the SUM Function to Add
  • Summing Non-Contiguous Ranges
  • Creating More Complex Formulas
  • What if Formulas
  • Common Error Messages

Formula Referencing

  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Creating Absolute References
  • Working With Live Preview
  • Changing Font, Size, Colours, Formatting
  • Using the Format Painter

Number Formatting Techniques

  • Currencies
  • Date Formats
  • Clock and Calculated Time


  • Understanding Borders
  • Applying Borders to a Cell, Range
  • Removing Borders
  • Drawing and Erasing Borders
  • Formatting the Drawing Pencil

Working With a Worksheet

  • Changing the Worksheet View
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting, Deleting Cells Into a Worksheet
  • Inserting Columns and Rows Into a Worksheet


  • Previewing Before You Print
  • Printing a Range
  • Printing an Entire Workbook
  • Print Options

Page Setup

  • Understanding Page Layout
  • Built in and Custom Margins
  • Centring on a Page
  • Changing Orientation and Paper Size
  • Setting and Clearing the Print Area
  • Using Page Break Preview
  • Setting a Background
  • Settings Rows as Repeating Print Titles
  • Clearing Print Titles
  • Printing Gridlines
  • Printing Headings
  • Scaling to a Percentage
  •  Fit to a Specific Number of Pages
Sorry… This form is closed to new submissions.