How to Use an Excel Rand

1. Open Microsoft Excel and create a blank spreadsheet, if one doesn't open automatically.
2. Double-click in the cell that you want to create a random number in.
3. Type '=Rand()*(b-a) a' (without quotes) to create a random number between and including the smallest number 'a,' and the largest number 'b.' For instance, if you want to create a cell that displays a random number between 0 and 100 every time you recalculate the spreadsheet, you'd type '=Rand()*(100-0) 0.' This number can then be used in other calculations throughout the sheet, in order to test how certain functions respond to randomly generated values.

Read more ►

How to Make a Word Search With 2007 Microsoft Excel

1. Change the page orientation to landscape. Click on 'Page Layout,' then 'Orientation,' then 'Landscape.'
2. Add a header and footer. The header is for the title and the footer is for the word list. Click on 'Insert' and then click on 'Header and Footer.'
3. Add a title for your word search. For example, 'States.'
4. Highlight cells A1 to N15 by left clicking on cell A1, then dragging the mouse to cell N15.
5. Click on the 'Home' tab, then click on 'Format,' then 'Column Width.' Type '0.25' into the text box and then press 'OK.'
6. Add a border by right clicking on the cell, then clicking on 'Format Cells.' Click on the 'Border' tab, then click on a border icon. Click on 'OK.'
7. Enter words into the cells, one letter at a time. In the above example, you might enter 'T' into cell A1, 'E' into cell A2, 'X' into cell A3, 'A' into cell A4, and 'S' into cell A5. Continue typing in words until the word search is complete.
8. Fill in any blank spaces with random letters of the alphabet.
9. Click on the footer, then type the word list for the entries you made into the word search.

Read more ►

How to: Find and Replace in Excel 2007

1. Open Excel 2007. Open the spreadsheet you want to edit.
2. Press the 'Ctrl' and 'H' keys simultaneously to open the 'Find and Replace' dialog box. Click the 'Find' tab.
3. Type the string of characters you want Excel to find into the 'Find What' input box.
4. Click 'Find Next' to find the next instance of the character string, or click 'Find All' to find all instances of the string.
5. Click the 'Replace' tab. Type the characters you want to find into the 'Find What' input box.
6. Type the replacement text into the 'Replace With' input box.
7. Click either 'Replace Next' or 'Replace All' to replace the characters one at a time or en masse, respectively.

Read more ►

How to Use Microsoft Excel 2003 With Vb.Net

1. Open VB.Net. Click 'File,' 'Open' and browse to your VB.Net project. Double-click the project file to open it.
2. Click the 'Project' link from the 'Tools' menu. Click 'References.' Check the box next to 'Microsoft Excel Object Library.' Click 'OK.'
3. Click 'Caption.' In the 'General Declaration' window type the following code:Option ExplicitPrivate appExcel As Excel.ApplicationPrivate wBook As WorkbookPrivate mySheet As WorksheetReplace mySheet with the name of your own Excel spreadsheet.
4. Click 'File,' 'Save' to confirm the changes you have made to Excel.

Read more ►

How to Reduce the Size of Excel Files

1. Remove unnecessary graphics and fonts from the Excel file. Simple report data doesn't need a lot of excess formatting to make it attractive. If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
2. Reduce the number of pivot tables you allow in your data analysis. Run your pivot table wizard when dealing with involved calculations. When given options to format the file, choose those that allow the data to refresh instead of adding a new table.
3. Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file. To do this, choose 'XML Data' in the 'Save as type' drop down box. Change the name of your document as well, so you can tell the difference between the two files.
4. Open the XML file and save it back into the regular XLS file to create a smaller file than the original. Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last 'save.'
5. Check into file compression software such as OzGrid. These products exist because you cannot open a file once it gets too big. Compress the XLS data by compelling the program to recalculate the cells used for your file.

Read more ►

How to Display Fractions in Excel 2003

1. Open Excel by going to the 'Start' menu, pointing to 'Programs' or 'All Programs', and clicking on 'Microsoft Excel' in the 'Programs' list. Or you can open Excel by double-clicking a shortcut icon on your desktop or task bar.
2. Open a blank or existing worksheet. Select the cells you will want to use to enter fractions by clicking on one of the outer cells in that range, holding down the left mouse button and dragging your mouse across the range of cells that you want to select. If you only want to format a single cell, simply click on that cell.
3. Click on 'Format' in the toolbar. Click 'Cells'. The 'Format Cellsw' dialog box will open. Make sure you are on the 'Number' tab.
4. Click 'Fraction' in the 'Category' list. Under 'Type', choose how you want your fractions displayed. You can choose up to one, up to two or up to three digits, or take it even further and choose 'As Halves', 'As Quarters' and so forth, which will round your fraction the the nearest, half, quarter or whatever you choose.
5. Click 'OK'. When you enter your data into the cells you formatted, your fractions will now appear just as you defined.

Read more ►

How to Capitalize the First Letter of Names in Excel 2007

1. Right-click on the column header that sits atop the column of names you want to capitalize. Choose 'Insert' from the menu that appears. This creates a new blank column to the left of the names.
2. Select the cell in the new column that is directly to the left of the first name you want to capitalize.
3. Enter this formula into the cell: '=Proper(XX)' without the quote marks, where the 'XX' is the column letter, followed by the row number of the cell directly to the right of the one you are entering the formula into. Press 'Enter' to place the formula into the cell. The capitalized name appears in the cell.
4. Select the cell that you've just entered the formula into. Move your mouse to the bottom-right corner of the cell, where the mouse pointer turns into a plus sign. Click and hold the mouse button, then drag the mouse down the column to the cell that contains the last name you want to capitalize. Release the mouse button and all the capitalized names fill in the empty column.
5. Right-click anywhere in the column that holds the formulas. Choose 'Copy' from the pop-up menu.
6. Select the first cell of the original list of names. Right-click the cell and move your mouse over 'Paste Special.' Select 'Values' from the list of options that appear. All of your original names are now capitalized.
7. Right-click on the column letter above the column that contains the PROPER formulas. Select 'Delete' from the menu.

Read more ►

How to Convert From Excel 2007

1. Open the Excel file you'd like to convert. Do this by clicking it twice. This will open up the contents of the file in Microsoft Excel 2007.
2. Click the 'Office' logo button in Excel's top left corner.
3. Click 'Save As.'
4. Select the format you'd like to convert your file into. Each option that you have will be laid out on screen. The different file formats will be accompanied by a brief description as well as what programs they can be used with, so choose a format based on your own needs.Formats available include the Excel 97-2003 workbook, which can be opened with earlier versions of Microsoft Excel, the OpenDocument Spreadsheet, which can be opened with the program Open Office; the PDF format, which can be opened with Adobe Reader; and the XPS format, which can be opened with Microsoft Works.
5. Click 'Save As' to convert your Microsoft Excel 2007 file into the format you've chosen.

Read more ►

How to Save a Worksheet as HTML in Excel 2003

1. Log on to your computer and open your Excel database. 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. Go to 'File'. Select 'Save as Web Page'. Choose the folder in which you want to save your document.
3. Type your file name for your worksheet web page. Be descriptive, but concise so it is easy to identify the information in your file.
4. Choose to save your 'Active Sheet' or the entire file. Click 'Save'. Your document is now ready for the web.

Read more ►

How to Animate a Cell in Excel 2007

Download and Install the 3-D Animation Engine
1. Download the 3-D Animation Engine for Excel---you cannot animate your cells without it (see References).
2. Select your correct Internet connection from the drop-down menu next to 'Estimated Download Time:' and click the 'Download' button in the upper left-hand corner of the Quick Details information box.
3. Save the download file to your computer's desktop and double-click on the saved file to activate the installation.
4. Install the 3-D Animation Engine, following the prompts provided by the installation wizard.
Animate
5. Open the Excel Binary Workbook that was downloaded when you installed the 3-D Animation Engine.
6. Insert the object you wish to animate by clicking on the 'Insert' tab from the Microsoft Office Fluent Ribbon on the Binary Workbook. Select 'Illustrations,' and click 'Shapes.'
7. Pick your shape and click 'Animate!'
8. View the animation by placing a check in the 'Step Run?' check box and clicking 'Animate!' again.
9. Change the shape's direction by clicking 'Reverse' if you wish. You may also change other parameters of the object by using the Parameter Table in the upper left-hand corner of your worksheet.
10. Click 'Export to Light' once you are satisfied with the animation of your shape.
Create Lighting Effects
11. Open the Lights worksheet to apply lighting and shadow effects to your shape. Your object will automatically appear when you open the Lights worksheet.
12. Click 'Shed Light.'
13. Adjust the light's reflection on your object by using the sun controls on the left-hand side of the worksheet.
14. Apply different textures to your object using the controls on the top of your worksheet.
15. Color your object with the color controls, and click on the shadow controls at the bottom of your worksheet to create mysterious shadow effects.
16. Click 'Snap' and name your object when you are finished adjusting the lighting effects.
Generate Visual Basic Code
17. Open the Recorded Tracks worksheet and your newly-named object.
18. Open your Visual Basic Editor by pressing on 'Alt' and 'F11' at the same time.
19. Select the Microsoft Office Button in the upper left-hand corner of your screen and click on 'Excel Options.'
20. Ensure that the 'Show Developer tab in the Ribbon' button is selected from the Popular submenu and click 'OK.'
21. Click on the 'Developer' tab and select 'Module2.'
22. Press 'F5' to run the code after placing your cursor at the beginning of the Immediate window where the Visual Basic code is shown.
23. Copy and paste your Visual Basic code results, after they have run, into the cell in your Excel spreadsheet to run your animated object.

Read more ►

How to Make an Excel Template a Read

Excel 2003
1. Click on 'Tools' in the toolbar, then highlight 'Protection' by hovering over it with your mouse. Select 'Protect sheet' from the menu that appears.
2. Make sure none of the boxes in the list that appears have check marks except the top box that says 'Protect worksheet and locked cells.' Click in the boxes to toggle the check marks on or off.
3. Enter a password to ensure you are the only one who can remove the protection, then write down the password and safe it in a secure location. If you choose not to password-protect your change, other users can remove the workbook protection.
4. Click 'OK' to save your changes and protect the worksheet.
5. Repeat the process for each worksheet within the workbook if it has multiple sheets.
Excel 2007
6. Click on the 'Review' tab from the tool ribbon, then select 'Protect document.'
7. Select 'Restrict formatting and editing' from the available options.
8. Select all options for elements you want to protect, such as formatting, data and sorting.
9. Enter a password if you wish to password-protect the workbook limitations. If you do not enter a password, others can unprotect the workbook through the 'Protect document' menu.
10. Click 'OK' to save your changes and close out of the protection dialog box.

Read more ►

How to Create a Pivot Chart in Excel 2007

1. Open the Excel workbook that has the data you want to use to create a pivot chart.
2. Highlight the data you want to add to the pivot chart.
3. Click the 'Insert' tab and look to the 'Tables' section of the ribbon.
4. Click 'Pivot Table' and select 'Pivot Chart' from the drop-down menu. The 'Pivot Chart' dialog box will open.
5. Select a range of cells to add to the chart if you want to include more data than you have already selected. You can also select data from an external source. If you want to do this, check the box next to 'Use an external data source' and then click 'Choose connection.' Select a data source from the box that opens and click 'Open.'
6. Choose where you want the pivot chart to be placed. You can insert the chart in the worksheet you have open or you can insert it in a new worksheet.
7. Click 'OK.' The pivot chart will be inserted in your Excel spreadsheet.

Read more ►

How to Use Excel for Correlation

Measuring Correlation With Excel
1. Enter the data to be analyzed. If you are examining the correlation between two variables, a single variable can represent one column in a spreadsheet. Enter the values of each variable in the cells under the corresponding column.
2. Unlock and install the Data Analysis tool from the Excel add-ins menu. This tool is included in all options of Excel, but must be installed by the user before it can be used. To do this in Excel 2007, click the Microsoft Office help button in the top left corner of an Excel spreadsheet. Then click the button labeled 'Excel Options,' which opens a window with a set of options on the left side. Choose 'Add-Ins' and select 'Analysis ToolPak.' This makes the data analysis tool available for use. In earlier versions of Excel, click the 'Tools' menu and then choose 'Add-ins' and select 'Analysis Tool Pak,' which places the Data Analysis option in your Tools menu for use.
3. Choose the two variables for which you wish to examine the correlation. Selecting the values to analyze in Excel requires you to click on a cell or column and drag your mouse to choose or define the range of values for the two variables under consideration. This means the variables must be adjacent to each other in your Excel spreadsheet.
4. Open the Excel Data Analysis tool (under the Data tab in Excel 2007, in the Tools menu in earlier versions), which opens a window with a set of analysis options. Choose 'Correlation' and click 'OK.' This opens the Excel correlation wizard, which asks you to enter the range of data to be analyzed by clicking a column or cell and dragging. For example, if the two variables you want to analyze are in columns A and B in your spreadsheet, then click and drag across these two columns and down the rows until all values are included. Click 'OK' when you are finished.
5. Examine the value of the correlation coefficient, which Excel will display in a new worksheet. Remember that correlation signifies a relationship between two variables, but does not prove causation.

Read more ►

How to Reset Excel 2003 Keyboard Commands

1. Launch Microsoft Excel 2003. Click 'Tools' and then 'Customize.'
2. Select the 'Commands' tab from the menu.
3. Select 'Rearrange Commands.'
4. Click the command menu you want to reset.
5. Select 'Reset.'

Read more ►

How to Create a Balance Sheet in Microsoft Excel

1. Go online to the official Microsoft Office Template Download Center. In the left column of the page, under the subheading 'Collections,' click 'Finance and accounting.'
2. Select 'Balance Sheets' under the 'Accounting' section in the middle of the page.
3. Browse through the available balance sheet styles and choose the one that best suits the needs of your business.
4. Click the title of your chosen template and click the 'Download' button. Accept the Microsoft service agreement to begin downloading.
5. Open the template in Microsoft Excel. Customize the layout for your business by adjusting the colors, font size and type and text.
6. Enter all of the data about your current and fixed business assets. Enter all of your current and long term business liabilities. Enter any equity or capital your business may have.

Read more ►