How would I make a YuGiOh card database in Microsoft Excel?

Question

How would I make a YuGiOh card database in Microsoft Excel?

Answer 1

Yugioh Card Database

Answer 2

Best answer search online. I know there is a way because I have seen it but I am not sure how. Try this:





http://www.techrepublic.com/article/create-an-excel-chart-that-automatically-updates-with-new-data/6064314

Answer 3

The best way to do this in Excel would be to have a "data table" sheet containing all of your cards (along with all relative info you need), and another sheet that summarizes the data table by using a Pivot Table, charts, and/or formulas:

Excel Tables http://office.microsoft.com/en-us/excel-help/overview-of-excel-tables-HA010342749.aspx?CTT=1

Pivot Tables http://office.microsoft.com/en-us/excel-help/overview-of-pivottable-and-pivotchart-reports-HP010342752.aspx?CTT=1



For lookups, you can use database functions to gather specific records:

http://office.microsoft.com/en-us/support/results.aspx?ctags=CH006252820

Be warned that many of these have peculiar methods of entry, and some are array formulas that must be entered with Ctrl+Shift+Enter.