[skip to content]

Staff Development

MS Excel 2007: Part II (FULL)

Michelle Delgado, Microcomputing Support Analyst

Date: 6 February 2013Time: 11:00 AM

Finishes: 6 February 2013Time: 1:00 PM

Venue: Russell Square: College BuildingsRoom: E17

Type of Event: Workshop

Target Group:

This course is aimed at the user who has a basic knowledge of MS Excel and would like to learn some additional skills. Users must have attended MS Excel (I) or have some prior knowledge. Knowledge of Windows 2000/XP would be an advantage. Good keyboard & mouse skills are a requirement.

Course Content:

  • Copying data from other applications
  • Editing Multiple Worksheets
  • Subtotalling data
  • Linking worksheets
  • Applying Conditional Formatting
  • Using a worksheet to solve a problem
  • Single & Multi level sorts
  • Using Filters
  • Data Forms
  • Creating & using Range Names
  • Attaching Comments to a cell
  • Protecting Worksheet Contents & Objects
  • Unlocking Cells and Objects
  • Viewing & Setting File Properties
  • Using Password Protection

NB: Starting from September 2010, all Microsoft Office training courses will be provided in 2007 format.

To book you can apply for this course in one of three ways:

  1. Online using the Staff Development Online Booking Form
  2. By downloading a request form from the link on the right
  3. By email to staffdevelopment@soas.ac.uk