From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Calculating formulas across worksheets - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Calculating formulas across worksheets
This workbook has data in four different worksheets and you can see down on the bottom, we have worksheets for different regions of the company, North, South, East and West. We can see up here it tells us also what region we're in and let's just click on them. So click on the South region and click on the East region and click on the West region and you see each of these are almost identical. The only thing that's different is the data. The columns are the same, the rows are the same, everything is the same. And this is important because when you do a workbook that has multiple sheets of the same type of data. It makes it a lot easier on you to make sure that they are consistent. By the way, the shortcut to move from one worksheet to another, you could press Ctrl+Page Down to get to the next worksheet and Ctrl+Page Up to go to the previous worksheet. Well let's do something useful here. You see over here in Cell A13 it's says Bar soap. That really should say Bar soap four pieces, but…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.