We need a new table in which the difference is computed. Let’s look at the budget sheet (it’s the first in the workbook):Īnd compare it to the Actual Expenses sheet (the next one in the file): Imagine that your supervisor in the fictitious WYZ Widget Company needs you to calculate how much of the assigned budget was actually used ( you can find the file here). In this article, we’ll tackle this issue and see how we can access the contents of any worksheet. After a while, however, this is no longer enough, as we need to combine data from multiple sheets, or even from other Workbooks. When starting to use Excel, we use formulas to manipulate data from other cells in the worksheet.
