Hopefully, now you have an idea of why Pivot Tables are so awesome. It’s so simple, you may as well take a few minutes and show your boss how to do it himself. Within seconds, a Pivot Table will answer all these questions (as you’ll learn below).īut the real benefit is that it can accommodate your finicky data-driven boss by answering his questions immediately. This is where Excel Pivot Tables comes in really handy. You’ll have to go back to the data and create new formulas every time there is a change. You can go ahead and use Excel functions to give you the answers to these questions, but what if suddenly your boss comes up with a list of five more questions.
0 Comments
Leave a Reply. |