MS Excel 2007 - Part II
- Unit value:
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
