Falmouth Institute - Budgeting with Microsoft Excel Part 2

This class is not currently scheduled.

Budgeting with Microsoft Excel
Part 2 - Excel Advanced

Attend this LIVE, ONLINE TRAINING presented by our expert, who will be using all the interactive training tools used in the classroom and more. You’ll be able to ask questions, respond to polls, and collaborate with others. Don’t let anything interrupt your training needs. Join us online and experience a different way of learning! Please click here for Distance Learning FAQs.

In this 4-hour session, we'll discuss how to utilize Excel in conjunction with accounting software to integrate excel budgeting DIRECTLY with the underlying accounting software that has the actual revenue and expense transactions and data. We will also review tribal budget report formats and have a discussion of budget planning.

T O P I C S I N C L U D E

Budget Planning

Elements of planning
Outcomes-based review
Guidelines for a budget

Excel Budget Components

Budget versions - Best case, worst case, normal budget
Budget report with dollar variance columns
Percent of budget remaining columns
Monthly budgets, quarterly budgets, year-to-date budgets
SF24 federal grant budget format
Drawdown budgets for grants

In-House Accounting System Budget Features

New budgets based on actual costs
Export budgets to Excel
Budget drill downs
Allow department heads to run budgets in Excel

Excel DrillPoint Module

Uses of DrillPoint
Steps to building a spreadsheet in Excel DrillPoint
DrillPoint report

Microix/MIP Excel Budget Workflow

Budget module
Decentralize or centralize the budgeting process
Pre-load worksheets
Create budget worksheet for any time period based on any program, fund, grant, department, cost center or designation of your choice
Submit to a multi-level approval process
Excel export, import to Accounting Software MIP

*Topics subject to change.

Click here to find out how you can bring a Falmouth Institute seminar to your location!