Excel Module 3 – Data Management Techniques

Use partial absolute cell referencing

Use the formula auditing tools

Set cell protection

Name and work with named ranges

Use formulas to set conditional formatting

Create linked data validation lists

Use the VLOOKUP command

Use simple date and time functions

Start to work with macros

Review of absolute vs relative references

Using partial absolute referencing

Naming cells

Using range names in formulas

Finding named ranges

Using date functions

Using time functions

Calculating with dates

Formatting based on other column information

Using conditional formulas

Finding cells with conditional formatting

Naming lists

Linked data validation lists

Using the INDIRECT function

Constructing a simple VLOOKUP function to draw information from another source

Using HLOOKUP

Using the auditing facility

Tracing how formulas are made up

Tracing precedents and dependants

Evaluating formulas

Error checking

Showing formulas on a sheet

Setting cell protection

Locking and unlocking cells

Hiding formulas

Protecting a worksheet

Setting the level of protection

Protecting a workbook

Macro concepts

Recording macros

Example macros

Adding buttons to run macros

Customising your ribbons