Microsoft Excel 2007 Level 3

Learn Microsoft Excel 2007 Level 3 in our Aberdeen Training Centre on this 1 day tutor led workshop. This course is designed for those who use Excel on a regular basis or are fully conversant with Levels 1 & 2. This course shows some of the more advanced features and functions - features such as sheet/file linking and creating macros will show ways of reducing time spent on your worksheets.

Course Content

Data Validation

Auditing Data

The Auditing Toolbar

Trace Precedents

Trace Dependants

Clear Arrows

Circle Invalid Data and Remove Circles

Comments

Protection

Protecting a worksheet

Remove sheet protection

Protecting a Workbook

Remove the password for opening workbook

Pivot Tables and Pivot Charts

Scenarios and Goalseek

Scenarios

Goakseek

Consolidating Data

Macros