Microsoft Excel Foundation

Microsoft Excel Training Courses in Glasgow, Edinburgh, Scotland, UKMicrosoft Excel Foundation Training Course Overview

This Microsoft Excel Foundation Training Course can be tailored to suit the unique demands of your business. Jemco can deliver training at the client’s premises if required, whether Glasgow, Edinburgh or throughout Scotland and the UK.

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:

See information on Excel for Windows Intermediate and Excel Advanced Courses.

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 0791 787 4739 to book your course, or use our enquiry form to send us a message.