COURSE INFORMATION

The aim of the course is to enable you to understand the Excel environment and the popular tools used to create data in Worksheets.

  • Explore the Excel environment
  • Create and save workbooks
  • Enter data and simple formulas
  • Simple formatting

Getting Started with Excel

  • Exploring the interface
  • Create and save a new workbook
  • Open Files
  • Add basic data
  • Printing

Edit a Workbook

  • Select Cells and Ranges
  • Edit cells
  • Cut, Copy and Paste
  • Undo, Redo, Repeat
  • Find and replace text
  • Hide columns and rows

Basic Formulas

  • Formula Basics
  • Absolute vs Relative cell addressing
  • AutoFill series
  • SUM and AVERAGE
  • MIN, MAX and COUNT

Basic Formatting

  • Format Text
  • Align and Merge cells
  • Format Numbers and Dates
  • Borders and Background colours
  • Format Painter
  • Row Heights
  • Column Widths

Manage Worksheets

  • View Worksheets
  • Move or Copy Worksheets
  • Insert, Rename and Delete Worksheets
  • Freeze Rows/Columns
  • A sound knowledge of using a mouse/keyboard and navigating through windows and folders is recommended.
  • ¬£195
  • Microsoft Excel - Intermediate¬†
  • 1 day trainer led or virtual