Register Button

Budgeting with Microsoft Excel
for Tribal Organizations

Date: October 21 - 22, 2020
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/Day
Tuition:   $849

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.

You asked, we listened! By popular request, we’ve created a brand new, in-depth class on budgeting with Microsoft Excel. You'll learn formulas and formatting tools that will help make developing, managing and presenting your budget a breeze. We’ll show you how to effortlessly manage data in Excel, use formulas to account for budget variance and carryover funds, automatically reconcile accounts, and easily track expenses and compare them to your budget. You’ll discover tools to help you accurately review and analyze financial data, helping you to avoid audit findings and comply with OMB guidelines and funders’ requirements. Plus, we’ll review best practices for password protecting, exporting, saving, printing and sharing your budget worksheets, including the latest options for sharing your budget in the cloud.

Creating and managing budgets doesn’t have to be a pain. Give yourself the tools to become a budgeting master – register for this exciting class today!

Perfect for office managers, department or program heads, administrative professionals, and anyone tasked with creating or monitoring budgets.

T O P I C S   I N C L U D E
Basics of Accounting
  • Essential terms and concepts
  • Cash vs. Accrual
  • Accounting functions: limiting liabilities, record-keeping
  • Finding your sources of revenue
  • Monitoring funds coming in
  • Understanding credits and debits
  • Tracking expenses:
    • Direct
    • Indirect
    • How to tell the difference
3 Essential Budgeting Tools
  • Income and expense statements
  • General ledger
  • Statement of cash flows
Why Use Excel?
  • Advantages and limitations
  • Excel vs. 10 key/paper
  • Excel vs. accounting software
Using Templates
  • Finding existing budgeting templates
  • Creating your own templates
  • How to import data
  • Time saving tips and tricks

Making an Excel Budget

Adding Formulas

  • Sum
  • Average
  • Max
  • Min
  • Absolute vs relative
  • Fixing and verifying formulas

The Watch Window Function

  • Inspecting, auditing or confirming formula calculations and results
  • Moving or docking the toolbar
  • Adding cells to the Watch Window
  • Removing cells from the Watch Window

Income and Expense Tracking

  • Designing an expense-tracking worksheet
  • Entering expenses
  • Creating a balance formula
  • Copying the balance formula
  • Conditionally formatting overages and carryforward funds

Financial Review and Preventing Audit Findings

  • Sampling data
  • Comparing actual expenditures to funding
  • Examining debits and credits

Designing Compelling Charts and Graphs

  • Illustrating projected budget vs. actual
  • Comparison to previous year
  • Forecast to outlook
  • Expense trends
  • Showing data trends with Sparklines

Pivot Tables and Formatting Data

  • Creating the budget database
  • Generating the pivot table
  • Drilling down on a balance
  • Breaking down by departments
  • Hiding and showing data
  • Hiding a column
  • Revising a budget
  • Printing the department budgets you created

Finishing Touches

  • Exporting
  • Printing
  • Password protection
  • Saving options

Cloud and Data Sharing Options

  • Sharing a workbook with multiple users
  • Sharing across devices
  • Setting sharing options
  • Tracking changes
  • Turning off sharing

*Topics subject to change.

Click here to find out how you can bring a Falmouth Institute seminar to your location!
© Copyright 2019 | Terms of Use | Privacy Policy