Lynda - Creating Business Budgets in Excel 2007

Lynda - Creating Business Budgets in Excel 2007

In Excel 2007: Creating Business Budgets Curt Frye shows business owners and managers how to use Excel to create useful budgets that help them manage resources prudently. The course demonstrates how to use Excel spreadsheets to track cash on hand, and how to project income and expenses based on scenarios. It also shows how to take information from various sources to create a single Excel table, and then use PivotTables to analyze that data. Exercise files accompany the course.

https://www.lynda.com/Office-2007-tutorials/excel-2007-creating-business-budgets/65719-2.html

Introduction

1. Managing Cash on Hand

2. Calculating Loan Repayments

3. Budgeting Using Financial Statements

4. Managing Budgets

5. Defining Alternative Budget Scenarios

Conclusion

Table of Contents

Would you like to be a Author?