Excel

EXCEL BASIC - ONE DAY

Microsoft Office Excel training the way you need it, when you need it.

Description

 This is a 1 day beginner’s course which covers the basic functionality of Excel. At the end of the course, delegates will be able to create and amend simple spreadsheets and charts.

Pre-Requisites

No prior experience of Excel is required for this course, though delegates are expected to be familiar with a Microsoft Windows environment.

Course Content

Introduction to Microsoft Excel

  • Accessing Excel
  • Spreadsheet terminology
  • Creating a new spreadsheet
  • Entering text and numbers
  • Saving a spreadsheet
  • Retrieving a spreadsheet
  • Printing a spreadsheet

Working with Cells

  • Formatting cells - justification, borders, shading, number format
  • Deleting cells
  • Performing simple calculations on cells

Working with Ranges

  • Deleting and inserting rows and columns
  • Altering the width of a column/row
  • Autosum
  • Autofill

Charts

  • Creating a chart
  • Formatting a chart
  • Printing a chart

Page Layout

  • Margins and scaling
  • Headers and footers

Exporting Data

  • Exporting worksheets and charts into a Word document


Click here to download this course outline.