Administrative Staff

Assessment Co Ordinators

Bursars And Business Managers

Pastoral Officers

Sencos

Senior Leaders

Teachers

Technical Staff

Excel Part 1

Elements of The Excel Interface

Create a Basic Worksheet

Create Formulas in a Worksheet

  • The Formula Bar
  • Elements of An Xcel Formula
  • Common Mathematical Operators
  • The Order of Operators
  • Insert Functions in A Worksheet
  • The Functions Library
  • Common Functions in Excel
  • Formula Autofill Feature
  • Reuse Formulas

Cut, Copy and Paste

  • Paste Special Options

Relative and Absolute Cell References

Modify A Worksheet

  • Edit Data in A Worksheet
  • Column Widths and Row Heights
  • Hide and Unhide
  • Insert, Manipulate and Delete Cells, Columns and Rows
  • Format Worksheets
  • Modify Fonts
  • Add Borders and Colours to Cells
  • Apply Number Formats

Printing Workbook Contents

  • Define Page Layout for Printing
  • Header/Footers
  • Print Titles
  • Scaling Options

Manage Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Repositioning Worksheets
  • Inserting/Deleting Worksheets
  • Worksheet References in Formulas
  • Managing the View of Worksheets and Workbooks
  • Freeze Panes Command
  • The Split Command

Use the Help System

Attendance:  Full day 9.30 – 15.30

Cost: £170.00 per person SLA Rate

Feedback from our customers: (July 2018)

Learnt a lot of new things which will help with some of my jobs.
If you would to assess whether this level of course is suitable for your current level of experience, please complete the self assessment questionnaire.
To book a place on this course please complete the booking form and email to scomis@supportworks.devon.gov.uk.  Click here for the booking form.