How exactly do I use Microsoft Excel?

Question

Okay, I'm making a HUGE list of all the dvd's I own, and I'm putting them all in alphabetical order.
How do I do that on Microsoft Excel?
(The columns are confusing me).
:/

Answer 1

After you get the data entered you use sort which is under tools. It will let you decide how you which column you want sorted first second and third.

Answer 2

You want to think about how you want your info. For example, you might put the name of the dvd in Column A, the artist in Column B, and a comment about the dvd in Column C.



Now you have a bunch of info, in no particular order, but that's not a problem.



If you highlight cols A,B,C (by holding the shift key and clicking on the ABC headers), you can sort your data. Since I don't know your version of Excel, you may have to use the help to find what you need.



If you aren't using 2007, you could go to Data and then Sort. Then, if it were me, I'd sort first by column B (the artist) and then column A (the dvd name).



Now you have a sorted list that's easy to use.



If you have excel 2007, you do the same thing, but you'll have to find the sort function.

Answer 3

jsut type the name of the DVDs in the columns, then there is aicon with a A & Z with a down arrow, click that and it will order the DVD's in alphabetical order.

however Access (if you ahve it) is better for storoign DVD information, and has a tempalte for stroign DVD information (well it says VHS but as far as PC is aware there the same)

Answer 4

Dont.



Use Access and develop it right. If you search on line you may even find free DVD library databases that you can download and use.

Excel is a spreadsheet and if you library is HUGE then you most likely will end up frustrated with tracking your collection in it.

Answer 5

Select all the info you want to sort and then on the tool bar there shoudl be a icon that has an arrow and the letter A and the letter Z, click on it and it should sort.

Answer 6

Excel is in certainty for making tables and graphs, or using maths immediately. case in point, you are able to desire to persist with a million formula to a hundred numbers via typing the numbers into excel particularly than doing each and each in my view. For graphs and tables, it quite is effectively used to exhibit information. Excel became by and enormous designed to make information surprisingly plenty. specific you are able to desire to apply be conscious to make tables and graphs, yet Excel is greater extensive and greater basic to apply.