Discussion:
Dscuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used
We will be talking about "grouping worksheets";
WHAT IS A MAJOR FACTOR OF IMPORTANCE WHEN GROUPING OR "UNGROUPING" WORKSHEETS?
Remember, you when you make a change in "one" worksheet, it changes "EVERY WORKSHEET" in the "group" you have selected.
In other words what are some of the pitfalls to avoid when "grouping" worksheets?
WHAT IS THE DIFFERENCE BETWEEN A WORKBOOK AND A WORKSHEET GROUP?
WHY MIGHT YOU WANT TO GROUP WORKSHEETS? CAN YOU GIVE SOME EXAMPLES WHERE GROUPING SHEETS CAN BE HELPFUL?