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 ►

How to Remove the Date From a Cell on an Excel Spreadsheet

1. Right-click on the cell.
2. Choose 'Format Cells'.
3. Click on the 'Number' tab. Click on a number format that you would like. For example, choose 'decimal'.
4. Press 'OK'.

Read more ►

How to Create an Excel Formula

1. Start Microsoft Excel and open the file you want to change.
2. Double-click on the cell where you want the total to appear.
3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
4. Enter the formula, then press Enter. Follow the steps below for an example.
5. Enter an opening parenthesis character: (.
6. Enter a cell name. For example: =(E2.
7. Press the key.
8. Enter another cell name and a closing parenthesis character: ). For example: =(E2 E3).
9. Enter a minus sign and a third cell name. For example: =(E2 E3)-E4.
10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.

Read more ►

How to Float a Row on Excel 2007

1. Click the 'View' tab in the Ribbon.
2. Click the 'Freeze Panes' button in the Window group. This opens a drop-down menu. Click 'Freeze Top Row' to freeze the first row at the top of the spreadsheet. All other rows will disappear when you scroll through the spreadsheet, but the first row will stay in place.
3. Select an entire row in your spreadsheet by clicking its number in the left-most column, then click the 'Freeze Panes' button in the Window group. Select 'Freeze Panes' in the drop-down menu. All rows above the selected row will be frozen in place; all others, including the one selected, can be scrolled.

Read more ►

How to Use Excel for Birthdays

Arrange Your Spreadsheet
1. Create a series of columns in Excel for the information you need to track. Potential column headings include First Name, Last Name, Address and Birthday. Make these headings bold to set them apart from the rest of the spreadsheet.
2. Enter the names, birthdays and other information into the spreadsheet under the corresponding columns. Enter the dates in a format that Excel understands. You can access the format options by right-clicking the cell that contains a date. Once that cell is formatted correctly, you can copy and paste it into the rest of the column. This will eliminate the need for you to format the dates again.
3. Use the 'Sort' function in the 'Data' menu of Excel to sort the data by date. This will rearrange the data on the spreadsheet so that birthdays are listed in chronological order. You can choose to sort data in ascending or descending order. For data listed from January through December, select ascending order.
Apply Conditional Formats
4. Create a conditional format so that only birthdays occurring in the next week or month are highlighted on the spreadsheet. To access the conditional formatting tool in Excel 2010, go to the 'Style' menu located under the 'Home' tab of Excel.
5. Click 'Highlight Cells Rules' and 'Manage Rules' from the Conditional Formatting menu. Choose the option to create a new rule.
6. Apply the rule to the entire Excel spreadsheet by checking the cell range selected in the 'Manage Rules' section.
7. Click 'Format only cells that contain' as the rule type and select the option to format by date.
8. Click to select the 'Dates Occurring' option and then select the formatting rule you want to implement, such as highlighting dates occurring next week or this month.
9. Click the 'OK' button to save your changes and apply the conditional format to the spreadsheet.

Read more ►

How do I Create a CSV File in Excel 2003?

1. Open the Microsoft Excel 2003 file. Click 'File' on the top menu.
2. Choose 'Save As' from the list of options.
3. Name your CSV file. Choose a location on your computer in which to save the file.
4. Choose 'Comma Separated Value' from your list of 'Save as type.'
5. Click the 'Save' button.

Read more ►

How to Make My Spreadsheet Look Like an Excel 2003 Spreadsheet

1. Complete your spreadsheet as normal and save it. This copy will be for your future use and is still in 2007 format.
2. Click on the 'Office' button in the upper left corner. This is a stylized version of the Windows logo. Many people mistake it for just a graphic, but several useful functions are hidden beneath it.
3. Click on 'Save as' and then select the option that says 'Excel 92-2003 Workbook.' Give your file a new name. The file extension of this file will be '.xls' instead of '.xlsx,' but you should give it a meaningful name to easily differentiate it from your 2007 files.

Read more ►