I would like to catalogue books, DVDs, articles perhaps using Excel. Can I download a free template or watch a tutorial to help me do this?
Thanks in advance
Dear cooksey, you can list down all the names under DVD, books and articles and then Index them in excel. You can also simply find the book or article by pressing CTRL+F and type in the name. It would take you the word tag.
You can also go into DATA>List> create list
From there you can go forward.
If that has helped you please press solved.
181 views
Usually answered in minutes!
thanx for this. I will try it. What I need is a bit more complicated as I want to be able to list where the items are and how many copies there are of each
hi..basically i have the same problem with cooksey..i wanna learn the fundamentals of excel,its related functions and others..i hope you can help me..thanks a lot
how can we spilt qty from one col in excel
×