Thursday, January 24, 2013

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 w...
Read more ►

Wednesday, January 23, 2013

How to Animate a Cell in Excel 2007

Download and Install the 3-D Animation Engine1. 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.Animate5. Open the Excel...
Read more ►

How to Make an Excel Template a Read

Excel 20031. 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....
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...
Read more ►

Tuesday, January 22, 2013

How to Use Excel for Correlation

Measuring Correlation With Excel1. 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,'...
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 'Rese...
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...
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 'O...
Read more ►

Monday, January 21, 2013

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...
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,...
Read more ►

Sunday, January 20, 2013

How to Use Excel for Birthdays

Arrange Your Spreadsheet1. 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...
Read more ►

Saturday, January 19, 2013

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' butt...
Read more ►

Friday, January 18, 2013

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 fil...
Read more ►

How to Insert an Excel Spreadsheet Into Word

1. Open the Word document into which you want to insert an Excel spreadsheet. Open the worksheet in Excel that you want to insert into Word.2. Use your mouse to select the data on the Excel worksheet that you want to insert into the Word document. Copy the selected data using the keyboard shortcut 'Ctrl C' or by clicking the 'Copy' button on the standard toolbar in Excel 2003 or on the 'Home' tab in Excel 2007 or 2010.3. Place your cursor in the Word document where you want to insert the Excel worksheet.4. Click 'Paste' on the formatting toolbar in Word 2003 and then click the Paste Options...
Read more ►

Thursday, January 17, 2013

How to Create a Project Plan Template

Excel 20101. Open Excel 2010 and select the 'File' tab on the ribbon. Type 'project plan' in the search box. Excel will display the available project plan templates.2. Click the templates to see a preview of them. Download the template by clicking the 'Download' icon in the right task pane. The template downloads to your computer.3. Type your project details in the action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar.Google Documents4. Access the Google Documents website. Click 'Create New'...
Read more ►

Blogger news