What is a pivot tables? How do you create a pivot table in Excel? What are some uses of pivot tables? What does it mean
to “pivot your data”? Give an example. How are filters and slicers used in pivot tables? What is a pivot chart? How do you
create a pivot chart in Excel? What is the purpose of creating a pivot chart from your pivot table? Do the Challenge
Exercises in the two modules below and report what your experience is like. Did you find it challenging? Did you find it
useful? Do you think you will use pivot tables and pivot charts in the future?
I
Finally, share your impression of the following:
|
What-tf Analysis
Goal Seek Tool
Office Productivity, Collaboration, and Security in MS Excel