Microsoft Office Beginning Excel Intermediate Excel Advanced Excel  

Objectives

Exploring Strategies  

The Excel Timesheet uses a reference cell to calculate how your time compares to a regular 40 hour week.

Did you work any overtime? If so, Conditional Formatting can make the cell big, bold and colorful...just in case your boss needed some help finding the right information.

Questions: Visualization helps focus on the relevant information. Does Conditional Formatting help you focus on specific information?

2. Downloads

Samples

 

3. Assessment

Performance

Multiple Choice

 

Resources

Lesson Plans

Exercises

 

Intermediate Guide to Microsoft® Excel 2007

 

 

 

   

Add Me To The List Page 7

Mail Merge with Excel

 

Working Overtime Page 27

Create a time sheet

 

Legs, Eggs, and Pigs in a Basket Page 51

Calculate Revenue