amphora f (genitive amphorae); first declension A vessel, usually made of clay, with two handles or ears for liquids; amphora; flagon, pitcher, flask, bottle, jar. A measure for liquids; quadrantal; the measure of a ship.
Create Your Pivot Table. Once you've opened the file, use your mouse to highlight the data that you wish to include in the pivot table. Then select the Insert tab in the Microsoft Excel Ribbon. On the left side of the ribbon, click the Pivot Table button.You will then see the Create PivotTable window, as shown above.The default options will include the source data that you highlighted earlier. You may modify this as necessary.reate Your Pivot Table. Once you've opened the file, use your mouse to highlight the data that you wish to include in the pivot table. Then select the Insert tab in the Microsoft Excel Ribbon. On the left side of the ribbon, click the Pivot Table button.
You will need a spreadsheet with several entries in order to create a Pivot Table. 1  You can also create a Pivot Table in Excel using an outside data source, such as Access. 2  You can insert the Pivot Table in a new Excel spreadsheet.y default, Excel will select all of the data on your active spreadsheet. You can click and drag to choose a specific part of the spreadsheet, or you can type the cell range in manually. 1  If you are using an external source for your data, click the Use an external data source option and click Choose Connection... .