Using Microsoft Excel (Intro/Intermediate)

Suitable for beginners and those wishing to improve their confidence with using Microsoft Excel.

This workshop will look to cover:-

Spreadsheet Principles

  • What is a spreadsheet?
  • Understanding Workbooks,
  • Worksheets, Rows,
  • Columns, cells
  • Various selection techniques
  • Zoom Feature
  • Page Layout View
  • Full Screen View
  • Access Keys (Shortcut keys)
  • Saving, File types, File Compatibility (with earlier Versions)

Data Entry

  • Entering , Editing and Deleting information in cells (Text, Date, and numbers)
  • Deleting Rows, Columns and Cells
  • Inserting Rows, Columns and Cells
  • Inserting , Deleting, Moving, Copying and Renaming Sheets

Creating Formulae and Functions

  • Concept
  • Creating Formulae
  • Editing Existing Formulae
  • BODMAS: Mathematical Order
  • Copying Formulae
  • Using the Autosum Feature
  • Common Basic Functions : SUM, MIN, MAX, AVERAGE, COUNT, COUNTA
  • Using the Formulas Tab

Formatting Cells, Rows, Columns and Sheets

  • Formatting Cells
  • Number Formatting
  • Date Formatting
  • Text Formatting
  • Cell Alignment And Orientation
  • Wrap text
  • Applying borders and shading
  • Changing Column Widths
  • Changing Row Heights
  • Sorting Data

Charts/Graphs / Printing

  • Creating Simple Charts
  • Editing Charts
  • Formatting Charts
  • Print Preview
  • Page Orientation
  • Adding Headers and Footers

Focused Practical Examples and Questions

Throughout the workshop, practical exercises will be given so that learners are able to to try out the features for themselves rather than just having a tutor lead chalk and talk session.

For enquiries please email