Forum Discussion

Birdy2019's avatar
Birdy2019
Copper Contributor
Feb 14, 2024

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 coding.  New data will be added regularly.  What kind of table or spreadsheet or worksheet should I use?  

  • mathetes's avatar
    mathetes
    Silver Contributor

    Birdy2019 

    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.

Resources