Budgeting with Microsoft Excel
for Tribal Organizations

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