1. Open the spreadsheet that contains the data that you want to round up.2. Right-click the column heading of the column directly to the right of the column that contains the data that you want to round.3. Click 'Insert' in the pop-up menu to insert a new column to the right of the data column. You'll use this column to store the rounded version of your original data.4. Click the cell that is directly to the right of the first value that you want to round up.5. Type the following function in the cell: =ROUNDUP(B1,1)Substitute the address of the first to-be-rounded data cell in place...
Browse » Home » All posts
Thursday, June 28, 2012
How to Merge Cells With Different Formulas in Excel
Concatenate Function1. Open the Excel file in which you want merge cells.2. Right-click on the column header directly to the right of the columns to be merged. For example, if the A2 contains 'First name,' B2 contains 'Middle name,' and C2 contains 'Last name,' right-click on the header for Column D.3. Select 'Insert' from the menu that opens. This will move all columns to the right and will insert a blank column that will become the new Column D.4. Click in cell D1 and type 'Full name.'5. Click in cell D2 and type the following formula:=CONCATENATE(A2,' ',B2,' ',C2)This formula will...
Wednesday, June 27, 2012
How to Import Data From MS Word to MS Excel
1. Open the Microsoft Word document. Click the 'File' tab in Word 2010, 'Microsoft Office Button' in Word 2007 or 'File' menu in Word 2003. Click 'Save as.' In the 'Save as Type' menu, select 'Plain Text,' then click 'Save. This will save the Word document as a text file that Excel can read. It will remove any formatting you added in Word.2. Open a blank worksheet in Microsoft Excel.3. Click 'File' or the 'Microsoft Office Button, then 'Open.' Select 'Text Files' from the file type list. Select the text file you just saved and click Open.' Excel will automatically launch the Import Text...
Tuesday, June 26, 2012
How to Use a ListView Control
1. Open Microsoft Excel.2. Click 'Tools,' 'Macro' and then 'Visual Basic.' This will open the VBA editor.3. Click 'Insert' and 'UserForm.' This will place a UserForm on your screen, including the VB ToolBox that contains the controls to use on the UserForm.4. Add the ListView object onto the ToolBox by clicking 'Tool' and 'Addition Controls.' This opens the ActiveX control box. Scroll down and select 'Microsoft Listview Control' and click 'OK.' This will add the ListView object to the ToolBox.5. Select the 'ListView' from the ToolBox and draw it onto your UserForm.6. Double-click on...
How to Use the BINOMDIST Function in Microsoft Excel
1. Start Microsoft Excel. You can do this by clicking on Start, highlighting Programs, and clicking Microsoft Excel, or double-clicking the Microsoft Excel icon on your computer's desktop.2. We just need one cell for this function, so we will use cell A1. Select cell A1. At the top of the screen, click on Insert, and click on Function. Type BINOMDIST in the Search for a function dialog box, click Go, and click OK. Note that you do not want to choose NEGBINOMDIST since it is a separate function. It is the negative binomial distribution, which deals with the probability of a number of failures...
Monday, June 25, 2012
How to Improve the Print Resolution of Excel Charts
File Prep1. Finish drawing up your Microsoft Excel chart as you would normally.2. Expand the size of the chart if necessary by grabbing a corner of the image with your mouse and dragging it outward.3. Position the chart on the page exactly as you want it to look when it is printed. Confirm that the chart is positioned inside of the printable page by choosing 'Print Preview' from your menu.Acrobat Method4. Go to your Acrobat tab in Excel. Select 'Preferences' and then 'Advanced Settings' to check the resolution. If you are using Adobe's online PDF creation tool, called 'CreatePDF,' go to...
How to Sort a Row or Column in Excel 2003
1. Open your Excel worksheet after logging on to your computer. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.2. Click on any cell within the range of cells you would like to sort. Go to 'Data'. Select 'Sort' from the appearing menu.3. Choose 'Options'.4. Select 'Sort Left to Right' from the displayed 'Orientation' menu. Choose 'OK'.5. Select the rows to sort from the 'Sort By' and 'Then By' boxes. Sort one column without affecting others by clicking the column heading of the column to sort.6....
Sunday, June 24, 2012
How to Disable a Hyperlink Warning in Excel 2003
1. Click 'Start.' Select 'Programs' or 'All Programs' and click 'Run' in the 'Accessories' folder. The 'Run' pop-up dialog window will open.2. Type 'regedit' in the 'Run' dialog box and click 'OK.' The 'Registry Editor' will open.3. Navigate to 'Hkey_Current_User >Software >Microsoft >Office >11.0 >Common.' Click 'Edit' at the top of of the 'Registry Editor' window and select 'New,' then 'Key.'4. Type 'Security' in the 'New Folder' field and press 'Enter.' Click 'Edit' at the top of of the 'Registry Editor' window and select 'New,' then 'DWORD Value.'5. Type 'DisableHyperlinkWarning'...
How to Calculate PMT in Excel
1. Open Excel 2010, and click the 'fx' button on the formula bar. Type 'PMT' to locate the PMT function. Press 'Enter' on the keyboard. Click the 'PMT' function.2. Add the variables to the PMT function. Enter the current interest rate for the loan in the 'Rate' section. Enter the number of payments in the 'Nper' section.3. Enter the present value of the loan in the 'PV' section. Click 'Ok' to see the loan payment appear in the Excel workshe...
How to Set a Default Format for Excel Charts
1. Open Microsoft Excel by opening the 'Start' menu, clicking 'All Programs,' opening the 'Microsoft Office' folder and then clicking on the Microsoft Excel icon.2. Click the tab labeled 'Insert' at the top of the Microsoft Excel window.3. Click the 'Create Chart' button on the bottom-right of the 'Charts' section on the Insert tab, below 'Other Charts.'4. Select the chart type that you would like to use from the preset templates.5. Click 'Set As Default Chart' to set the selected chart as the default format of all created charts. Click 'OK' to save your changes and to exit the wind...
Saturday, June 23, 2012
How to Use Excel for Project Timelines
1. Open the Excel worksheet.2. Click the 'Insert' tab on the command ribbon.3. Click the 'SmartArt' button in the 'Illustrations' group. A dialog box with a list of commands and timeline diagrams appears.4. Click 'Process' in the list.5. Click the preferred timeline diagram.6. Click 'OK.' A 'SmartArt Tools' ribbon appears. The timeline template appears on the worksheet.7. Type the text in the '[Text]' area. A text pane appears to the side. If the text pane does not display, click the left-arrow control on the side of the timeline to open. The text box can display dates, events or...
How to Record a Macro in Excel 2003
1. Open Excel. Either open the program itself or open an existing file.2. Set your security level. Go to 'Tools > Options.' Go to the Security tab and click on 'Macro Security.' Go to the Security Level tab and change the level to medium or low.3. Go to 'Tools > Macro.' Choose 'Record New Macro' from the options.4. Type a name into the macro name box.5. Type the location of the macro into the box labeled 'Store Macros In.' Click 'OK.'6. You are ready to begin recording your macro. Perform the series of tasks you would like to create the macro for.7. When you are finished, click...
How to Turn a Picture into a background or watermark
1. Open the MS Word program.2. Click the 'Page Layout' tab on the command ribbon.3. Click the 'Custom Watermark' option. A 'Printed Watermark' dialog box opens.4. Select the 'Picture watermark' option. The 'Select Picture' button becomes accessible.5. Select the 'Picture watermark' option. The 'Select Picture' button becomes accessible.6. Click the 'Select Picture' button. The picture library file opens.7. Select the picture file.8. Click 'Insert.'9. Select the scale value. For example, 50 percent.10. Select the check box for 'Washout' if you prefer a very faint watermark effect.11....
How To Freeze All Top Cells In Excel 2003
1. Open your Excel spreadsheet. You can open a spreadsheet by double-clicking the XLS file on your computer, or you can open in the 'Open' dialog box when you click the 'Open' icon at the top of your window.2. Click the row letter on the left of the spreadsheet to highlight the row you want to freeze. To highlight more than one row, hold the 'Ctrl' key and click each row letter with your mouse.3. Click the 'Window' menu item. Click 'Freeze Panes' to freeze the rows. Scroll down the spreadsheet. Notice the rows you froze are always displayed at the top of your workspa...
How to Compare Multiple Groups of Cells in Excel
1. Open the Excel 2010 spreadsheet that holds the cell groups you want to compare.2. Decide which group of cells will be the main group, which all other groups will be compared against.3. Click the top left cell in the second group of cells. Hold the 'Shift' key and click the bottom right cell from that group. This will highlight the entire group of cells.4. Click the 'Home' tab at the top of the screen, then click the 'Conditional Formatting' button and choose 'New Rule' from the drop-down menu.5. Click 'Use a formula to determine which cells to format' at the top of the New Formatting...
Subscribe to:
Posts (Atom)