Budgeting with Microsoft Excel
Part 1 - Excel Basics

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 you’ll learn the basic skills you need to create a budget in 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.

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

Basic Excel Controls

  • Groups
  • Tabs
  • Command
  • Quick access toolbar

Excel Functions

Making an Excel Budget

Adding Formulas

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

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

*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