Account

Document Sample
Account Powered By Docstoc
					Check Book
Note: Checks should be entered as POSITIVE values and Deposits as NEGATIVE.
Code List:

Beg Balance

1,408.47

Current Balance
Start here: V Filter Results Total of filter =

576.08
(832.39)

Date
01/19/03 01/19/03 01/19/03

Check #
2275 2276 2277

x
Jim Hatton Reeves Bollinger Ins

Payee

Amount
375.00 137.39 320.00

Code
11 9 10

Reason (optional)
send out registrations only 4 teams will need more.

Begin

To start go to any cell on row 8 OR within the checks entered area and click on Data>Form… Note: Checks should be entered as POSITIVE values and Deposits as NEGATIVE.

1 To see "comments" point to cells that have a little red triangle in the corner. 2 To Filter (find) a list of one type of Code select the commands: Data>Filter>Auto Filter use the drop down arrows to choose the criterion. To find a Date range: Data>Filter>Auto Filter Then open the drop down in the DATE column arrow and choose "Custom" Enter the date range you want. 3 To generate a sorted report: First sort the data by the code column Next click the Subtotals command under the Data group. You can remove them when you print the report. Then you can UNDO the command that sorted the data.

OPTIONAL THINGS

Save more than one toolbar configuration

If you frequently use a group of customized toolbars that are sized and arranged on the screen in a particular way, y

1. Make any changes you want to the built-in menu bar and toolbars, create any custom toolbars you want to save 2. Quit Excel. 3. Locate the file Excel.xlb. 4. Rename the file, retaining the .xlb extension.

To use a saved configuration again, click Open on the File menu and open the renamed file. When you next quit th

Data>Form…

onfiguration

d on the screen in a particular way, you can save the configuration so you don't have to redisplay and resize the toolbars each time you start

any custom toolbars you want to save, and then display the toolbars the way you want them to appear.

renamed file. When you next quit the program, Excel creates a new Excel.xlb toolbar settings file.

size the toolbars each time you start Microsoft Excel.

TYPE in YELLOW AREA. Enter or Adjust Codes below Codes: Description 1 Deposit Registration 2 Deposit Food Sales 3 Deposit Other 4 Exp. Equipment 5 Exp. Food 6 Exp. Dirt 7 Exp. Maitenance 8 Exp. Other 9 Exp. Porto-Johns 10 Exp. Insurance 11 Exp. Mailing 12 Exp. Office Supplies 13 14 15 16 17 18 19 20

Do NOT CHANGE these cells Code List: 1 Deposit Registration 2 Deposit Food Sales 3 Deposit Other 4 Exp. Equipment 5 Exp. Food 6 Exp. Dirt 7 Exp. Maitenance 8 Exp. Other 9 Exp. Porto-Johns 10 Exp. Insurance 11 Exp. Mailing 12 Exp. Office Supplies 13 14 15 16 17 18 19 20


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:24
posted:11/7/2009
language:English
pages:10