Excel Introduction

Duration:

One Day

Aims:

This course is designed to give an introduction to the essential aspects of this powerful integrated spreadsheet product from Microsoft. It is entirely 'hands on' and those attending will gain a good basic understanding of spreadsheet production including formatting, editing and printing.

Prerequisites:

A basic understanding of PCs, use of a keyboard & mouse, plus knowledge of Microsoft Windows is required, gained either by previous experience or by attending an Apt Training course.

Introduction to MS Excel
  • What is a spreadsheet?
  • Starting Excel
  • The Excel screen
  • Menus and shortcut keys
  • Formula bar and name box
  • Sheet tabs and the status bar
  • Active cell, column and row headers
  • Moving around the spreadsheet
  • Exiting Excel
Spreadsheet Basics
  • Creating a new workbook
  • Data types
  • Entering and editing data
  • Deleting data
  • Undo / Redo
  • Selection techniques
  • Saving and closing a workbook
  • Opening a workbook
Cut, Copy and Paste
  • The clipboard
  • Using cut, copy and paste
  • Drag and drop
  • AutoFill
  • Custom lists
Entering Basic Calculations
  • Entering calculations
  • Editing calculations
  • Cell handle
  • Totals
  • AutoSum
  • Statistical functions
  • Fills
  • Custom Lists
Formatting the Worksheet
  • Working with columns and rows
  • Formatting toolbar
  • Number formats
  • Date and time formats
  • Alignment and orientation
  • Borders and patterns
  • Format painter
Printing
  • Print preview
  • Page setup
  • Page set-up
  • Headers & Footers
Working with Larger Spreadsheets
  • Splitting the screen
  • Freezing panes
Introduction to Charting
  • Creating a chart
  • Printing a chart