#1
|
|||
|
|||
Using excel to track video game collection - questions
Over the past year or so I've been meaning to finally create a database of sorts to track my game collection(retail boxed/digital games, guides etc). I'm moving within the month, and am in the process of packing everything up so now is my best time to create said database. To be blunt, I've used excel for very basic items but never a large database with multiple 'categories'. I have opened excel but that's as far as I got because I want to make sure the best way to go about this. My first thought-through was I'll have about 10 columns(all ofwhich I would like to be able to sort by). And about a thousand rows(one row for each individual item). My question is really about entering the data and 'locking the rows of info together'. Should I just start entering data from left to right(title/release/genre/etc/etc)? I assume there is some way to lock all cells in a row together which will make this possible? IE: so that I can sort each column and 'all the data' in that row gets sorted as well. In essence I need to know: -Is there any special way I should enter the data(special cell) or just start typing the data in in each cell then format later? -How do I lock each row of information together? So that each row is 'one entry' rather then a row of 10 columns -Any special way to create sortable columns? Or will just clicking the header and hitting sort work? Thanks in advance, and sorry for the noob questions - but I'll probably never ever use excel after this so I don't really want to invest in a book and video guides that cover everything.
|
#2
|
||||
|
||||
Welcome to the forum.
Excel isn't a very good database, but I guess it should be sufficient for your needs because you don't have much data, you're not worried about security and you don't have plans to create sophisticated queries to analyse the data. Yep, a good starting point would be to column headers across the first row and then you can start inputting your data. If you're feeling adventurous then you could look into using a table in Excel. In Excel 2007 there are a couple of ways you could use to sort your data. If you use a table then you will automatically get some filter buttons in the header row and you can use these to sort the data. Alternatively, if you want to use the Sort button on the Data tab, then just make sure you select all of your data before clicking on the button and Excel will understand that it needs to keep each row of data together. If you accidentally miss a column in your selection Excel will probably be clever enough to spot your mistake and it will ask you if you would like it to expand the selection to include the missing column. |
#3
|
||||
|
||||
Hi Slurpyga,
If you input the data for a given game on a single row, with one column for each of your categories, you can use Excel's filtering tools to display only those records that match the filtering criteria. You can also sort your data for a more permanent ordering. The only thing to ensure there is that all the data columns are selected for sorting. PS: With 1000+ games, I think you need to get out more
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Game Development | mic101 | PowerPoint | 0 | 03-06-2012 01:53 PM |
Game of Life VBA | lor | Excel Programming | 0 | 06-22-2011 12:32 PM |
Questions on making a form to track research; please help | Lacrosseboss18 | Excel | 3 | 03-13-2011 07:46 PM |
Making Jeopardy-like game - need assistance | darkskye | PowerPoint | 1 | 07-28-2010 06:35 AM |
Excel 2009-10 Video Tutorials?! | Zaur | Excel | 3 | 07-04-2010 03:43 AM |