Linking between worksheets in Excel
Not what you're looking for?
I have an accounting assignment in which I have to use an Excel spreadsheet template.
My problem is that in the spreadsheet I have been asked to LINK between the journals to the ledgers, to the Trial Balance, to the reports. What does this mean and how do you do it? I have attached the spreadsheet template I have to use for your convenience.
Purchase this Solution
Solution Preview
Linking means that the information you enter into one worksheet within a workbook will be the same information that will appear in other worksheets. For example, if you have depreciation on all of your worksheets as 27,000, then if you link all of the worksheets, the number will show up on all when you type in the number only on one. Then when you go back and start changing numbers you don't have to change it on all worksheets since they are linked. This also helps in calculations as it adds the information automatically when you enter it ...
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce