Excel Introduction

Date: September 2, 2019
Time: 09:30 to 16:00
Venue: Kings Hill
Package: Excel

Email to book this course

Pre-requisites

Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment.  Use of another Microsoft Office application would be beneficial.

Course Objectives

  • To understand spreadsheet terminology
  • To create a simple spreadsheet
  • To enhance the appearance of a spreadsheet
  • To print a spreadsheet

Course Contents

Introduction to Spreadsheets

  • Terminology – spreadsheet, workbook and worksheet

Getting Started with Excel

  • The Excel screen
  • Opening, closing and saving

Cells and Cell Ranges

  • Moving around a worksheet
  • Inserting/deleting rows, columns and cells

Entering Data

  • Entering Text and numbers
  • Editing cells

Formula and Functions

  • Creating and entering formula
  • Autosum
  • AVERAGE, MIN, MAX and COUNT
  • Relative and absolute cell references

AutoFill

  • Using autofill to create formulas, dates and headings

Moving and Copying

  • Cut/copy/paste
  • Drag and drop

Formatting

  • Text and numbers
  • Changing column widths and row heights

Printing

  • Previewing before printing
  • Changing the page setup
  • Page layout

Miscellaneous

  • Cell, worksheet and workbook protection
  • Freezing panes
  • Splitting windows

Copyright © 2015-2019 Vue IT TrainingWeb Design by fairly marvellous Kent