How to Delete Multiple Rows in Excel 2007

1. Open 'Microsoft Office Excel 2007.'
2. Click the 'Office' button, and select 'Open.' Locate the file you want to edit, and click the 'Open' button.
3. Click the row heading on the left side of the sheet for the first row you want to select.
4. Press and hold the 'Ctrl' key, and click the row headings for the remaining multiple rows you want to select.
5. Click the arrow beside the 'Delete' icon in the 'Cells' group under the 'Home' tab in the Office ribbon menu at the top of the program.
6. Click 'Delete Sheet Rows.'
7. Click the 'Save' icon located next to the Office button to save the changes you've made to the file.

Read more ►

How to Get a List of the Unique Values in an Excel Spreadsheet

Filtering
1. Highlight the cells you wish to filter for unique values.
2. Click the 'Data' tab and select 'Sort Filter,' then 'Advanced.' Inside the box that pops up, choose 'Filter the list, in place' if you wish to filter the data within the spreadsheet. You can also copy the filtered list into a new table by clicking 'Copy to another location,' then selecting the cell range you wish to paste by entering the range in the 'Copy to' field.
3. Choose the check box for 'Unique records only,' then click 'OK' to generate the list of values.
Removing Duplicate Values
4. Highlight the cells from which you wish to remove duplicate values.
5. Navigate to the 'Data' tab and select 'Remove Duplicates,' which is located in the data tools group.
6. Select one or more columns under the 'Columns' section in the pop up box, based upon those columns from which you wish to remove duplicates. Click 'OK.'
7. A message will display showing how many values were removed from the data table and how many unique values are left. Document the information you need, then click 'OK' to view the table.
Applying Conditional Formatting
8. Highlight the cells to which you wish to apply conditional formatting for unique values.
9. Select 'Conditional Formatting' under the 'Home' tab and within the 'Style' group,
10. Choose 'Manage Rules,' then select 'New Formatting Rule.'
11. Ensure the cell range and worksheet displayed in the 'Show formatting rules for' box are appropriate. Then select 'Edit rule.'
12. Select 'Format only unique or duplicate values.' in the Edit Formatting Rule box that pops up. In the 'edit the rule description' field, choose 'Format all' as the list and then choose 'unique' or 'duplicate,' depending upon which items you want to highlight. Choose the type of formatting you want (i.e., color, font, fill) then click 'OK.'

Read more ►

How to Export Excel 2007 to a Works Database

Install the Microsoft Office Compatibility Pack
1. Go to the Microsoft Office Compatibility Pack for Word, Excel and PowerPoint File Formats page (see Resources).
2. Scroll down to the 'Quick Details' section and choose the language for the file you would like to download by clicking the down arrow next to the 'Change Language:' label and making your selection. Click the blue 'Download' button and save the 'FileFormatConverters.exe' file to your computer.
3. Click the down arrow next to the 'Estimated Download Time' label to choose the speed of the Internet connection you are using.
4. Read through and (if necessary) follow the instructions in the 'Overview' and 'System Requirements' sections to be sure your program will function properly once installed.
5. Click 'Start,' type 'Windows Update' and press 'Enter.' Click 'Check for updates' in the Windows Update window that opens and install all recommended software to bring your system up to date. If Windows Update does not recommend software, it is because your computer is already up to date.
6. Open the 'FileFormatConverters.exe' file you saved and follow the instructions given to install the program on your computer.Use the following instructions to save the file in CSV format if you have Excel on your computer and you do not want to install the Microsoft Office Compatibility Pack.
7. Open the file in Excel that you want to transform and click the 'Office' button, select 'Save As' and then 'Other Formats.'
8. Select the downward arrow next to the 'Save as type' label in the 'Save As' dialog box and scroll to find 'CSV (Comma delimited) (*.csv)' and select it. Click the 'Save' button. Save one sheet at a time if saving data from multiple sheets in a workbook. If you are using this method, use the CSV file instead of the Excel file for the conversion.
Convert the Excel Spreadsheet to a Works Spreadsheet
9. Click 'Start' and navigate to the file you want to convert. Right-click on the file, select 'Open with,' then select 'Choose Program' to open the 'Open With' window.
10. Scroll through the list to find 'Microsoft Works.' If it is there, select it and click the 'OK' button to close the 'Open With' dialog box and open the file in the selected program.If you did not find Microsoft Works listed in the 'Open With' dialog box, find the Microsoft Works program and click the 'wksss.exe' file, then click 'OK' to close the dialog box and open the file in the selected program.
11. Click on 'File' on the top menu in Works and select 'Save As.' Be sure the 'Save as type' option is set to Works format. The extension will be '.wps.'
12. Name the document and click the 'Save' button.
Create the Works Database
13. Click cell A1 (the top-left cell in the spreadsheet) and hold down the 'Ctrl' and 'Shift' keys and press the 'End' key to select the active cell range in the workbook.
14. Click 'Edit' on the top menu and select 'Copy' to copy the cells you want to include in your database.
15. Click 'File' on the top menu and select 'New' and then click 'Add to a Field' to create a new database.
16. Click 'Edit' on the top menu and click 'Paste' and click 'Yes' to let Works add extra fields.

Read more ►

How to Convert Columns to Percent Using VBA

1. Open the Excel 2010 spreadsheet where you want to format a column as a percentage. Once the spreadsheet is open, press 'Alt' and 'F11' to open up the VBA console.
2. Right-click on the first worksheet listed on the left side of the VBA console. Choose 'Module' from the popup menu under 'Insert.' Click on the new module that appears a few lines underneath the worksheet.
3. Place your cursor in the white space on the right side of the VBA console. Type 'Sub ColConv' and press 'Enter.' VBA will automatically add the 'End Sub' command to the code.
4. Place your cursor on the line between the 'Sub' and 'End Sub' commands. Enter the following code into the console:Columns('A:A').SelectSelection.NumberFormat = '0.000%'Change both 'As' to whatever column you want to convert. Change the number of '0s' after the decimal to determine how many decimal places the percentage will show. For example, '0.00%' will display a percentage as '15.55%,' while '0%' will display a percentage as '16%.'
5. Click the 'X' at the top of the VBA console to close it. You can run your macro by clicking the 'Macro' button in the 'Developer' tab. Just choose 'ColConv' from the list and click 'Run' to convert your specified column to a percentage.

Read more ►

How to Use Macro in Excel With Examples

1. Start Excel. A new workbook is automatically opened for you.
2. Open the macro recording window. In Excel 2003, click on 'Tools > Macro > Record New Macro' and in Excel 2007 click 'View > Macros > Record Macro.'
3. Type in a meaningful name in the macro box according to what you want to record: for example 'OpenTaxFile,' or 'MakeExpenseSheet.'
4. Enter a shortcut key for your macro in the 'Shortcut key' box. For example, enter a 'O' to assign the keys 'Ctrl' and 'O' to your macro.
5. Click on 'OK.' The macro recorder is now running.
6. Perform the task that you want the macro to automate. For example, open a particular file by click on 'File > Open' in Excel 2003, or 'Office > Open' in Excel 2007 and then locate the file. You can also format a spreadsheet: for example, make an expense sheet by typing in any information that you want contained on the sheet, like mileage and business expenses.
7. Stop macro recording by clicking on 'Macro > Stop Recording.' Your macro is now ready for testing and use.

Read more ►

How to Calculate R Squared for Measurements in Excel

1. Open a new Excel 2010 spreadsheet. Click on cell 'A1' and type in a header for your measurements. This text will appear at the top of the chart where your R-squared value is located.
2. Click on cell 'A2' and enter your first measurement. Then enter the rest of your measurements down column 'A.'
3. Select cell 'A1' and click the 'Insert' tab at the top of the Excel window. Click the 'Line' button, located in the 'Charts' area of the ribbon. Select the 'Line' option, which will be the icon in the upper-left corner, from the menu that appears. A line chart will appear on your spreadsheet.
4. Click anywhere on the chart to select it, and then click the 'Layout' tab at the top of the screen. Click the 'Trendline' button in the Analysis area of the ribbon, and choose 'More Trendline Options' from the pop-up menu.
5. Click the radio button next to 'Linear' in the Format Trendline window. Then place a check mark next to 'Display R-squared value on chart,' near the bottom of the window. Click 'Close' to close the window. Your R-squared value will appear just above the trendline on the chart.

Read more ►

How to Use Squared in Excel

1. Launch Microsoft Excel, then enter the number to be squared into cell A1. Press 'Enter' to move the focus to cell A2.
2. Press the Equal sign '=' and type the word 'Power' followed by a left parenthesis '(' and then click once on cell A1 to select it as the source. Type a comma ',' and then the number '2' and a right parenthesis ')' and press 'Enter.' The cell A2 now shows the squared value of whatever is entered into cell A1, or in other words the contents of cell A1 raised to the second power. The final formula will look like this: =POWER(A1,2)
3. Change the number in cell A1 to any other number and the formula in cell A2 will automatically update to reflect the value of cell A1 raised to the second power.

Read more ►

How to Print Microsoft Excel Spreadsheets With Gridlines

1. Open the Microsoft Excel spreadsheet that you would like to print with gridlines. Make sure that all of the information on the spreadsheet is correct and ready to print.
2. Click 'File' and 'Page Setup.' This will bring up a box where you will be able to change different features of your spreadsheet.
3. Click the tab at the top of this box that says 'Sheet.' From this box you will be able to change different ways that you can print your spreadsheet. Find the box that says 'Print.' You will see a box inside this area that says 'Gridlines.' Click this so that there is a check in the box. Click 'OK.' When you print your spreadsheet, you will be able to see the gridlines behind your content.

Read more ►

How to Convert Decimal Time Into Seconds in Microsoft Excel

1. Open a new Excel 2010 spreadsheet.
2. Click on cell 'A1,' and type in the time in decimal form. Enter the minutes before the decimal point if you want the result to display like it would on a clock.
3. Click on cell 'A2.' Type the following formula into the cell: '=((A1-INT(A1))*60)' (without quotes). Press 'Enter' to complete the formula, and you will see the number of seconds appear in the box. This formula will remove the minutes from the equation entirely, so if you entered '4.5' into cell A1, your result here would be '30,' as '.5' is exactly half of a minute.
4. Click on cell 'A3.' Type the following formula into the cell: '=(A1/60)/24' (without quotes). Press 'Enter' to complete the formula. This will give you the numerical version of the time, which Excel can then convert into hours, minutes and seconds.
5. Right-click on cell 'A3,' and choose 'Format Cells' from the pop-up menu. Select 'Time' from the list of options on the left side of the window. Choose one of the time options that includes hours, minutes and seconds, but does not include a.m. or p.m.
6. Click 'OK' to close the window. You will see cell A3 change to show you your entered time in hours, minutes and seconds.

Read more ►

How to Use Goal Seek in Visual Basic

1. Open the Excel document in which you'd like to run your Goal Seek macro.
2. Find the two cells you would like to use for Goal Seek. The first should be the cell for which you have a fixed goal. The second should be a cell you allow Excel to change in order to fulfill that goal. The first cell's value must be a formula that is based on the second cell--otherwise, no matter what changes Excel makes to the second cell, no changes will appear in the first.
3. Open the Macro window. In Excel 2007 or later, do this by clicking on the 'View' tab of the ribbon, then clicking 'Macros.' In earlier versions of Excel, click the 'Tools' menu, choose 'Macro,' then choose 'Macros.'
4. Type a name for your Goal Seek macro in Macro window, and click 'Create.' This will launch the Visual Basic for Applications editor and show you the text of the new Macro, which will start out as an empty subroutine like this:Sub MyMacroName()
End Sub
5. Create a Range object representing the cell for which you have a known goal (the first cell from Step 2). For example, if you'd like to Goal Seek cell A1, write:Dim goalCell As Range
goalCell = ThisWorkbook.Worksheet(1).Range('A1')
6. Create a Range object representing the cell you'd like Excel to change to cause the first cell to reach the known goal. For example, if you'd like Excel to manipulate cell A2, write:Dim variableCell As Range
variableCell = ThisWorkbook.Worksheet(1).Range('A2')
7. Call the GoalSeek method on the goal cell's Range. As the first argument, provide the value you'd like it to Goal Seek to; as the second argument, provide the variable cell's Range. For example, if you'd like to Goal Seek to 0, write:goalCell.GoalSeek(0, variableCell)

Read more ►

How to Make a Chart With Standard Errors in Microsoft Graph

1. Type your data into Excel using a column format. For example, if you are creating a chart for children's test scores, type the names of the children in the first column, then type the test scores in the second column.
2. Highlight the data in the document. Click at the top left, then drag the cursor to the bottom right.
3. Click 'Insert,' then click 'Chart.' Follow the instructions on the Chart Wizard to create a graph of your choice.
4. Double click a series on the chart, then press 'Ctrl' and '1' to open the Format Series dialog box.
5. Click either the 'X Error Bars,' or the 'Y Error Bars' tab, depending on what type of error bar you want to add.
6. Click an icon that represents the specific error bar you want to add. The choices are 'Both,' 'Plus,' 'Minus,' or 'None.'
7. Click a radio button for the error amount, and type an amount into the error text box. For example, click the radio button for 'Fixed value,' then type '2' into the text box.
8. Click 'Ok.'

Read more ►

How to Delete a Custom Toolbar in Excel 2003

1. Open Excel 2003 and locate your customize toolbar. Click 'Tools' on the menu bar and select 'Customize.' The Customize dialog box appears.
2. Click the 'Toolbars' tab in the Customize dialog box. Search the menu for your custom toolbar's name. Use the scroll bar to drag up and down to find your custom toolbar's name. Remove the check from custom toolbar's name.
3. Click the toolbar name. The toolbar name is highlighted in blue. Click the 'Delete' button. The custom toolbar is deleted.

Read more ►

How to Import an MS Outlook Calendar Into MS Excel

1. Launch Microsoft Outlook.
2. Click the 'File' tab at the top of the window.
3. Click 'Open,' and then click 'Import.'
4. Click 'Export to a file,' and then click 'Next.'
5. Click 'Microsoft Excel 97-2003,' and then click 'Next.' This is the .XLS file type, which is compatible with all versions of Microsoft Excel from 97 to 2010.
6. Click 'Calendar,' and then click 'Next.'
7. Click 'Browse,' and then select a location on your computer for your Excel calendar file. Click 'Next' to continue.
8. Click 'Finish.'
9. Browse to the file location you selected earlier, and then double-click the file to open it in Excel.

Read more ►

How to Remove Excess Tab Symbols From an Excel Spreadsheet

1. Make a copy of the file you want to remove tab symbols from. Work on the copy of the file.
2. Go to the 'Home' tab.
3. Click on the 'Find Replace' icon (it looks like a pair of binoculars). This will pull up the Find/Replace dialog box. Alternatively, hit 'Ctrl'-'H' to pull up the Find/Replace dialog box.
4. For the item to be found, enter '^t'. Leave the 'Replace' field blank.
5. Click on the 'Options' button and select 'Workbook' from the first drop-down menu.
6. Click on the 'Find Next' button; make sure it's highlighted what you want replaced, and click 'Replace.'
7. Repeat the previous step until all the tab symbols you want replaced are removed. Alternatively, if you want to eliminate all tab symbols, select 'Replace All.'

Read more ►

How to Remove Add

Delete Toolbars
1. In Excel 2007, point to the toolbar you want to remove with your mouse.
2. Right-click with your mouse.
3. Select 'Delete.'
Hide Toolbars
4. Click on the 'View' tab in Excel 2007.
5. Find the name of the toolbar you want to hide in the 'Show/Hide' section.
6. Uncheck the box next to the toolbar's name.

Read more ►

How to Restore Office File Associations

1. Click on the Start button and choose Run. Type the following in the run command box and press the Enter key: 'winword /regserver'. Doing so will start the Microsoft Word application and automatically re-associate all word processing file types with the Word program.
2. Click on the Start button and choose Run. Type the following in the run command box and press the Enter key: 'excel /regserver'. This will start the Microsoft Excel application and will associate all spreadsheet data file types with the Excel program.
3. Click on the Start button and choose Run. Type the following in the run command box and press the Enter key: 'powerpnt /regserver'. This will start the Microsoft Powerpoint application and will associate all Powerpoint presentation files with the Powerpoint program.
4. Click on the Start button and choose Run. Type the following in the run command box and press the Enter key: 'msaccess /regserver'. The Microsoft Access application will start and it will associate all appropriate database file types with the Access program.

Read more ►

How to Create a Sum Formula in Microsoft Excel 2003

1. Create a new file and name it for easy saving by left-clicking on the “File” tab on the command bar and selecting “Save As.”
2. Create a group of numbers in cells. Select a desired column and then create at least two or more groups of numbers in a row, from top to bottom. For example, if you were to use column “A”, then you would create a group of two or more numbers in cells “A1” and “A2”.
3. Create a sum formula for the cells. To create a sum formula, select a vacant cell and activate it by left-clicking on the desired cell. Then enter your sum formula. To create a SUM formula in Excel you use this format: SUM=(A1 A2). Before each sum formula, type in the word “SUM=” followed by the cells that will be summed in parenthesis.
4. Save your spreadsheet. Make sure to save your new spreadsheet by clicking on the “File” tab and selecting “Save.”

Read more ►

How to Replace All in Excel VBA

1. Open the Excel workbook where you want to enter your VBA code. Press 'Alt' and 'F11' to open up the VBA console.
2. Double-click on the module where you want to enter your code. If there is no module you can right-click on a worksheet, move your mouse over 'Insert' and choose 'Module.' Then double-click on the module to bring it up.
3. Copy the following formula into the module:Sub AReplace()Dim sb As WorksheetFor Each sb In Worksheetssb.Cells.Replace What:='XXX', Replacement:='YYY', LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=FalseNextEnd SubChange 'XXX' to the value you are searching for and 'YYY' to the value you want to replace it with. You can also change the 'MatchCase' value to 'True' if capitalization is important. This macro will find and replace all desired values on every worksheet in your workbook.
4. Use the following code if you only want to replace all the values in a given selection:Selection.Replace What:='XXX', Replacement:='YYY', LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=FalseYou can use this code within any other VBA macro as long as you enter this code after you have defined a selection area in your macro.
5. Click on the 'X' in the top-right corner of the VBA window to close it. All your changes are automatically saved.
6. Click the 'Developer' tab and press the 'Macro' button. Choose your macro from the list and click 'Run' to replace all the targeted values in your worksheet or workbook.

Read more ►

How to Filter Duplicates in Excel

1. Click 'Start' then 'All Programs.' Open Excel 2010 by clicking 'Microsoft Office Excel 2010.'
2. Click 'File' then 'Open.' Select the Excel spreadsheet that contains the duplicate data you wish to filter.
3. Click the 'Data' tab then click the 'Remove Duplicate' button. A dialog box opens which lets you select the columns and rows that you want Excel to scan for duplicate data.
4. Click 'Select All' then click 'OK.'
5. Click 'OK' once more to confirm the success of the operation. The spreadsheet is now filtered of duplicate data.

Read more ►

How to Add (or Subtract) in a Spreadsheet like Excel

1. Open the Excel worksheet.
2. Enter the values in a row or column.
3. Click a cell to the right of the row of values or click a cell below the column of values. The selected cell displays a black outline.
4. Click the 'Home' tab.
5. Click the 'AutoSum' button in the 'Editing' group. This summation button displays the uppercase Sigma. A formula appears with the range of cells.
6. Press the 'Enter' key. The total appears in the selected cell.

Read more ►

How to Convert the Date to Text in Excel

1. Open in Excel the workbook that has the dates you want converted to text. If that file isn't available, populate date data into a single column (A2) in a new Excel workbook.
2. Label your date column (presumed to be column A for purposes of this instruction) as 'Date' in cell A1. Label the column where you want the converted date to populate as 'Date-Text.'
3. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mmm-yyyy format:=TEXT(A2,'dd-mmm-yyyy')Example:
Date: 1/10/2010
Date-Text: 10-Jan-2010Copy this formula down the column as necessary to convert all of the date data to text data.
4. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mm-yyyy format:=TEXT(A2,'dd-mm-yyyy')Example:
Date: 1/10/2010
Date-Text: 10-01-2010Copy this formula down the column as necessary to convert all of the date data to text data.
5. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mmm-yy format:=TEXT(A2,'dd-mmm-yy')Example:
Date: 1/10/2010
Date-Text: 10-Jan-10Copy this formula down the column as necessary to convert all of the date data to text data.
6. Enter the following formula in the second row of the 'Date-Text' column to convert the date to mmm-dd-yyyy format:=TEXT(A2,'mmm-dd-yyyy')Example:
Date: 1/10/2010
Date-Text: Jan-10-2010Copy this formula down the column as necessary to convert all of the date data to text data.
7. Enter the following formula in the second row of the 'Date-Text' column to convert the date to mmm-dd-yy format:=TEXT(A2,'mmm-dd-yy')Example:
Date: 1/10/2010
Date-Text: Jan-10-10Copy this formula down the column as necessary to convert all of the date data to text data.

Read more ►

How to Calculate Empty Cells Using Excel

1. Add the following numbers and blank cells in the first column of your Excel 2007 document. For example, add the numbers 2,3,leave blank,5,6,7,leave blank,9,0,2,3,4,leave blank,6,7, and 8 in A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14 and A15. Here 'leave blank' means don't enter any value in A3, A7 and A13.
2. Click on the 'A17' cell for this example. This is the cell where you will calculate how many total blank cells are in this column. You can choose any cell to calculate total blank cells.
3. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
4. Click on the drop-down menu of 'Or Select a Category.'
5. Scroll down to the 'Select a Function' window. Choose 'Countblank.'
6. Click 'OK.' The 'Functions Arguments' window will open. Ensure that on 'Number 1' cell, A2:A15 is populated. If A2:A15 is not populated, enter A2:A15 manually. Click 'OK.'
7. The total blank cells for the row has been successfully calculated in the 'A17' cell. In this example, the calculated value of blank count is '3'. In other words, only three cells are blank on this column. You can use this method to accurately identify blank cells regardless of the size of the data.

Read more ►

How to Build a Savings Interest Calculator in Excel

1. Open a new spreadsheet in Excel.
2. Label row 1 as follows: A1 is 'Date,' B1 is 'Balance,' C1 is 'Additional deposits' and D1 is 'Interest.' Format columns B, C and D as currency by selecting the columns and clicking on the dollar sign button in the 'Home' tab. (Users of Excel 2003, click the dollar symbol on the Formatting toolbar.)
3. Call your bank or look at your account online to find out when the bank adds interest payments to your account.
4. Fill in column A with interest payment dates, starting with the most recent date your account received an interest payment. If your bank adds interest payments monthly, use monthly dates (October 1, November 1, etc.); if it pays annually, add dates by year. For example, if your last interest payment was October 1, 2009, the next date will be October 1, 2010.
5. Type the current balance of your savings account into cell B2.
6. Fill in column C with additional deposits. If you deposit $500 into the account in the interval between interest payments, enter '500' in cells C2, C3, and down as far as you'd like. If you deposit irregularly, leave those cells blank but enter figures each time you make a deposit. You can combine these approaches, entering a minimum figure and adding to it if you make more deposits.
7. Enter the following calculation in cell D2, without the quotation marks: '=B2 C2 x*(B2 C2)' where x is the interest rate. The interest rate type--daily, monthly, annually or other--must match the intervals between the dates in column A (step 4). Remember to multiply the interest rate expressed as a percentage by .01. So a 1.5 percent interest rate calculated once a year gives you a multiplier of 0.015. In this case your formula would be '=B2 C2 .015*(B2 C2)'. If the same interest rate was applied monthly instead of annually, your formula would be '=B2 C2 (0.015/12)*(B2 C2)'.
8. Copy cell D2 and paste in cells D3, D4 and on down as far as you'd like.
9. Navigate to cell B3 and type (without the quotation marks) '=D2'. This will cause Excel to display the formula result--your account balance after the interest payment--in cell B3.
10. Copy cell B3 and paste in cells B4, B5 and on down as far as you'd like.
11. Save the spreadsheet and close it.

Read more ►

How to Make a Relative Frequency Histogram on Excel 2007

1. Create a column for your independent variables (your x-values). For example, if you are comparing the performance of salespersons, write 'Jim' in cell A2, 'John' in cell A3, 'Sue' in cell A4, 'Pat' in cell A5 and Joe in cell 'A6.'
2. Create a column with your dependent variables (your y-values). For the example given in Step 1, write 12 in cell B2,11 in cell B3,10 in cell B4, 9 in cell B5 and 4 in cell B6.
3. Sum the dependent variable column by clicking an empty cell at the bottom of the data and entering the summation formula. For the Step 1 example, you have information in cells B2 to B6, so the formula is =SUM(B2:B6).
4. Create a second set of y-values by calculating the percentage of sales for each item. Use a formula to calculate this for you; for the example given in the steps above, enter =B2/B7 in cell C2, =B3/B7 in cell C3, =B4/B7 in cell C4, and =B5/B7 in cell C5.
5. Click on the down arrow below 'Column' in the 'Insert' tab. Choose '2-D Column' from the menu.
6. Click on the column representing the total number of sales. Press the 'Delete' key. This action leaves you with the relative frequency distribution graph only.

Read more ►

How to Calculate the Time Difference Between Two Times in Excel 2003

1. Open Excel 2003, and select a workbook that contains columns with time information. Click 'File' on the menu bar, and select 'Open.' Browse your files, and select the workbook. Click the 'Open' button. The workbook opens.
2. Highlight the first column that contains time data. Right-click the highlighted data, and select 'Format Cells.' The Format Cells dialog box appears. Click the 'Number' tab. Select 'Time' from the 'Category' list. Select the first time format displayed. Click 'OK.'
3. Highlight the second column that will appear in the timed calculation. Press 'F4.' This repeats the previous timed number format.
4. In the third column, enter a time difference formula. The formula will subtract the first column from the second column. The formula will begin with an '=.' Click on the first cell in the first column and press the '-' key on your keyboard. Click the first cell in the second column and press 'Enter.'
5. Highlight the third column. Right-click the highlighted data, and select 'Format Cells.' The Format Cells dialog box appears. Click the 'Number' tab. Select 'Custom' from the 'Category' list. Select the time format that displays the following: '[h]:mm:ss.' Click 'OK.' Your difference column now displays the timed difference between the first and second column.

Read more ►

How to Use MegaStat in Excel 2007

1. Create a new spreadsheet in Excel 2007.
2. Open MegaStat.
3. Click the 'Add-Ins' menu option at the top-right of the screen, and you will see a new available option for 'MegaStat.' Click it to gain access to all MegaStat's functions.

Read more ►

How Do I Create a Color Drop Down Box in Excel?

Create Lookup List With Background Color
1. Go to a section of unused cells in the spreadsheet.
2. Type the choices that will appear in the drop-down list. Type one choice per cell and compose a list of choices with each selection under the previous one.
3. Highlight all cells in the list and then right-click on the highlighted block of cells.
4. Click 'Format Cells' from the context menu.
5. Click the 'Fill' tab and then click on the desired color for the background of the lookup list (the selected cells).
6. Click 'OK.' The background color of the cells is set.
Add the Lookup Cells As a Drop-down Box
7. Select the cell where the drop-down options will be placed.
8. Click 'Data' from the top navigation bar. Click 'Validation.'
9. Click the 'List' option from the 'Allow' drop-down list.
10. Click the 'Source' icon from the top navigation bar and drag the cursor over the lookup list. Alternatively, type the range of cells defining the lookup list, such as '(=$A$1:$A$4).'
11. Tick the box next to the 'In-Cell Dropdown' option and then click 'OK.' The lookup list now appears as a drop-down box in the selected cell.

Read more ►

How to Create Conditional Formats in Excel 2007

1. Open an existing Microsoft Excel document in which to create these conditional formats. Double click on the 'My computer' option on the main operating system desktop. Choose the location of the Excel file and double click on the file icon to open the document.
2. Ascertain which cells or worksheet the conditional formatting will apply to. Prior to opening the conditional formatting manager, choose particular cells, the entire worksheet or workbook to apply the conditional format.
3. Choose the 'Conditional Formatting' button from the home menu ribbon. Then select the 'Manage Rules' option from the conditional formatting menu.
4. Click on the 'New Rule' button from the conditional formatting rules manager dialogue box.
5. Select the type of rule to create. There are six types of rules that a user can create, in this case the 'Format All Cells Based on Their Values' type will be utilized.
6. Determine the scheme and value basis for the condition format rule. For instance, a user can make the color of each cell vary based on the number in the cell. The highest number gets a certain color while the lowest gets another color. All the numbers in between will be assigned a variation on color scheme based on the value relative to the highest and lowest number in the spreadsheet.
7. Apply the format style to the conditional format. There are four options to choose from. In this case, a '2-Color Scale' was used.
8. Save the rule and the spreadsheet once the conditional formatting rule is complete.

Read more ►

How to Make Mailing Labels in Excel 2007

1. Open the Excel 2007 worksheet containing the list you want to use to make mailing labels. If you do not yet have a list, open a blank worksheet. Enter a name for each column in the first row of the worksheet. Choose names that will be easy to understand in the merge, such as 'First Name,' 'Last Name' and 'Street Address.' Save and close the worksheet.
2. Start Word 2007. Go to the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels' from the drop-down list. The 'Label Options' dialog box opens.
3. Select the label settings for the label pages you are using. Pick the label brand name from the 'Label Vendor' drop-down list. Select the product number that is listed on the label package in the 'Product Number' list. Click 'Detail' to view the details for a label, such as the size and the number of labels per page. If the label you are using is not listed, click 'New Label' and enter the specifications for your label. Click 'OK' when you have made your selections.
4. Click 'Select Recipients' in the 'Start Mail Merge' section of the 'Mailings' tab. Click 'Use Existing List.' Navigate to the Excel 2007 worksheet containing the list you want to use to make mailing labels. In the 'Select Table' dialog box, click the sheet of the workbook that has the list you want to use. Click 'OK.'
5. Click 'Address Block' in the 'Write Insert Fields' group of the 'Mailings' tab. Click the 'Match Fields' button. Match the address block fields to the field names you used in your Excel worksheet. Click 'OK' to close the 'Match Fields' dialog box. Click 'OK' to close the 'Insert Address Block' dialog box.
6. Click 'Update Labels' in the 'Write Insert Fields' group of the 'Mailings' tab. Click 'Finish and Merge' in the 'Finish' group of the 'Mailings' tab. Select 'Edit Individual Documents' to create a new document with the merged mailing labels and print them later or click 'Print Documents' to print the labels immediately.

Read more ►

How to Put Excel Data Into a Pie Chart

1. Open a new worksheet in Microsoft Excel. Add headings in the first column down the left side of the page. For instance, if you are making a pie chart of my favorite things, you would write, 'Football,' in cell A1, 'Chocolate,' in cell A2, and 'Television,' in cell A3. Then, put the numbers in the 'B' column. So, using the above example, this would mean you'd put 50% in cell B1 next to 'Football,' a 30% in cell B2, next to 'Chocolate,' and a 20% in cell B3 next to 'Television.'
2. Highlight all of the cells in both columns, from A1 to B3. In Microsoft Excel 2007, simply click the 'Pie' button in the toolbar at the top of your screen. In earlier versions of Excel, and on the Mac 2008 version, click on the 'Insert' menu at the top of the screen and select the 'Chart...' option. A smaller window will pop-up called the 'Chart Wizard.'
3. Hit the 'Pie' button in Microsft Excel 2007, and a drop down menu will appear. Choose the type and style of pie chart you want, and that chart will then be inserted into your spreadsheet. This is the final step to make a pie chart in Excel 2007. If you are using earlier versions of Excel or Excel 2008 for Mac, proceed to the next steps.
4. Click on 'Pie' in the 'Chart Type' menu. To the right of the menu, you will see six different sub-types for how you want your chart to look. Click on the type of pie chart you want and then click and hold the button that says, 'Press and Hold to View Sample.' This will give you a preview of how your chart will look using the data you have entered. When you are happy with your chart, click 'Next' at the bottom of the window.
5. Clarify that the data range is correct in the pie chart. In the space titled, 'Data Range,' click on the gray button with red, blue, and black dots to the right of the blank space. This will shrink the Chart Wizard window. Use your mouse to highlight the area of data you want, including the headings and corresponding numbers. Click 'Next.'
6. Title your chart in the space on the left that says, 'Chart title.' When you are finished, click 'Next.' Finally, choose where you want your chart to be displayed. You can have it displayed directly in the document, or place it in a new spreadsheet. When you have made your choice, select, 'Finish,' and your pie chart will appear in the document.

Read more ►

How to Merge Excel Worksheets Into a Workbook

1. Open Microsoft Excel. Press and hold the 'Ctrl' key on your computer's keyboard and press the 'O' key to start the 'Open' window. Click on the first workbook you would like to open. Press and hold the 'Ctrl' key and click on the second workbook. Press the 'Open' button at the bottom right of the 'Open' window to open both workbooks.
2. Click the workbook on the bottom Windows toolbar that contains the sheet that you would like to merge. Right-click the sheet tab that you would like to move or copy. For example, right-click 'Sheet 1' tab at the bottom left of the Excel workspace to select the first sheet to merge. Click 'Move or Copy...' from the drop-down list.
3. Click the 'To Book' drop-down menu on the 'Move or Copy' window. Click on the workbook to which you want to move the worksheet. For example, if your other workbook is called 'Book1,' click on the 'Book1' workbook. Click the sheet name of where you want the sheet to appear in the new workbook from the 'Before sheet' menu. If you want your sheet to appear at the end of the workbook, click 'move to end' from the 'Before sheet' menu.
4. Check the 'Create a copy box' if you want to maintain the sheet in the current workbook. Otherwise, leave the box unchecked to move the sheet from one workbook to the other. Press the 'OK' button to move or copy the worksheet from one workbook to the other.

Read more ►

How to Delete Cells in MS Office 2003

1. Open an existing worksheet in Microsoft Excel.
2. Select the cell (or cells) you want to delete from your worksheet. To select an individual cell, simply click the cell. For a range of cells, click the first cell and drag your cursor down to the last cell. If it's a large range, click the first cell in the range, and press 'Shift' while you click the last cell. Press 'CTRL' while clicking individual cells that aren't adjacent.
3. Open the 'Edit' menu.
4. Click 'Delete.' As a shortcut, right-click the selection and click 'Delete.'
5. Make a selection in the 'Delete' dialog box. Select 'Shift Cells Left, Shift Cells Up, Entire Row or Entire Column.' This will determine what to do with the remaining cells after you delete.

Read more ►

How to Divide Cells in Excel

Divide the Numbers in a Cell
1. Click on a cell to enter your data.
2. Type an equal sign (=).
3. Type your first number. For this example, we will divide 15 by 5.
4. Press the forward slash key on your keyboard (/). This is the division sign in Excel.
5. Type in your next number, 5.
6. Press the 'Enter' key on your keyboard or click on the check mark on the tool bar. This displays the result of the calculation.
Divide Numbers in a Range of Cells
7. Type the number 15 into cell A1.
8. Type the number 5 into cell A2.
9. Click cell A3 and type an equal sign (=).
10. Click on cell A1. 'A1' should appear after the equal sign in A3.
11. Press the forward slash (/) key on your keyboard.
12. Click on cell A2. 'A2' should appear after the forward slash. Your formula should look like this: = A1/A2.
13. Press the 'Enter' key on your keyboard or click on the check mark button on the tool bar to perform the calculation. The answer 3 should appear in cell A3.
Divide Numbers Using the Quotient Function
14. Use the quotient function. You can divide numbers with the quotient function: QUOTIENT (Numerator, Denominator). The only difference between using this function and using regular division is that, if there are any remainders, the answer from the quotient function will not display it.
15. Type the number 15 into cell A1. This is your numerator.
16. Type the number 2 into cell A2. This is your denominator.
17. Click on A3, where the result will be displayed.
18. Click on the 'Paste function' button (fx) on the tool bar to open the list of functions. Select 'Quotient.' The quotient dialog box should appear.
19. Click on the 'Numerator' line. Click on cell A1.
20. Click on the 'Denominator' line in the dialog box. Click on cell A2.
21. Click on 'OK' to close the Quotient dialog box. The number 7 appears as the answer in cell A3. Notice that the answer does not include any remainders.

Read more ►

How to Calculate a Percentile Using Excel

1. Enter your dataset in a continuous column in Excel. For this example, assume that the data is entered in cells A1 to A100.
2. Determine what percentile you want to calculate, and convert it to a number between zero and one. For example, the 20th percentile is 0.2, the 55th percentile is 0.55, the 100th percentile is 1, and so on. This example will use the 40th percentile (0.4).
3. Enter the following formula in the cell where you want the percentile result to show:=PERCENTILE(A1:A100,0.4).This tells Excel to calculate the 40th percentile of the data in cells A1 to A100.

Read more ►

How to Add a Shadow to a Chart in Excel

1. Start Microsoft Excel and open an existing workbook from your files that contains a chart to which you would like to add a shadow.
2. Select the chart you would like to add a shadow to by clicking on it with your mouse. The chart will be surrounded by a light blue outline when it is selected.
3. Choose the 'Format' tab at the top of the Excel screen to show the formatting options that you can apply to your selected chart. Locate the 'Shape Styles' section of the 'Format' ribbon.
4. Click the small half box and arrow button that lies on the 'Shape Styles' title bar on the lower right corner. This will open the 'Format Chart Area' dialog box.
5. Select 'Shadow' from the left side of the 'Format Chart Area' dialog box to display the shadow settings you can add to the selected chart.
6. Use the 'Preset' drop-down menu to choose a preset shadow from Excel. You can change the color of the shadow by selecting a new color from the 'Color' drop-down menu. The settings for the shadow can be changed using the 'Transparency,' 'Size,' 'Blur,' 'Angle' and 'Distance' sliders.
7. Click the 'Close' button to close the 'Format Chart Area' dialog box and return to your chart, which is now highlighted with a shadow.

Read more ►

How to Make a Pictograph on Excel

1. Launch Excel 2010 and open a spreadsheet containing data that can be expressed in a graph. Highlight the cells that you want Excel to include in the graph.
2. Select the 'Insert' tab at the top of the window. Click 'Column' or 'Bar' in the 'Charts' section of the toolbar to generate a graph from the selected data.
3. Double-click one of the graph's bars. This opens a Format Data Point window.
4. Select the 'Fill' heading on the left side of the Format Data Point window.
5. Click to select the 'Picture or Texture Fill' radio button.
6. Click the 'File' button under 'Insert from' and double-click the image you want to use for the selected bar.
7. Click the 'Stack' radio button to display several stacked copies of the selected image in place of the bar, or click the 'Stretch' radio button to display a single image stretched to fill the bar.
8. Click 'OK' and repeat Steps 3 through 7 for the remaining bars of the graph.

Read more ►

How to Set Printing Options in Excel

1. Start Microsoft Excel and open a spreadsheet that you would like to print.
2. Choose the 'File' button and click 'Print' to bring up the 'Print' dialog box.
3. Change the printer you are using by clicking the 'Name' list under the 'Printer' section of the 'Print' dialog box. You can view the printers you have installed and click on which printer you would like to use to print your spreadsheet.
4. Check the 'Print to file' check box in the 'Printer' section of the 'Print' dialog box to print the spreadsheet to another computer file instead of from a printer.
5. Set the print range of your spreadsheet by selecting the 'All' radio button to print all of the pages or 'Page(s)' radio button to print only a certain page or multiple pages in your spreadsheet. If you choose the 'Page(s)' option you will need to use your keyboard to specify which pages you would like to print.
6. Select what you would like to print by choosing either 'Selection,' 'Active sheet(s),' 'Entire workbook' or 'List' under the 'Print what' section of the 'Print' dialog box.
7. Set the number of copies that you want to print by using your keyboard to type in the number beside 'Number of copies' under the 'Copies' section of the dialog box. You can also choose to collate the spreadsheet by putting a checkmark in the 'Collate' check box in this same section.

Read more ►

How to Use Excel 2003 Formulas Functions for Budgets

1. Decide which formula you want to use. For example, you may want to add a column of data or multiply certain budgetary numbers by 12 to convert from a monthly to yearly budget.
2. Locate the formula you need in the 'Microsoft: Excel Commonly Used Formulas' (see Resources). For example, click on 'Add Numbers' in the Math subsection. One of the functions you can use is the 'Sum' function, which adds numbers in a single cell or multiple cells.
3. Enter the formula into the cell where you would like the answer to appear. For example, you may want to add a list of budget items in cells B2 to B10 and display the result in cell B11. All formulas begin with an equals sign ('='), so type the following text into cell B11:=SUM(B2:B10)The colon means 'to' as in 'Cells B2 to B10 inclusive.'
4. Use a function instead of a formula to perform calculations. For example, you can use the autosum function in Excel instead of specifying a formula. To use the autosum function, click on the cell where you would like the total to appear (in the above example, that was cell B10). Then click the autosum symbol on the standard toolbar. The autosum symbol is an uppercase sigma. Click on the cells you would like to sum (for example, B2 through B10). The autosum function will place your result in cell B10.

Read more ►

How to Scroll With a Mouse Wheel in Excel 2007

1. Open Microsoft Excel 2007 and launch the document you need to view.
2. Click inside the document somewhere (or on the scrollbar at the side of the page). This tells the mouse you are working inside the loaded Excel document.
3. Drag your finger from top to bottom over the scroll wheel on the mouse. This moves the page down and you can see the scrollbar on the side of the screen move with your movements.
4. Drag your finger from the bottom of the scroll wheel to the top. Doing so scrolls the page back up toward the top of the document.

Read more ►

How to Make Vertical Words in Excel

1. Open your spreadsheet in Microsoft Excel.
2. Click the cell containing the text you wish to make vertical.
3. Click the 'ab' symbol in the Alignment group of the Home tab and select 'Vertical Text' to align letters on top of one another. Alternatively, select 'Formal Cell Alignment,' enter '-90' or '90' in the 'Degrees' field, and click 'OK' to rotate normal text 90 degrees. Selecting '-90' will align the bottom of the characters to the left, while selecting '90' will align them to the right.

Read more ►

How to Use Excel 2007 to Make a Climate Graph With Negative Temperatures

1. Open the Worksheet.
2. Enter a date or time in each cell along one column or one row. For example, the dates April 1, April 2 and April 3 can fill cells B4, B5 and B6, respectively.
3. Enter the temperature values, one value per cell, in this temperature column. The values can be positive or negative. Enter these values in cells adjacent to the categories in Step 2. For example, enter '7' '-2'and '4' in cells C4, C5 and C6, respectively.
4. Click the cells that contain the dates and temperature values.
5. Click on the 'Insert' tab on the Ribbon. The 'Charts' group includes the 'Line' chart button.
6. Click on the 'Line' button to display the different line charts available. The '2-D' line chart displays values over time and different categories, such as dates.
7. Click on the 2-D chart button to convert the data. The chart displays both positive and negative temperature values. Try the other line chart styles to see the effect.
8. Edit the chart for a custom look. For example, the 'Design' tab includes 'Chart Layouts' and 'Chart Styles' groups. The 'Format' tab includes the 'Shape Styles' group that changes the color of the outline and background.
9. Save this worksheet.

Read more ►

How to Remove Password Protection in Excel

1. Open Excel and open the workbook for which you wish to remove the password protection. At this point, if you are using Excel 2003 or an earlier version, proceed to Step 2. If you are using Excel 2007, skip straight to Step 5.
2. Click on the 'File' menu, and then select 'Save As.' Click on the 'Tools' menu and select 'General Options.'
3. Double-click on the asterisk that is in the 'Password to open' box, and then press 'DELETE' on your keyboard. DO the same for the box labeled 'Password to modify.'
4. Click on 'OK,' then 'Save,' and finally 'Yes' to complete the password protection removal if your are using Excel 2003 or earlier.
5. Click on the 'Review' tab at the top of the Excel 2007 window, and locate the group of icons within the 'Changes' group. Click on 'Unprotect Sheet.' Type in the appropriate password when and if you are prompted, and you are finished.

Read more ►

How to Get Data From Excel Into Word

1. Click Excel's Office button, then click the 'Open' command. Navigate to and double-click a file you'd like to open to Word. Click the 'Save as' command after the file loads, then click the 'Excel 97-2003' format from the 'type' dropdown list. This format lets Word read the Excel data. Click the Office button's 'Close' command to close the workbook.
2. Click Word's Office button, then click the 'Open' command. Click the 'Excel' type from the 'Type' dropdown list, then navigate to the folder in which you saved the Excel workbook in the previous step.
3. Double-click the workbook to begin loading it. Word will display a warning message indicating the possible presence of malicious content. Click 'Yes' to continue opening the workbook.
4. Click the 'Entire' option from the dropdown control labeled 'Open document,' if you want to load the entire Excel workbook into Word. Otherwise, click one of the sheets listed in the dropdown to select just that sheet for importing to Word. For example, if your Excel data is only on 'Sheet1,' click that sheet in the 'Open document' dropdown.
5. Click the 'Name range' dropdown list if you chose to import only a particular spreadsheet in the previous step. Skip this step if you're importing the entire workbook. Otherwise, click a named range of cells in the workbook to import just that named range. For example, if the workbook contains a blocked of cells named 'ArtPatrons,' you can click that name in the 'Name range' dropdown to import just that block of cells.
6. Click 'OK' to import the Excel data into Word. Word will format the imported data as a table in a new Word document.

Read more ►

How to Change the Toolbar in Excel 2007

1. Locate the Quick Access Toolbar in Excel 2007. It will be either next to the Office button or under the ribbon.
2. Right-click on the Quick Access Toolbar and select 'Customize Quick Access Toolbar.' Check or uncheck the 'Show Quick Access Toolbar Below the Ribbon' box to place the toolbar where you want it.
3. In the ribbon, navigate to the feature you want to add to the Quick Access Toolbar.
4. Right-click on the feature you wish to add, and a menu will appear.
5. Select the 'Add to Quick Access Toolbar' option. The feature should now be on the toolbar.

Read more ►

How to Make a Time Line in Microsoft Excel

1. Gather all the information you need for the time line.
2. Open Microsoft Excel. Click on the Excel desktop icon or find Excel in the Start Menu under 'All Programs.'
3. Click the 'File' tab and pick 'New' to start a new spreadsheet.
4. Add a title to your time line. Click 'Insert' and then choose 'Header and Footer.' Type the title in the header section. Format the title to suit your needs and click 'OK.'
5. Move a few rows down the spreadsheet and input the first date. You can format the cells all at once or individually. If you are including times in your chart you may want to format the cells separately.
6. Format the descriptions so they appear vertically instead of horizontally in your time line. Highlight the cell or groups of cells you want to change. Click the 'Format' tab. Choose 'Cells.' When the format window opens pick 'Alignment.' Change the number in the 'Degrees' box. The diagram on the side displays the look of the angle you chose.
7. Create borders around the cells or the entire time line. Highlight the cells. Select 'Format' from the menu bar. Now pick 'Borders' and choose the type of border to use from the list provided.
8. Add a background color to specific cells. Select the cells you want to add color to. Choose 'Fill Color' or select the paint brush from the draw tool bar at the bottom of the screen. Pick a color and click 'OK.'
9. Insert pictures into the time line. Choose 'Insert' from the menu bar and then click on 'Picture.' Choose a file from your computer or a clip art from Excel's clip art gallery.
10. Save the time line. Select 'File' from the menu bar and then click 'Save' from the drop-down menu.
11. Print your time line. Click 'File' on the menu bar. Pick 'Print' from the drop-down menu and click 'OK.'

Read more ►

How to Manipulate Data in an Excel 2007 Pivot Table

1. Open Excel 2007 and select a workbook containing data. Click the 'Office' button and select 'Open.' Browse your files and select the workbook. Click the 'Open' button to open the workbook.
2. Highlight the data you want included in the PivotTable. Select 'Insert' on the menu bar, and then select 'PivotTable.' A drop-down menu appears. Select 'PivotTable' again. Click 'OK.'
3. Add fields to the PivotTable by checking fields from the right 'PivotTable Field List.' By default, the fields appear in the column section. Manually drag the fields to any of these sections (row, totals or filter) to see how manipulating them changes your pivot table.

Read more ►

How to Convert Excel Time Difference to Decimal Number

1. Click a cell where you want the decimal representation of the time difference to appear.
2. Type '= A1 * 24' and then press 'Enter.'
3. Change the cell location 'A1' to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type 'C3' into the formula instead of 'A1.' Pressing 'Enter' for this result will give you the decimal result '1.25.'

Read more ►

How Do I Graph on a Secondary Axis in Excel Office Professional 2003?

1. Click on the data series on the chart that you want to plot on a secondary axis. For example, if you have a chart that shows price and volume and you want to display volume on a secondary axis, then click on 'volume.'
2. Click on 'Selected Data Series' on the Format menu.
3. Click on the 'Axis' tab, then click on 'Secondary axis.' Excel inserts a secondary axis into your worksheet.

Read more ►

How to Create a Pivot Table from Multiple Worksheets

1. Open the workbook in which you want to create the PivotTable.
2. Click 'PivotTable and PivotChart Report' on the 'Data' menu.
3. Follow the instructions in the wizard. For the first step, you will be asked to identify the source for your data. Click the black box on the right-hand side of the source data box. This will disconnect the source box from the wizard.
4. Select the data ranges in the worksheets you need data from. Start with the first range and then move on to the next. The wizard will automatically put a comma between each range of data you select.
5. Click the black box on the right-hand side of the source box again to attach the box back to the wizard. Click 'Next' in the wizard until you reach the end and then click 'Finish' to exit the wizard and create the PivotTable.

Read more ►

How to Calculate Days by Subtracting Two Dates in Excel

1. Launch Microsoft Excel and open a new worksheet. Type the date in one cell. For example, type '1/1/2010' in cell A1.
2. Type your first date in cell A1. For example, input the date '1/1/2010.'
3. Type your second date in cell B1. For example, input the date '3/14/2011.'
4. Select the cell C1, type '=' and click the date in cell B1. Then type '-', click the first date and press 'Enter.' Cell C1 now shows 438, the number of days between the two dates you input.

Read more ►