CogsDashboardaccessAccessibility

Angus College

Soon to be part of a new regional college, serving Dundee and Angus.

Microsoft Office Excel 2007 - Beginners/Intermediate

 We live in a world where technology is constantly changing, at Angus College we move with it.  The course gives you the opportunity to learn how to use Microsoft Office Excel 2007 effectively and efficiently.

Information
Course Content: 

 This course is designed to cover the following topic areas.  Delegates will be asked to complete a Training Needs Analysis to aid in the customisation of the course to accommodate the skills/knowledge of those attending.

 Creating and Manipulating Data

  • Insert data by using AutoFill.
  • Ensure data integrity.
  • Modify cell contents and formats.
  • Change worksheet views.
  • Manage worksheets.

 Formatting Data and Content

  • Format worksheets.
  • Insert and modify rows and columns.
  • Format cells and cell content.
  • Format data as a table.

 Creating and Modifying Formulas

  • Reference data in formulas.
  • Summarise data by using a formula.
  • Summarise data by using subtotals.
  • Conditionally summarise data by using a formula.
  • Look up data by using a formula.
  • Use conditional logic in a formula.
  • Format or modify text by using formulas.
  • Display and print formulas.

 Presenting Data Visually

  • Create and format charts.
  • Modify charts.
  • Apply conditional formatting.
  • Insert and modify illustrations.
  • Outline data.
  • Sort and filter data.

 Collaborating on and Securing Data

  • Manage changes to workbooks.
  • Protect and share workbooks.
  • Prepare workbooks for distribution.
  • Save workbooks.

Set print options for printing data, worksheets, and workbooks.

Target Group: 

This course is intended for candidates with the equivalent of less than one year of hands-on experience in efficiently utilising features of Microsoft Office Excel 2007.

Duration: 

This course is run over 1 full working day.

Certification: 

On successful completion students will receive an Angus College certificate.

Dates
Course Dates: 
13 September 2013
17 January 2014
25 April 2014
Cost: 
£125

Next Steps

Send to a friend

Places on Enterprise classes are subject to availability. You can apply in two ways:

Book By Phone

Please call Pauline McDonald on 01241 432722 to secure your place now!

Enquire Online

Enquiring online DOES NOT secure a place on the course. you will be contacted within the next few days to confirm if a place is available and discuss payment options with you.

Enquiry Form
Complete the form and we will call you.


Please Note

The description of the College’s courses in our prospectus and on our website represents the College’s aspirations as to what will be delivered. However, for various reasons, the courses actually delivered may be different.

For example:

  • funding for a course (whether from the Government or from the College’s charitable donations or other sources of income) may be reduced or withdrawn;
  • there may be insufficient interest in a course which means that it is uneconomic or unviable to deliver;
  • there may be a change to the College’s other resources, such as staff or accommodation, which affect the delivery of a course.

A change could involve the replacement of a course with a new course, variations to course content or structure, the merger of courses, or the withdrawal of a course. The College may make a change to a course for the reasons set out above, or for other reasons where it is reasonable for the College to do so. If there is a change to a course about which you have expressed an interest, the College will let you know as soon as possible.

By expressing an interest about a course to the College, you agree to these rules about changes to courses.