IT Courses - Intermediate Excel

Venue: Broomfield Hall
Hours: 7.00
Cost (£): 150.00

Course Overview

Validated by Derby College, this one-day workshop aims to further enhance the skills of intermediate Microsoft Excel users.

Course Content

The course covers the following topics:

  • Workbook and worksheet protection
  • Cell referencing
  • Using functions - including SUMIF; COUNTIF; COUNTIFS; and TODAY
  • Introduction to charts
  • Data tools
  • Excel tables
  • Cell linking within worksheets and workbooks
  • Sorting and filtering
  • Auditing and error checking
  • Using outlines
Check Available Course Dates & Book »