1. Open the Excel 2007 file where you want to create 20 random numbers.2. Click an empty cell that has another 19 empty cells directly beneath it.3. Type '=rand()*(y-x) x' into the formula bar. Replace 'x' and 'y' with the range of numbers that the random number will fall between. For example, '=rand() (10-1) 1' will return a random number between 1 and 10. Press 'Enter.'4. Click the cell with your formula in it, which now displays a random number. Move your mouse over the bottom-right corner of the cell, where the pointer turns into a plus sign. Click the mouse button and hold it down....
Browse » Home » All posts
Saturday, January 14, 2012
How to Use Excel 2007 to Make a Climograph
1. Open a new worksheet in Excel 2007. Create three column headings: Month, Temperature and Precipitation.2. Enter 12 rows of data consisting of the 12 months of the year in the first column and the mean monthly temperature and precipitation amounts for each month in the second and third columns, respectively.3. Click and drag the mouse across your entire range of data in all three columns.4. Click on the chart button in the toolbar to start the Chart Wizard. Select a clustered column type chart and click 'OK.' You will see the data grouped in two rows of vertical columns.5. Right-click...
How to Convert a Column to All Caps in Excel
1. Open the Microsoft Excel document that contains the column of data that you want to convert to all caps. Open a second blank Microsoft Excel document as well.2. Highlight the entire column in the Excel document that you want to convert to all caps. Note that if you want to convert several columns to all caps, you must repeat this process for each column; you can only change one column at a time using this method.3. Right-click the highlighted data and select 'Copy.' Minimize the Excel document and maximize the blank Excel spreadsheet.4. Right-click in cell 'A1' in the top left corner...
How to Protect Cells in Microsoft Excel
Microsoft Excel 20071. Open your spreadsheet in Microsoft Excel.2. Select any cells you do not want protected. Right click on them and click 'Format Cells.' You can skip this step if you will be protecting the entire sheet or workbook.3. Select the 'Protection' tab. The 'Locked' option will automatically be checked, but the cell is not protected yet. Click on the box to remove the check mark so that group of cells will not be locked when you protect the sheet.4. Click on the 'Review' menu. Look for the 'Changes' section on the right side and click 'Protect Sheet' to protect only that sheet...
Friday, January 13, 2012
How to Succeed in Business With Microsoft Excel 2003
1. Visit Microsoft Office's website and click 'Excel' under the 'Support' menu item, and then choose the 2003 version.2. Learn as much as you can about how to use Excel through Microsoft Office's online tutorials (see Resource section). These courses are free on the company's website, and they will help you learn how to use the software in detail.3. Click the 'Templates' link on the Microsoft Office home page and then click 'My Programs.'4. Select 'Excel 2003' from the programs list and click 'Save.' This limits your online search to compatible templates. Search through the links provided...
How to Block Access to an Excel 2007 Worksheet
1. Open your worksheet in Excel, just as you would normally.2. Click the top-right 'Windows' orb, hover your mouse pointer over 'Save As' and select 'Excel Workbook.'3. Click 'Tools' at the bottom of the 'Save As' window and select 'General Options.'4. Enter the password you would like to use next to 'Password to Open' and click 'OK.'5. Re-enter your password and click 'OK.'6. Click 'Save' and choose 'Yes' when prompted to save it over the existing fi...
How to Create an Input Box in Excel VBA
1. Click the Windows 'Start' button, 'All Programs,' 'Microsoft Office,' and the program you want to use to create an input box. After the software loads, open your document.2. Click the 'Developer' tab or menu item.3. Click 'VBA' to open the coding editor and locate the function or section of your file you want to use to display the input box.4. Type the following code to create the input box: 'Dim input As String input= InputBox(Prompt:='Enter your name', Title:='Name Input')' This code displays an input box for the user to enter a name. The name stores in the 'input' variab...
How to Create a List Box to Select Multiple Entries in Excel 2003
1. Enter the data you wish to format as a drop-down list within a single row or column. Make sure it is a single block of cells such as A2:A6.2. Highlight the cells in your list. Click the 'Name' box next to the 'Formula' bar and enter a name for your list. Click 'Enter.'3. Click 'Validation' from the 'Data' tab. Highlight the cells for which you created the list. Choose 'List' from the 'Validation' box. Type a '=' sign before the name of your list within the 'Source' box and click 'O...
How to Create a Multiple Baseline Graph in Excel 2010
1. Type the label for your first baseline into cell A1. Type the label for your first intervention into cell B1, the next baseline in C1 and the next intervention in D1. Continue for as many baselines and interventions as you want to show in your graph.2. Enter the data for the first baseline in column A. Enter the data for the first intervention in column B starting on the first row after the last entry in column A. Accordingly, you will have blank cells in column B where there is data in column A and blank cells in column A where there is data in column B. Continue for all of the columns...
Thursday, January 12, 2012
How to Name a Field in Excel 2003
1. Open the Excel Workbook that contains the field you want to name.2. Select the cell, column or row you want to name. Select a cell by clicking it. Select a column by clicking the column letter at the top of the spreadsheet. Select a row by clicking the row number on the left side of the spreadsheet. Select disconnected cells, columns or rows by holding down the 'CTRL' key while you make your selections.3. Select a range by clicking and dragging to include cells. Select disconnected ranges by holding down the 'CTRL' key while you make your selections.4. Find the name box in the spreadsheet....
How to Add Multiple Cells in Microsoft Excel 2003
1. Before you can add multiple cells, you need to define the area. You can easily do this by left-clicking on the desired cell and dragging the mouse cursor over the area where you wish to add cells and then releasing it. The selected area will stay highlighted.2. Right-click on the highlighted area to access the Cell Properties submenu.3. Add desired multiple cells. Scroll to “Insert” on the Cell Properties submenu and left-click to insert or add multiple cells.4. Set cell rotation for the addition of cells. A cell insert properties box will open, in which you can select the rotation...
Wednesday, January 11, 2012
How do I Use VLookup in MS Excel?
1. Type '=VLOOKUP(' into the cell in that you want the result of this function to be displayed. Don't include the quotation marks.2. Type in the value that you want the function to look for, followed by a comma. You can either type it in as a literal value. If it is text, make sure to enclose it in quotation marks. You can enter a cell reference.The function will search for whatever value is contained in the cell you refer to.3. Enter the cell reference for the range of cells comprising the table, followed by another comma. For example, if your table consists of cells A1 through E10, enter...
How to Use Less Than or Equal to Function in Excel
1. Select the cell to display the calculated result and insert the function for the comparative formula (by selecting 'Function' under 'Insert' in the top menu bar). Make sure to review the format of the formula in the dialog box to identify the information to be entered. For example, the formula format for IF is '=if(logical_test, value_if_TRUE, value_if_FALSE)' where the logical test is the comparative rule or conditional criterion, value-if-TRUE generates a response when both conditions match and value-if-FALSE generates a different response if both conditions do not match.2. Type '(' and...
How to Insert a Microsoft Graph Chart in a Publisher Document
How to Insert a Microsoft Graph Chart in a Publisher Document1. Open Publisher by double clicking on the Publisher Icon.2. Go to the File pull-down menu and click once on new.3. Go to the Insert pull-down menu. Click on it.4. Click once on Object. An Insert object menu will pop up.5. Choose on the Create from file option. You will see two options: Create new or Create from file. You would have chosen Create new if you wanted to create a new Microsoft graph chart. Since we are working on the assumption that you have a graph chart that you have already created and want to import it from...
How to Insert Excel Data Into a Word 2007 Table
1. Open the Microsoft Word and Excel 2007 files. Locate the files from both software programs on the computer hard drive and double click on the file icon to open each.2. Create the table in the Word document. Choose the 'Insert' tab and from that menu ribbon select 'Table' option. Next, choose the appropriate size of the table to insert in the Word document.3. Highlight the data in Microsoft Excel to insert in the Word 2007 table. Left click the mouse and while holding the mouse button down, highlight the data in Microsoft Excel.4. Copy the data from the Excel document. With the data...
Subscribe to:
Posts (Atom)