Introduction to Microsoft Excel

Course Overview

Duration: 1 Day
Pre-requisites: Delegates should have attended a Windows course or have been using Windows for a reasonable length of time. Some typing skill would be an advantage. Some experience of spreadsheets would be useful
Aimed at: First time users of Excel for Windows existing self taught users wishing to gain foundation skills. Although an introduction course the delegate will be given many tips and shortcuts to enable them to gain confidence and use the application more effectively.
Objectives: On successful completion of the course delegates will be able to use Excel for Windows to produce professionally formatted spreadsheets with calculations.

Course Content:

Lesson 1: Excel Basics

  1. Concepts of worksheets and workbooks.
  2. The excel screen

Lesson 2: Creating & Editing a Worksheet

  1. Navigating with the mouse and keyboard
  2. Selecting cells with the keyboard
  3. Rows and columns
  4. Scrolling through your worksheet
  5. Creating a new worksheet
  6. Editing your worksheet

Lesson 3: Saving Your Work

  1. Saving your work

Lesson 4: Introduction To Formulae

  1. Simple formulae in Excel
  2. Using values to calculate
  3. Creating a formula using a cell address
  4. Working with autosum
  5. Exercise:

Lesson 5: Formatting Cells

  1. Formatting cells
  2. Formatting text
  3. The currency format command
  4. Format painter
  5. Exercise:

Lesson 6: Introduction To Relative Cell Addresses

  1. Relative addresses

Lesson 7: How To Cut, Copy And Paste

  1. Using copy and paste
  2. Moving cells (drag and drop)
  3. Exercise

Lesson 8: Filling Data And Series

  1. The fill command
  2. Custom lists
  3. Exercise

Lesson 9: Adding Rows Or Columns

  1. Inserting a column
  2. Inserting a row

Lesson 10: Filtering Data Using Autofilter

  1. Exercise

Lesson 11: Drawing A Chart

  1. Using chart wizard
  2. Changing the chart type
  3. Tips for charting
  4. Exercise

Lesson 12: Working With Multiple Worksheets

  1. Renaming a worksheet
  2. Adding a new worksheet
  3. Exercise

Lesson 13: Improving The Appearance Of Your Worksheet

  1. Adding a border
  2. Removing gridlines
  3. Using shading
  4. Changing column widths

Lesson 14: Printing From Excel

  1. Printing your spreadsheet
  2. Page Setup
  3. Scaling
  4. Customising the header and footer
  5. Changing the margins

Lesson 15: Exchanging Data With Word.

  1. Copying from excel to word

Further Training:

Excel for Windows Intermediate and Advanced.

The above is an outline intended as a guide only; topics may not be covered in this order. Actual course content will be tailored to suit client's needs.

Contact John Cowie on 0141 563 8200 to book your course, or use our enquiry form to send us a message.