Spreadsheet Methods
From Compsci1
(Difference between revisions)
| Line 1: | Line 1: | ||
=Video Tutorials= | =Video Tutorials= | ||
[http://www.mediamax.com/compsci1/Hosted/macro.wmv video] tutorial on macro | [http://www.mediamax.com/compsci1/Hosted/macro.wmv video] tutorial on macro | ||
| + | |||
[http://www.mediamax.com/compsci1/Hosted/HLOOKUP.wmv video] tutorial on HLOOKUP | [http://www.mediamax.com/compsci1/Hosted/HLOOKUP.wmv video] tutorial on HLOOKUP | ||
Revision as of 17:03, 8 December 2006
Video Tutorials
video tutorial on macro
video tutorial on HLOOKUP
Book on Excel Spreadsheets
the first four parts have been uploaded on this link page the remainder will be upload asap(but prolly the weekend)
- preface
- Getting Started
- RECAPITULATION AND REINFORCEMENT
- UPDATING AN EXISTING SPREADSHEET
- MORE CHANGES TO THE APPEARANCE OF THE GRADEBOOK SPREADSHEET
- USING THE LOOKUP FUNCTION
- CREATING CHARTS BASED ON THE SPREADSHEET DATA
- PRINTING THE UPDATED SPREADSHEET
- MAKING A BACKUP COPY OF YOUR DOCUMENTS
- The complete pdf can be downloaded here File:Excel Book.pdf
