As a librarian, I just have to drop my two pennies in :-) I organize my books (not using Dewey Decimal) by author's last name. Those without an author I put first, such as encyclopedias and year books. Once they are in alpha order by author, I alphabetize by title. That way all the Alex Anderson books are together. I do use Excel to keep track of them using the same system on page 1. But I've also copied and pasted the list to a second "workbook" and put them alpha order by title. (All you have to do is click on the title column and then A-Z. Let the computer expand the list and they will be in perfect order.) By the way, don't include "a, an, and the" when it's the first word in the title. Last note: include the price on the Excel page: you'll be able to keep track of what you're spending on books.
I need to work on my magazines next.