1. Create Pivottable: Using The Current Worksheet's Data - Create A Report That Displays The Quarterly Sales By TerritoryIn Cell G2 - Type "=F2/F$76" And Press The Enter Key.Click The Data Tab - Then Click The Text To Columns Button. Click The Next Button. Uncheck The Tab Checkbox. Click The Other Checkbox - Then Type ":" Into The Other Field. Click The Next Button. Click The Finish Button.Click Review Tab. Click The Spelling Button. Click The Change Button.Click The Insert Tab. Click Down The Tables Drop-down Menu - And Then The Pivot Table Button. Click The Ok Button. Click The Territory Checkbox. Click The Quarterly Sales Checkbox.
