Forum Discussion
what type of worksheet?
What kind of worksheet / formula / functions should I use? I want to make a document that lists books, and can be sorted by title, author, date added to list, reader rating, and have some color codi...
Use a standard Excel table. They can be sorted based on any of the columns, singly or in combination.
The attached is a starter. Don't worry about color coding at this stage of your learning. Once you've learned the basics, do some research on Conditional Formatting.
All of the blue highlights in this reply are hyperlinks where you can continue learning. But you'd do well to go get a book on Excel basics.