Have a Question ?

Home / Answered Questions / cis360 / cis-360-assignment-excel-pivots-and-charts-q-307

(Solved): CIS 360 assignment :Excel Pivots and Charts...


CIS 360 assignment: Excel Pivots and Charts

Pivot Tables and Charts
Introduction
Excel allows you to create cross-tab (or cross-tabulation) analysis in what it calls a Pivot Table.
Pivot tables can be one, two or three-dimensional. You can use multiple statistical analysis and summary options tools. You can include data from multiple worksheets, and you can modify them dynamically.
Creating a Pivot Table
1. Open ExcelPivotsWorksheetCIS360.xlsx, found on Canvas.
2. Click on the Expenses tab.
3. Click on cell A2.
4. On the Insert tab click on the [PivotTable] button.
5. The Create Pivot Table box opens:



We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $20 / Month