0
A pivot table in Excel is a summary table of the original spreadsheet. To create a pivot table, first open the original spreadsheet then remove any blank columns and rows. The columns also should have headings so as they will be carried over to the Field List. Next, format the cells properly for their data type. Highlight the data range of the spreadsheet. Click the Insert tab and select the PivotTable button from the Tables group. Select PivotTable from the list and double check the Table/Range value. Check the radio button for New Worksheet and click ok.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How to make table in excel-?
Here is a video tutorial http://www.videojug.com/film/how-to-create-tables-in-excel on how to make a table in Excel.
What is the use of time table in Microsoft Excel?
You can make a time table in Excel to show schedules of many things (trains, airplanes, etc.).
Why is Excel better than manually maintained tables?
It depends on the purpose for the table. If you make frequent updates, then excel is much better, but if you make a table one time, then it does not make much difference.
What three elements indicate an Excel table is created in a worksheet?
Header Row, Banded Row and Calculated Columns make up an Excel Table.
How can make school time table in excel by formula?
Easy
What is a nested table in Excel?
It is a table inside another table.
Can tables in Excel be used as tables in Word?
You can copy a table in Excel and paste it into Word. You will lose any formulas, but the resulting values will be retained. You can also link a Word document to a table in Excel, which will allow changes in the Excel table to be maintained in the Word document.
Which button formats data as a table in Excel?
In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.
A table in Excel is most similar to?
Sometimes it can be similar to a table in a database.
What is the breakpoint in Excel?
In excel it is the lowest value for a specific category or series in a lookup table.
In excel a grid of column and rows are?
table
Why do business use a data table?
Excel
