How to Add Two Cells in Excel

1. Start Microsoft Excel, and open the file you want to use.
2. Click on the cell in which you want the total to appear.
3. Press the key on the keyboard. This character will appear in the cell and in the Formula Bar.
4. Click on the first cell you want to add. That cell's name, such as B6, appears in the Formula Bar after the sign.
5. Press the key again.
6. Click on the second cell you want to add. That cell's name appears in the Formula Bar.
7. Press Enter to complete the equation. The total will appear in the initial cell.

Read more ►

How to Create a Bar Code in Microsoft Office Publisher

1. Start up Microsoft Excel and prepare your data. This will include all the pertinent information you wish to associate with the bar code. You will also need to create a column for your bar code data. This is simply a code that will translate into a bar code and act as a reference point for that specific row of data.
2. Highlight all of the data in the bar code column and in the 'Custom Toolbar' of Excel; click on 'Settings,' and choose the appropriate bar code type. You will also need to click on the drop-down box below 'Convert To' and select 'Image File.' At this point, click 'Generate Now.'
3. Save your data and close Excel; then open Publisher.
4. Select the appropriate label size in Publisher once it starts. This selection will be based on the labels the bar codes will be printed on.
5. Click 'Tools,' then 'Mailing and Catalogs' and then 'Mail Merge,' at which point you will select 'Picture Field' to insert the bar code. You can also select any of the data from your Excel spreadsheet to accompany the bar code, such as other product or lot information.

Read more ►

How to Make Excel 2007 Behave Like 2003

1. Visit AddInTools.com and download 'Classic Menu for Office 2007.' This product costs $29.99, as of September 2010, and you will be asked to pay with a credit or debit card. You will not be able to proceed until you have successfully purchased and downloaded this product to your computer.
2. Open Excel 2007 on your computer. To do this, click the computer's Start menu. Click 'Microsoft Office 2007,' then click 'Microsoft Excel 2007'. Once you open Microsoft Excel 2007, you will notice a new task on your toolbar: 'Menu,' located right before 'Home.'
3. Click the new 'Menu' task on the toolbar at the top of Excel 2007.You should now see a toolbar that looks just like the toolbar of commands you are familiar with using on Excel 2003.

Read more ►

How to Find Lost Excel Files

Windows XP
1. Click 'Start' in the lower-left corner of your computer screen.
2. Place your mouse pointer over 'Search,' then select 'For files or folders.'
3. Click on the 'Documents' option, then select 'Use advanced search options,' then click 'More advanced search options.'
4. Click the appropriate box for when the file was last modified. If you don't know, leave this section blank.
5. Type '.xls' (without quotes) in the box that asks for all or part of the document name. If you are using Excel 2007 or later versions, type '.xlsx' instead of '.xls.' This will limit your search to Excel files.
6. Add keywords in the keyword field if you know any from the spreadsheet and change the 'Look in' field to 'My computer.'
7. Click to place check marks in the boxes labeled 'Search system folders,' 'Search hidden files and folders,' 'Search subfolders' and 'Search tape backup.'
8. Click 'Search' and allow Windows to find your document for you. If you have not entered keywords, the system will find all Excel files that meet the other criteria, so you may have a long list to scroll through to find your file.
Windows Vista
9. Click the 'Start' orb in the lower-left corner of your screen. A search box is included at the bottom of the Start menu.
10. Type '.xls' (without quotes) in the search box. If you are using Excel 2007 or later versions, type '.xlsx' instead of '.xls.' This will limit your search to Excel files. Add any keywords you remember from the document to this box as well, separated from the Excel file extension with a space.
11. Press the 'Enter' key.
12. Look through the search results for your file. If you do not see it listed, click the box at the top of the search results window labeled 'Include non-indexed, hidden and system files.'
13. Click on 'Document' near the top of the window to narrow your results to documents only (this includes spreadsheets) and click 'Search.' Scroll through the results to find your lost Excel file.
Windows 7
14. Click 'Start,' then type 'folder options' into the search box near the bottom of the Start menu.
15. Click 'Folder options' when it appears, then click 'Change search options for files and folders.'
16. Click the boxes to search hidden files and folders and system folders, then click 'OK.'
17. Click 'Start' again and type '.xls' or '.xlsx' plus any keywords from your Excel file into the search box. Click 'Show more results' on the results page and scroll down to find your Excel file.

Read more ►

How to Use Excel 2007 to Estimate Linear Functions

1. Open a new or existing Microsoft Excel spreadsheet. If you start with a blank spreadsheet, enter your x-values into column A and y-values into column B. Each pair of numbers creates a data point on a chart, so they need to correspond to each other.
2. Label your columns with descriptions of your data, such as 'Month' and 'Hours.' In this example, if you worked 160 hours in the month of June, those two values create one data point on your chart. Highlight your data set and select the 'Insert' tab on the Ribbon at the top of the page.
3. Click the 'Scatter' drop-down box in the 'Charts' area, then select the 'Scatter With Only Markers' option. This option creates a plot from your data points and allows you to estimate the linear function. Select the 'Layout' tab of the Ribbon and click the 'Trendline' button from the 'Analysis' area.
4. Click 'More Trendline Options' from the drop-down options. Select 'Linear' from the 'Trend/Regression Type' to estimate a linear function. Select the 'Display Equation on Chart' box to view the linear function equation on the chart.

Read more ►

How to Work Out Percentages in Excel

1. Open the Microsoft Excel program and type the numerator (given amount) into cell A1.
2. Highlight cell B1.
3. In the 'fx' box in the toolbar at the top of the screen, type '=A1/X' (without the quotes), replacing X with the denominator (the total amount) . For instance, if you are calculating a percentage score out of 60 points, you would type '=A1/60'.
4. Hit enter. This should calculate a decimal (eg, .75) in cell B1.
5. Hit the '%' button on the formatting toolbar near the top of the screen to convert to a percentage. Alternatively, you can simply multiply by 100.

Read more ►

How to Remove the Password Required to Open Excel

1. Open the Microsoft Excel application by clicking 'Start' and typing 'excel' into the search bar. Click on 'Excel' in the list that appears to open it. You can also click 'All Programs' and open Excel from there. You don't need a password to open Excel this way -- you only it when you double-click on a protected file.
2. Click 'File,' then 'Open.' Click on the name of the file that is password-protected. Type the password and hit 'Enter' to open the document.
3. Click 'File,' then 'Info' and 'Permissions.' Click 'Encrypt with Password.' The password entry box opens.
4. Delete the password in the box, leaving the box empty. Click 'OK' to remove the password from the document. Click 'Save' before exiting the document.

Read more ►

How to Detect Repair Excel 2003

1. Open Excel 2003 by clicking on the 'Start' button, then 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel 2003.'
2. Click 'Help' on the main menu, then select Detect and Repair. The Detect and Repair dialog box is displayed on your screen. You may be prompted to select an installation source. If so, browse to the location of your Microsoft Office installation files or insert the installation disc.
3. Choose if you want to restore your shortcuts or discard any customized settings by selecting the appropriate check boxes.
4. Click 'Start' to begin the Detect and Repair process. A Windows Installer window will appear, indicating the process has begun.
5. Allow the process to run. The program will prompt you when Detect and Repair has completed. Click 'OK' to return to Excel 2003.

Read more ►

How to Make a Cell in Excel 2007 Act Like a Checkbox

1. Open the Excel worksheet you want to modify by adding in a check box. Navigate to the 'Developer' tab in the ribbon at the top of the window.
2. Click the 'Insert' icon in the 'Control' heading to bring up a drop-down menu. Select the 'Check Box' icon in the 'Form Controls' grouping.
3. Locate the cell that needs to act as a check box. Click the cell to create the new check box. Click the outline of the box and drag it to any other cell if you need to move it.
4. Highlight the text that reads 'Check Box 1' and press the 'Backspace' key. Type in the text you want to appear next to the check box. Click any other cell to save the check box and the new text.
5. Right-click the check box if you need to make any changes. Choose 'Edit Text' to change the text displayed next to the box or choose 'Cut' to delete the check box entirely.

Read more ►

How to Create an XY Chart

1.
Open Excel and in a new workbook, create a data spreadsheet for the XY chart to reference. Enter the months, as shown in the graphic depiction in cells 'A1' through 'M4.' (NOTE: You can create a chart similar to the one shown instead.)
2.
Select 'Insert' from the menu bar. Next, choose 'Chart.' (NOTE: You can choose the chart icon on the menu bar if it is available.)
3.
Go to the 'Standard Types' tab and select the 'XY(Scatter)' chart from the Chart Type list box.
4.
Press the 'Press and Hold to View Sample' button to preview the chart before making your final selection. When ready, click 'Next.'
5.
Verify that the data are correct and then click 'Next.'
6.
Go to the 'Titles' tab and enter a name for the chart. Enter names for 'X and Y Axis Values' if desired.
7.
Select option 'As Object In' and choose 'Sheet1.' Press 'Finish.' (NOTE: Other options include placing the chart in a different worksheet or creating a new worksheet to house the chart.)
8.
Click on the chart to activate the 'Chart' menu to modify the chart. Select 'Chart' and choose 'Chart Options.'

Read more ►

How to Create a Family Tree on Microsoft

1. Open PowerPoint 2010 and click the 'File' tab. Click 'New.' Type 'Family Tree' in the search box. Review the available family tree templates that appear.
2. Click the family tree template to see a preview of it in the right task pane. Click the 'Download' icon to download the template.
3. Click in the text boxes and highlight the default text. Type in your family information. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar.

Read more ►

How to Use Excel's GETPIVOTDATA Function

1. Understand the syntax of the GETPIVOTDATA function. The formula is =GETPIVOTDATA(pivot_table, name). Pivot_table references a cell in the PivotTable or a range of cells in the PivotTable, a label of a cell above the PivotTable or the name of the range that contains the PivotTable. 'Name' is text enclosed in quotations marks that describes the data.
2. Create a new workbook to practice using pivot tables. Label columns A, B and C with the headers 'Name,' 'Month' and 'Sales.' Under the header row, fill in several of the rows with data. Include the same name and month more than once.
3. Hold down your left mouse key and drag it across and down so that all the cells are highlighted. Click 'Data' and select 'PivotTable and PivotChart Report.' Follow the wizard to create a PivotTable.
4. Click 'Layout' in Step 3 of 3. Depress the left mouse key and drag the 'Name' button to the Row field, the 'Sales' button to the Data field, and the 'Month' button to the Column field. Click 'OK.'
5. Choose an empty cell in column A and so that it gets entered in the box on Step 3. Choose 'Existing Worksheet.' Click 'Finish.'
6. Select the first cell of the pivot table. Click 'Insert' on the menu. Click 'Name,' 'Define' and enter a name for the table. Click 'OK.'
7. Pick an empty cell. 'Type =GETPIVOTDATA.' Insert a '(' followed by the name of the table, then the calculations to be shown in the cell. Type a single name and month to get the sales total for that month, or a single name or month to get the total sales for that name or month.

Read more ►

How to Use the Find the Method in Excel 2003 Using Visual Basic

1. Launch Excel 2003.
2. Open the 'File' menu at the top of the screen and click 'Open.' Double-click the spreadsheet that needs to use the 'Find' method.
3. Click the 'Tools' menu at the top of the window and scroll down to the 'Macro' entry. Click the 'Visual Basic Editor' entry in the sub-menu.
4. Click the name of the worksheet you need to use in the list of worksheets at the left side of the screen. Click inside the code editor screen at the left side of the window.
5. Type the phrase 'Sub Finding()' at the top of the screen to let the Visual Basic editor know where the code should begin. The word 'Finding' can be replaced with anything you'd like, such as 'Sub MyFindCode()' or something similar. Tap 'Enter' twice and type 'End Sub' to let the editor know where your code ends.
6. Move the cursor in between the 'Sub' and 'End Sub' headings. Type 'Cells.Find().Activate' to tell the editor to use the 'Find' method. Move the cursor inside the '()' portion of the 'Find' method and use the 'What' argument to indicate what you are looking for. For example, the code should read 'Cell.Find(What:='555').Activate' if you want to find a cell containing the numbers '555.'
7. Fill in the remaining arguments for the 'Find' method to let the editor know to search the entire worksheet for the specified numbers or letters. For example, if you want to search for '555,' your entire line of code should read 'Cells.Find(What:='555', After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate.'
8. Click the green arrow icon labeled 'Run' at the top of the screen to use the 'Find' method and locate the cell containing the numbers or letters.

Read more ►

How to Find the Weighted Mean in Excel 2007

1. Input your data points into column A in your Excel 2007 worksheet, one number per cell. For example, you might input the numbers 90, 86, 45, 67, 78, 76, 79, 82.
2. Input the weight of each of the numbers in column B. The weight of each number should sit directly to the right of the number. The weights you choose do not matter, they are only meaningful relative to each other. For example, if a data point has a weight of 1 and another point has a weight of 2, the second point will be twice as important to the mean, but if both data points have a weight of 2, they will be identically important. The weights might be 1, 1.5, 2, 1.25, 3.6, 4, 2, 1.
3. Write '=A1*B1' (without quotes) in cell C1.
4. Left-click cell C1 to highlight it, then press 'Ctrl C' to copy it.
5. Highlight column C by clicking the letter 'C' above the column, then paste the formula by pressing 'Ctrl V.'
6. Type '=SUM(C:C:) / SUM(B:B)' (without quotes) in cell D1 to find the weighted average. In the example, the weighted average is 74.47 (rounded).

Read more ►

How to Calculate a Standard Error Regression

1. Open Microsoft Excel 2007. Input your data into the spreadsheet into two columns. You should have known values for y (your dependent variable) and each independent variable.
2. Go to the 'Data Analysis' command under the 'Data' tab on the user interface. If you do not have this function, you must add it in. To add the analysis to Excel, go to the 'Microsoft Excel' button in the right-hand corner of your screen. Go to 'Excel Options and Add-ins.' Select the 'Data Analysis' toolpak. Download to your Excel program.
3. Select 'Data Analysis.' A list of statistical choices will appear. Choose 'Regression.'
4. Input the data in the correct ranges. A box will prompt with an input for Y-range and X-range. In addition, select where you want the results to appear, on a separate worksheet or the same worksheet. If you want the results to appear on the same worksheet, select 'Output Range' and highlight the cells you want the results to appear on.
5. Click OK and look at the summary output. There will be a list of the regression results, including the standard error.

Read more ►