Find the Over- and Under-Budget Areas Previous Topic

Previous Page 		Next Topic

Next Page

You’ve rolled up account-by-account projections from several departments. Compare the projections to your target amounts: Can you correct some shortfalls by redistributing funds among accounts? Simply subtracting the allocations from the projections can show you the problem areas and the surplus funds.

Screenshot shows worksheet with sample budget figures.

Sort Ascending button Sort Ascending button

Tip Icon

 Sort it out   Do you have a large number of accounts? Sort them to view the largest shortages. Click a cell that contains a shortfall amount, and then click the Sort Ascending button.

Bar above and below the Sidebar

More Power: The 10 Most Wanted List

If you work with long lists of data, you can use the Top 10 feature of the AutoFilter command (Data menu) to display only the 10 largest values in a column. For more information, see Zero In on the Contacts You Want.

Bar above and below the Sidebar

Office Assistant button Office Assistant button

Cross Reference Icon

 Want to know more?   Look up Getting Results - Budgeting in Help.

Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>

©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.