Introduction to Excel

09 June 2017
A course for those who would like to learn how to create and use Excel spreadsheets including creating formulas and charts. No previous knowledge necessary.

Early Bird discount available, if booked by 29th May 2017 - Just £110. Book Here.


Course Aims:

To obtain knowledge and understanding of entering data, editing, creating formulas and enhance the presentation of an Excel spreadsheet.

Course Content:

Introduction to Microsoft Excel

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

Working with Cells

  • Quick Tips & Techniques – Copying, Moving, Selecting, Cells.
  • Formatting cells - justification, borders, shading, number format, size, colour
  • Deleting cells
  • Performing simple calculations on cells using formulas (+, -, *, /)
  • Centre Headings Across Cells
  • Freezing Titles
  • Increasing/Decreasing Decimal Places
  • Percentage, Currency, Comma & Sort Buttons

Working with Ranges

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

Page Layout

  • Margins and scaling
  • Headers and footers
  • Printing: Gridlines, Column Headings, Formulas
  • Centering & Rescaling Worksheet on a Page
  • Fit Spreadsheet on One Page

Charts

  • Creating and Formatting chart
  • Printing a chart
Date / Time
09 June 2017
GMT Daylight Time
Venue
Zetland Square Dundas St Richmond DL10 7BP UK

Advanced booking is required to attend this event.

  • Early Bird Rate: £110
  • Standard Rate: £195