| <<< | Index | Important Topics >>> |
During weeks 8 and 9 you will work with Excel.
I've learned that some students have different editions of the textbook.
If you have the second edition of the textbook, Excel is covered in Chapter 13.
If you have the third edition of the textbook, Excel is covered in Chapter 14.
If you have the first edition of the textbook, Excel is not included in that textbook, however I am posting its content here.
Read through the excel chapter. The author provides some spreadsheet examples in the chapter. Consider entering and testing some these examples.
The best way to learn is to try it!
In addition to the book chapter, read through the material available through the below links:
Complete the and the Tutorials Excel 2003, or
and the Tutorials for Excel 2007. These are audio tutorials so if you have speakers, turn them up. If you don't want the audio, the words that are being spoken are also displayed in text. Each unit contains a number of different Excel related topics with some hands-on exercises on each topic. Completing these exercises will help you become more familiar with Excel and and some of its basic features.
Information regarding Excel conditional formatting:
- on You Tube!
- there's a link to a 4 minute tutorial (watch and listen) at the bottom of this page.
This article walks you through using conditional formatting using a cell address as well as using a formula's value. There are also other good examples of using Excel available from this link.
This document walks you through using the function wizard to use the PMT function for a loan calculation:
Mext document explains the difference between absolute and relative cell references. This topic is critical to understand. When entering a formula into a spreadsheet cell that you know you will later copy to other areas of the spreadsheet, having a solid understanding of absolute and relative references will be a major advantage:
Next link provides an alphabetical listing of all Excel's functions. You will be required to use some functions that may not have been included in the required readings. You can find more information on any Excel function from this site. You can also use Excel's Help feature to learn more about a particular function:
| <<< | Index | Important Topics >>> |