How do I set up a spread sheet in excel

[Insurance Claim]

I know nothing About spread sheets. I just need 4 columns and 1 row. The
row will be dates. columns will be location, milage , process and doctor.
I will need to total the milage at the bottom of the spead sheet. I
understand there are different codes for entering certain data.

 

[Roger Govier]

Hi

Enter the following in the cells
A2 Date
B2 Location
C2 Mileage
D2 Process
E2 Doctor

In cell C1 enter
=SUBTOTAL(9,C3:C10000)

Place cursor in cell A3 and choose Windows>Freeze Pane
This will keep you headings in place as you scroll down the screen.
Enter your data in each row from row 3 onward, and your total mileage will
appear in cell C1.

I have suggested the use of the Subtotal function, rather than Sum, in case
you want to have totals by Doctor or by location.
If so, then select cells A2:E2>Data>Filter>Autofilter
Then when you have data entered, you can use the dropdown on the cells to
select any location or Doctor, and you will see a filtered set of results
for that choice, and the mileage will be the total for that selection.