Administrative Staff

Assessment Co Ordinators

Bursars And Business Managers

Pastoral Officers

Sencos

Senior Leaders

Teachers

Technical Staff

MICROSOFT OFFICE EXCEL 2016 – PART 2

 

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.