If you have access to the exercise files for this course, you can put them on…your desktop as I have, or anywhere else you want.…The top folder contains subfolders for each chapter, which contain the…exercise files themselves.…If you do not have access to these files, you can follow along with your own…files as we proceed through the course.…
Resume Transcript Auto-Scroll
Author
Curt Frye
Released
6/16/2010
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.
Topics include:
- Tracking income and expenses by category and contract
- Using balance sheets
- Designing worksheets to assist decision making
- Creating income statements
- Calculating loans payments and interest
- Creating cell references to other worksheets
- Summarizing data in a chart
- Building alternative budget scenarios
Skill Level Intermediate
1h 3m
Duration
57,886
Views
Show More
Show Less
-
Introduction
-
Welcome1m 1s
-
-
1. Managing Cash on Hand
-
2. Calculating Loan Repayments
-
3. Budgeting Using Financial Statements
-
4. Managing Budgets
-
5. Defining Alternative Budget Scenarios
-
Summarizing scenarios2m 18s
-
Conclusion
-
Goodbye16s
-
Show MoreShow Less
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using the exercise files