Microsoft Excel 1C: Lists: Auto-Fill Data in Columns, Inserting and Moving Columns

Creating a List / Small Database:

• Excel is great for keeping track of data typically recorded on index cards or lists.
• Example: instead of issuing an index card for students borrowing a school textbook, the names of students and numbers of books can be recorded in Excel.

Sorting:

• If the lists appear in an Excel spreadsheet you can quickly sort all students by last name, or alternatively you could sort the list by booknumbers.
• The last name sort would be good for generating a class list.
• The book number sort would be useful for generating an inventory list, which could be used to verify that all books are returned.
• If your list was very large, hundreds or even thousands of entries, you could use the search to quickly locate a certain student, student number or particular book number.

Autofill:

• Often you may have to enter in consecutive numbers as shown in the figure below. This can be a very repetitive task if you had to fill in numbers for lets say 5,000 books in a school.

figure 1a2

• With Excel you can create consecutive numbers in a column without having to key in each number seperately. This is a very time consuming benefit.

• While Excel is great for small databases, Microsoft Access is the program to use for more complicated applications.
• Microsoft Access is a very powerful program that can be used for example to keep track of all the grades, attendance, student pictures, locker combos, courses and personal history of students in a high school.

This website is copyright protected see contact page for details.