Administrative Staff

Assessment Co Ordinators

Bursars And Business Managers

Pastoral Officers

Sencos

Senior Leaders

Teachers

Technical Staff

Excel Part 1 – An entry level introduction for delegates with little of no experience of using Excel.

If you are unsure if this is the right course for you, please complete the self-assessment at the bottom of the page.  If you need further guidance please contact Scomis@devon.gov.uk or call 01392 385300

Elements of The Excel Interface – What is Excel, What does it do, how is it used.  An introduction to Excel and the elements you will be using on this course.

Create a Basic Worksheet – Open a Worksheet and populate with data.

Create Formulas in a Worksheet (performing calculations and other simple operations)

  • The Formula Bar – .Where to find the options for creating formulas. What is a formula?  Formulas can be simple, like adding two cell values, or quite complex, involving multiple mathematical operations
  • Elements of An Excel Formula – how to build a formula to do what you want to do in am excel Spreadsheet
  • Common Mathematical Operators – SUM, Percentage, etc.
  • The Order of Operators – How to build a formula so it works properly.
  • Insert Functions in A Worksheet – The purpose of a function is to provide you with an easy way to perform a complex calculation
  • The Functions Library – What functions are available to suit your needs.
  • Common Functions in Excel – The most popular and commonly used functions.
  • Formula Autofill Feature – How to use one formula on multiple sections
  • Reuse Formulas – Copy a formula from one section to another.

Cut, Copy and Paste – How to cut, copy and paste in Excel.

  • Paste Special Options – other ways of pasting.

Relative (Such references are flexible in that they change depending upon the position of the formula) and Absolute Cell References – (make sure a formula always references the same location, no matter where it is moved)

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 – knowing how to print data from your workbook is essential. In this topic, we will explore how to use the printing functionality in Excel.

  • Define Page Layout for Printing – setting the area for printing
  • Header/Footers
  • Print Titles
  • Scaling Options

Manage Large Workbooks – In this topic, we will learn all of the ways that you can format worksheet tabs. We will also learn how to manage worksheets and view worksheets and workbooks in different ways.

  • 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.