Microsoft Office Beginning Excel Intermediate Excel Advanced Excel  

Objectives

Exploring Strategies

A document or spreadsheet can contain hundreds of words or cells that need to be modified.

 

You can use dependencies to make global updates. Tell the computer how to do it right, once, then let the machine track all of the updates.

 

Questions: Does Excel have a method for analyzing data that exploits dependencies?

2. Downloads

Samples

 

3. Assessment

Performance

Multiple Choice

 

Resources

Lesson Plan

Exercises

 

 

Sounds Good To Me Page 7

Absolute and Relative References

 

Work Smarter Not Harder Page 21

Create Filters, Subtotals

Use the Lookup Function

 

What Happened? Page 41

Analyze data with a PivotTable

 

   

Advanced Guide to Microsoft® Excel 2007