Things You'll Need:
- DVDs
- Spreadsheet program
- Time
-
Step 1
Make a plan how you will present and record your DVD collection in a spreadsheet program. Take down notes on the relevant information you will put. The most obvious ones include the DVD title, year released, genre, rating, etc. You will use this information as fields or column headers where you input the appropriate information in every DVD you have.
-
Step 2
Open a blank worksheet in MS Excel. Work on the column headings based on the fields/column names that you have come up with.
-
Step 3
When you are done working on the columns, you are ready with the actual data entry. Gather your DVDs and start encoding the information into the appropriate columns. Input one DVD per row. This could take time depending on the number of DVDs you have.
-
Step 4
Initially save your work. This is a good practice especially if you are working on a computer with no backup power. Use a file name that you can easily recall and save it in a location where you can readily access it anytime. You will use it again in the future when you need to update the records.
-
Step 5
After you have recorded all the DVDs you have, work on formatting your worksheet to make it look presentable and appealing. You can add borders, shading, change the font, size and color, add background, use formulas, change the alignment, etc. It is up to you. Save your work again.
-
Step 6
Put back your DVDs to where you usually keep them. You now have a record of your DVD collection! Now, it’s easier for you to go thru them and find the information you are looking for. Likewise, you can keep track who borrowed some of your DVDs much easier.
Comments
Practicalnature said
on 12/21/2008 Great idea for keeping organized, thanks!
veryirie said
on 12/20/2008 Your organizational skills are truly impressive! :)
DianeD said
on 12/20/2008 I have some friends that can use this tip - thx