Register Button

Budgeting with Microsoft Excel
Part 2 - Excel Advanced

Date: April 8, 2021
Time: 12:30 p.m. EDT; 11:30 a.m. CDT; 10:30 a.m. MDT; 9:30 a.m. PDT; 8:30 a.m. AKDT
Duration: 4 Hours
Tuition:   $425 - Join us for this class and bring a colleague for 1/2 off!*

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 Virtual Training FAQs.

*This offer applies to new registrations. Both students must register at the same time and payment must be made at the time of registration. No other discounts may be applied. When registering online, please select 2104HALF from the registration form drop down list for the question, “How did you first hear about this product?” If registering by phone, please mention 2104HALF.

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!
© Copyright 2020 | Terms of Use | Privacy Policy