Install the Microsoft Office Compatibility Pack1. 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...
Browse » Home » All posts
Sunday, May 13, 2012
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...
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...
Saturday, May 12, 2012
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....
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...
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....
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...
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...
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...
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 delet...
Friday, May 11, 2012
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...
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...
How to Remove Add
Delete Toolbars1. In Excel 2007, point to the toolbar you want to remove with your mouse.2. Right-click with your mouse.3. Select 'Delete.'Hide Toolbars4. 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 na...
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...
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...
Subscribe to:
Posts (Atom)