Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%.
DESIGNED FOR
Accounting professionals using Excel for Windows
BENEFITS
- Be able to set up an in-cell drop down
- Discover the function that enables us to change formulas depending on the budget method
- Name cells and ranges
HIGHLIGHTS
- Major Topics: * Set up an in-cell drop-down list of budget methods * Change the calculations in the cells based on the selected budget method * Use names in worksheets
COURSE LEVEL
Basic
PREREQUISITES
Basic knowledge of Excel for Windows.
ADVANCE PREPARATION
None