New data columns are created by copying existing columns and editing the heading. A one month report becomes a 12 month report with one copy command. You can use the spreadsheet to calculate sums, ratios, percents, or variances. Add graphs, titles and notes for a complete report. Analyze any balance down to individual accounts or individual transactions.
Most people do their budgeting in a spreadsheet because there is simply no better tool for the job.
The WGL formula allows for accounts to be updated on an individual basis. It requires the same parameters as F9's GL formula with the addition of a parameter indicating what value to write back. This will allow more flexibility in developing forms for the budget process. It consists of selecting values from the Wizard to act as the horizontal and vertical axes of your report. Press the Finish button and watch while F9 creates the report, complete with formatting, cell referencing and F9 formulas.