Administrative Staff

Assessment Co Ordinators

Bursars And Business Managers

Pastoral Officers

Sencos

Senior Leaders

Teachers

Technical Staff

MICROSOFT OFFICE EXCEL 2016 – PART 2 – Following on from Excel Part 1, delegates who use Excel regularly will learn ways to improve efficiency and outcome using simple tools and methods.

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

Revision (if necessary)

Formula Construction

  • Absolute/Relative Cell References
  • Applying Range Names
  • Adding Range Names Using the Name Box
  • Using the New Name Dialogue Box
  • Editing and Deleting A Range
  • Using Range Names in Formulas

Using Specialised Functions

  • COUNTIF
  • SUMIF
  • TEXT Functions
  • LOGICAL Functions
  • IF
  • Logical Operators
  • Nested Functions
  • AND, OR
  • DATE Functions
  • TODAY
  • NOW
  • Lookup Functions
  • VLOOKUP
  • HLOOKUP

Create and Modify Tables

Sort and Filter Data

  • Sorting Data
  • Advanced Filtering

Create Charts

  • Chart Types
  • Creating Bar, Pie, Line Charts
  • Adding A Trend Line
  • Resizing, Moving and Printing Charts
  • Creating A Chart Template

Customize Workbooks

  • Add Comments
  • Protect Files
  • Worksheet and Workbook Protection
  • Protect Worksheet Option
  • Protect Workbook Option

ATTENDANCE
Full day

Cost: £170.00 per person SLA Rate

If you are unsure whether this is the correct level of course for you, 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.