Copy Entire Worksheet1. Select the PowerPoint slide in which you want to insert the Excel worksheet. If the slide has multiple content boxes, click the content box where you want the Excel information to appear.2. Click the 'Insert' tab at the top of the PowerPoint 2010 window. Locate the 'Text' field and select the 'Object' button to open the 'Insert Object' window.3. Select the radio button next to 'Create from file' on the left side of the window. Then click the 'Browse' button and navigate to the Excel file that you want to add. Place a check next to 'Link' if you want the image of the...
Browse » Home » All posts
Wednesday, September 25, 2013
How to Get a Percent of a Total on Microsoft Office Excel 2007
1. Use the SUM function to total the values of the cells you want to include in the total. For example, if you want to determine the total of your income for the year and your income for each month is listed in cells A1 through A12, you would use the function SUM(A1:A12).2. If you want to take a percentage of the total, enter in a new cell '=SUM(Cells you want to include)*Percentage.' For example, if you wanted to use the income mentioned in step 1 and find 10 percent of that income, you would enter '=SUM(A1:A12)*0.1.'3. If you want to use a percentage found in another cell, enter that cell...
How to Make a Chart in Excel 2003
1. Open your workbook in Microsoft Excel 2003 and select the spreadsheet containing the data you want to chart.2. Highlight the cells containing the data you want included in the chart.3. Click 'Insert' in the top menu bar and select 'Chart' to launch the Chart Wizard tool. You can also click the 'Chart Wizard' button on the Standard toolbar.4. Select the 'Standard Types' tab in the dialog box that opens.5. Select a general chart type (such as 'Bar' or 'Pie') from the 'Chart type' menu and then select a specific style from the adjacent 'Chart sub-type' menu. You can view a live preview...
Copy Pasting in Excel 2007 Freezes My Computer
Detect and Repair1. Open a new document in Microsoft Excel 2007.2. Click on the 'Help' tab on the program's task bar. In the drop-down menu, scroll down to the program called 'Detect and Repair.' Click the program to begin it.3. Allow the 'Detect and Repair' program to run. Hopefully, the program will fix any errors you have with your Microsoft Excel 2007 program. If the error persists, move onto the next section.Edit Your Registry4. Click the 'Start' menu and scroll up to 'Run.' Type in 'regedit' in the box and press 'Enter.'5. Scroll through the folders until you find the pathway that...
Tuesday, September 24, 2013
How to Extend the Microsoft Excel Record Limit
Open a New Worksheet1. Open Excel and the worksheet you have hit your record limit on.2. Click on the 'Insert Worksheet' button located at the bottom of the Excel workbook. The button looks like a folder with a yellow star and is usually located at the end of the worksheet tabs. You can also press the 'Shift' key plus 'F11.' If you do not have function keys, you can also right click on a worksheet tab and click 'Insert.' Select 'Worksheet' to add another worksheet to your book.3. Save your workbook and begin doing computations in your new worksheet.Upgrade to Excel 2007 or 20104. Navigate...
How to Convert Read
1. Open the 'Read-Only' spreadsheet in Microsoft Excel 2007. You can open the file by double-clicking on it from it's current location or in Excel 2007 by clicking on the 'Office' button and then 'Open.' When the 'Open' dialog box open, click on the file and then click 'Open.'2. Click on the 'Office' button and then 'Save As' to begin the process of saving the file in a earlier, editable version. The 'Save As' dialog box appears.3. Click the drop-down arrow next to 'File type as' and choose 'Excel 97-2003' Workbook. Choose a file location for the file and then click 'Save.' Close the workbook.4....
Monday, September 23, 2013
How to Make Three Dimensional Graphs in Excel
1. Open the Excel worksheet that contains the source data.2. Click and drag to select the worksheet's categories and data to appear in the chart.3. Click the “Insert” tab on the command ribbon.4. Click the arrow under the preferred chart type in the “Charts” group -- for example, click “Pie,” “Bar” or “Area.” A gallery of thumbnail charts displays, including “3-D” for three-dimensional options.5. Click a thumbnail chart in the “3-D” section -- for example, click “3-D Bar.” The source data converts to a three-dimensional cha...
How to Use Decimal Numbers in Excel
1. Launch Excel and open the worksheet where you want the number formatting changed to decimals.2. Highlight the cells you want to change. If you want to use a whole column for decimals, click in the shaded box with the column's identification letter, or use the identification number box for rows to highlight the whole row.3. Select multiple cells, rows or columns by holding down the 'Ctrl' key as you click on other cells, rows or columns after your first selection.4. Click the 'Home' tab, and then click in the bottom right corner of the 'Number' section, where you will see a small box...
How to Share Modify Excel Documents
Sharing1. Open your workbook.2. Click 'Review,' then 'Share Workbook.'3. Check the ' Allow changes by more than one user at the same time' and 'This also allows workbook merging' check boxes.4. Click 'Advanced,' then change the settings for tracking changes. Click 'OK.'5. Save the document in a network directory.Modifying6. Open the workbook on the network drive by double-clicking on the workbook.7. Click the 'Office' button, then 'Excel Options.'8. Click 'Popular,' then 'Personalize your copy of Office.' Enter your name in the user name section.9. Edit the data as you normally...
Sunday, September 22, 2013
How to Use Microsoft Excel for Payroll
1. Navigate to the Microsoft Office Payroll Calculator template page (see Resources) and click 'Download,' then 'Accept.' Excel will automatically open to the template when the download is complete.2. Fill out the columns with the information according to the headings above each column. The date you enter will include employee names and IDs, hourly wages, state tax percentage, insurance deductions and other relevant tax deduction information. As you enter the data, Excel will automatically calculate the figures in the 'Total Taxes Withheld' and 'Total Regular Deductions' fields.3. Click...
How to Create a Dashboard in Excel 2007
1. Log on to your computer and open Microsoft Excel 2007. Open the spreadsheet you want to upload.2. Click on the Office button and choose 'Publish' from the list. Choose 'Excel Services' from the list and choose 'Distribute the document to other people'.3. Enter the URL of your website, followed by the name of the file, in the 'File name' box For instance, if you are saving a document called spreadsheet1 to the site xyzcorp.com/reports, you would type 'xyzcorp.com/reports/spreadsheet1.xlsx' in the 'File name' box.4. Click 'OK' and choose 'Save'. In the 'Document type' box choose 'Reports'.5....
How to Import Data With Excel 2007
1. Log on to your computer and open the Microsoft Excel spreadsheet into which you want to export the data. Click the 'Microsoft Office' button.2. Click 'Open' and choose the type of file you wish to export. Double-click the file you wish to import.3. Choose whether the file to be imported is a delimited or fixed-width file. With a delimited file, each field is separated by a particular character, generally a comma, a semicolon or a colon. This type of file is most appropriate for files where each record contains data of varying lengths. A fixed-width file is most appropriate for files where...
How to Import an Excel Macro From 2003
Export from Excel 20031. Press 'Alt' 'F11' together from within Excel 2003 to open the Visual Basic Editor (VBE).2. Click on a macro name in the left sidebar to open the module window.3. Click 'File' > 'Export File.'4. Click the 'Save In' drop-down folder to choose a location to save the file, then click 'Save.'Import the Excel 2003 File5. Open Excel 2007 or Excel 2010.6. Press 'Alt 'F11' together to open the VBE.7. Click 'File' and then click 'Import.'8. Locate the file on your computer and then click 'Ope...
Saturday, September 21, 2013
How to Find the Z
1. Open an Excel worksheet and enter your data in one column. For the purposes of this article, enter sample data into cells A1 through A10, typing a different number in each cell.2. Click on an empty cell below your data and use the “AVERAGE” function to calculate the mean of the numbers you entered. For the example above, you would type “=AVERAGE(A1:A10)” into the formula bar and press 'Enter.' The “A1:A10” part of the formula indicates the range of cells containing the data you want to analyze. The result of the calculation will appear in the cell you selected.3. Click on a different...
How to Add up Multiplications in Excel
1. Launch Excel 2010 and open the spreadsheet that contains the products that you want to add together.2. Click once in the cell where you want the sum of the products to appear. Click the 'Insert Function' button on the Formula bar, which opens a list of available functions. Click the 'SUMPRODUCT' option, which opens a separate window.3. Click the 'Array1' field in the Function Arguments box. Select the range of numbers for which you want to find the sum of the products, for example 'A1:B4.' Repeat this step for each range of numbers, using a different Array field for each group. For example,...
Subscribe to:
Posts (Atom)