A Pivot Table allows you to create visual reports of the data from a spreadsheet. You can perform calculations without having to input any formulas or copy any cells. You will need a spreadsheet with several entries in order to create a Pivot Table. You can also create a Pivot Table in Excel using an outside data source, such as Access. You can insert the Pivot Table in a new Excel spreadsheet. A pivot table is not always the answer you are looking for. In order to take advantage of the pivot table features, your spreadsheet should meet some basic criteria:  Your spreadsheet should include at least one column with duplicate values. This basically just means that at least one column should have repeating data. In the example discussed in the next section, the "Product Type" column has two entries: "Table" or "Chair". It should include numerical information. This is what will be compared and totaled in the table. In the example in the next section, the "Sales" column has numerical data. Click the "Insert" tab at the top of the Excel window. Click the "PivotTable" button on the left side of the Insert ribbon. If you are using Excel 2003 or earlier, click the Data menu and select PivotTable and PivotChart Report... By 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. If you are using an external source for your data, click the "Use an external data source" option and click Choose Connection.... Browse for the database connection saved on your computer. After selecting your range, choose your location option from the same window. By default, Excel will place the table on a new worksheet, allowing you to switch back and forth by clicking the tabs at the bottom of the window. You can also choose to place the Pivot Table on the same sheet as the data, which allows you to pick the cell you want it to be placed. When you are satisfied with your choices, click OK. Your Pivot Table will be placed and the interface will change.
++++++++++
One-sentence summary -- Load the spreadsheet you want to create the Pivot Table from. Ensure that your data meets the needs of a pivot table. Start the Pivot Table wizard. Select the data you want to use. Select the location for your Pivot Table.


Before buffing, apply a cutting compound to the buffing tool. The cutting compound protects the metal and gives it a nice shine. Read the instructions on the package to determine which compound to use for your project. In general, you can start with a firm wheel and a brown compound to do your initial polishing, then choose a softer wheel and a rouge (red) compound to get a high shine and smooth finish.
++++++++++
One-sentence summary -- Apply a cutting compound to your buffing tool.


Select the enchanting table to do so. Select an ordinary book, then select the book-shaped box in the crafting table. Select your lapis lazuli, then select the box to the right of the book's box. You'll need at least three lapis lazuli per enchantment. On the right side of the crafting table's interface, you'll see several enchantments listed. Select the one you want; if you don't see the one you want, select the lowest-level one. The book should now be purple and pink, signifying that it has been enchanted. You most likely won't find the enchantment that you want the first time around, so keep enchanting books until you find the enchantment that you want.  It's best to create low-level enchantments when the enchantment table gives you three unwanted enchantment options. After creating an enchanted book, you'll need to re-level your character to level 30.
++++++++++
One-sentence summary -- Open the enchanting table. Place a book in the enchanting table. Place the lapis lazuli in the table. Select an enchantment. Move the enchanted book to your inventory. Repeat as necessary.


Say you borrowed money from a friend who is going to charge you daily interest. The amount borrowed was initially $15 and the interest rate is 3% per day. These are the only two numbers you need for the calculation. Working backward from before, divide the percentage by 100%, or you can multiply by 0.01 (they’re the exact same).  3%/100% = 3/100 = 0.03. It helps to reword your problem with the new value(s) now in the form of “X of Y is Z.” X is the decimal form of your percent, “of” means to multiply, Y is the whole amount, and Z is the answer. So, 0.03 x $15 is $0.45.  In this example, $0.45 is the amount of interest accrued each day that you do not pay your friend back. If you need to further calculate the total due after 1 day, you would add the amount you borrowed to the amount of the interest times the number of days. So $15 + ($0.45 x 1 day) = $15.45.
++++++++++
One-sentence summary --
Identify the given numbers you're working with. Convert the percentage into a decimal. Re-word the problem with your new values.