Most of the budget workbooks you create will have all the values you need…within that workbook.…However, if you want to draw values from other worksheets or workbooks, you can…do so by creating formulas that refer to those outside sources.…In this workbook, which I just have listed as a dashboard that I used to track…my balance sheet, I have my revenue for the year 2010.…I just typed value in.…You can see it's here on the Formula bar.…So, what if I wanted to bring in that data from another worksheet or…perhaps another workbook?…To do that, I need to create a formula that refers to that other cell.…
Here is how you do it.…First is you delete this value and then you type in equal sign.…If the value you want is on another worksheet in the same workbook, then you can…simply click that other worksheet's tab, in this case, LocalData.…The number that I want is my revenue that's here.…You can see up in the Formula bar that Excel is creating the formula for me.…I have =LocalData!C15.…Let me talk about this reference for a second.…
Author
Released
6/16/2010- 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
Duration
Views
Related Courses
-
Excel 2007: Financial Analysis
with Curt Frye2h 18m Intermediate -
Excel 2007: Introduction to Formulas and Functions
with Curt Frye2h 26m Intermediate -
Excel 2007: Business Statistics
with Curt Frye4h 19m Intermediate
-
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
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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: Referring to cells from other worksheets and workbooks in formulas