Skim section $3\mathrm{.}1$ Introduction to Data Visualization. If you$$re not familiar with treemap charts or multi$-$level sorting, take a look at those sections. Make note of Figure $3\mathrm{.}12$ which shows how to sort by month name or weekday name.

Open the file Data Analytics Project $1\mathrm{.}21.$xlsx$.$ You won$$t need to submit this file as a deliverable. Work through $3\mathrm{.}2$ Introduction to PivotTables and PivotCharts. As you read, you$$ll notice links to skill refresher videos. They aren$$t required, but are helpful for learning and reinforcing skills.

PivotTables are among the most valuable features in Excel. More practice is better, even if you$$re already proficient. As you work, keep track of things you$$ve learned that were new, or skills you already knew, but find particularly valuable. As always, I$$ll ask you to reflect on your learning at the end of this assignment.

When you get to the section on Sorting a PivotTable and Figure $3\mathrm{.}17,$ there$$s an easier way if all you want to do is sort one column. You can right click anywhere in the column and choose sort from the menu.

You are allowed to discuss this assignment with classmates or even to work through the assignment together. However, you are not allowed to work on a single worksheet or Excel file$$each student must complete their own version. Submitting two copies of the same file is not allowed.

In Figure $3\mathrm{.}16,$ numbers don$$t have commas. Explain the process for reformatting the Grand Total column from within the Pivot Table.