CLICK HERE for the Spreadsheet as Data Base Lesson in text format.
There are two videos for the Spreadsheet as Database Lesson.
The first covers setting up the database. Click Here to watch the first lesson.
The second lesson should be watched after you have set up your data base and entered data. It covers the method for using the CONCATENATE function to combine text fields and data and how to sort data. I also introduce the terms RELATIVE REFERENCE and ABSOLUTE REFERENCE and explain RELATIVE REFERENCE in some detail. Understanding the difference between relative and absolute references, when each is used, and how to designate a reference as an absolute reference (the default a relative reference) is essential to an understanding of spreadsheets. Click Here to watch the second lesson.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment