By Tyler Kirk at May 13 2019 05:14:34
Using the Consolidation feature. You can determine whether or not the link will be interactive when creating the consolidation. This method provides the greatest level of detail in the summary worksheet. You can choose between any function, not just the sum function. For example, you could create an average of several divisions in a summary worksheet. Some of the disadvantages of this method are that the worksheets must be identical. Although it is not impossible, it is difficult to use consolidation across workbooks.
To know if you are on the right track with worksheets in your classroom, answer (honestly) these simple questions: _ Do my students groan when I hand out a worksheet? (The answer should be no.) _ Are my lesson plans based on worksheets? (The answer should be no.) _ Do I feel anxiety if I don't have worksheets copied? (The answer should be no.) _ Are students excited about learning in my classroom? (The answer should be yes!)