Tuesday, April 12, 2011

How to Resize a Chart in Excel

1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart or create a chart from existing Excel data.2. Click on the chart you want to resize so it is selected. A light blue outline will surround the chart when it is selected.3. Point to one of the corners or edges of the selected chart where you see three small dots. Your mouse will turn into a double-headed arrow when you hover over the areas that you can resize.4. Click with your mouse on the edge of the chart where you see the three areas and drag the mouse either outward (to make the chart larger) or inward...
Read more ►

How to Delete a Drop Down Box in Excel

Remove the Drop-Down Only1. Select the cells that have drop-down boxes.2. Click the 'Data' tab and choose 'Data Validation.'3. Remove the check in the box labeled 'In-cell dropdown.' Click 'OK.'Remove Data Validation4. Select the cells that have drop-down boxes.5. Click the 'Data' tab and choose 'Data Validation.'6. Select 'Any value' under 'Allow.' Click 'O...
Read more ►

How to Create a Floating Bar Chart in Microsoft Excel 2003

1. Set up your spreadsheet data with at least two rows of data. One of the rows of data will be what you actually want to show in the graph, and the other data set needs to have values that are less than the data set you want to show.2. Highlight the data set. Click on the 'Insert' menu at the top of the screen, and then click on 'Chart' to bring up the chart options.3. Click on the 'Bar' option from the list of chart type options on the left-hand side to bring up all of the bar chart options. Click on the 'Stacked Bar Chart' option, click 'Next' twice, and then click 'Finish' to build...
Read more ►

How to Solve Linear Programming in Excel

1. Set up the linear program in the form:Maximize c(transpose)xSubject to: Ax ≤ b, x ≥ 0where c, x, A, and b are matrices. The objective function can also be minimized or equal to some number z. The constraints are in linear form. X does not have to have a non negative constraint. These differences in the linear program depend on the specific problem. However, it is imperative that the linear program be set up correctly. Be sure to make all calculations for the cTx, Ax, and b matrices in Excel before you solve the linear program. You can begin by either setting all values of x to 1 or...
Read more ►

How to Sort by Cell Color

1. Click the first cell in the range of cells you want to sort. Drag down and across to highlight each of the cells that needed to be sorted by their color.2. Navigate to the tab labeled 'Data.' Click the 'Sort' button at the left side of the 'Sort and Filter' grouping.3. Click the 'Column' drop-down box underneath the 'Sort By' heading. Select the column in the range you want to sort.4. Select the 'Sort On' drop-down menu and choose 'Cell Color.' Click the 'Order' drop-down menu and select the color you want to sort by, such as 'Green' or 'No Cell Color.'5. Click the final drop-down...
Read more ►

Monday, April 11, 2011

How to Create a Loan Amortization Table in Excel

1. Download the free Amortization Schedule for Excel 1.6 spreadsheet program available by Vertex42 and CNET. The program is designed for the layman and makes it easy to create a loan amortization table that quickly visualizes the relationships between a loan's principal, its time period and interest rate. Once created, the table may be changed by adjusting any of these variables on-the-fly. The flexibility of this template makes it easy to see how the loan is affected by the occasional extra payment. It also demonstrates the consequences of a missed payment. The table supports all the popular...
Read more ►

How to Create Tabs in an Excel Spreadsheet

1. Open Microsoft Excel. There will be multiple tabs at the bottom with the name 'Sheet' and a number for each tab. Each of these tabs is a separate worksheet. Click on the tab to open that worksheet.2. Right-click on the tab and select 'Rename' to change the name on the tab.3. Add tabs to the file by right-clicking on a tab and selecting 'Insert.'4. Copy an existing worksheet as a new tab by right-clicking on a tab and selecting 'Move or Copy.' Choose where to place the new tab and select the copy check box to leave the original tab in its location.5. Rearrange tabs by dragging them...
Read more ►

How to Paste Special in Microsoft Word

1. Start Microsoft Word and open an existing file or start a new document.2. Copy the text you want to paste from another Word file or other application.3. Place your cursor in your open Word document where you want to paste the copied text.4. Right-click and choose 'Paste' from the shortcut menu. You can also use the keyboard shortcut of CTRL V to paste the text into the new location. After you paste, a clipboard will appear at the end of the pasted text.5. Hover your mouse over the clipboard until an arrow appears to the right of the clipboard.6. Click on the clipboard arrow to show...
Read more ►

Monday, March 28, 2011

How to Prevent Excel 2003 From Automatically Converting Dates to Julian

1. Log on to your computer and open Microsoft Excel 2003. Open a new or existing spreadsheet.2. Click the 'Format' menu and choose 'Cells.' Highlight the 'Date' option.3. Click the date format you want to use and click 'OK.' Enter a date in the cell to make sure it displays proper...
Read more ►

How to Convert Excel 2003 AutoFormat PivotTables to Excel 2007

1. Open Excel 2007.2. Click 'File,' 'Open.' Double-click the Excel 2003 workbook that contains the PivotTable. The workbook opens in Compatibility Mode.3. Click the Microsoft Office Button in the upper-left. Click 'Convert.' Click 'OK' to confirm.4. Click 'Yes' and the newly converted workbook will open and is ready to use.5. Click 'File,' 'Save' to confirm the new settin...
Read more ►

How to Write Sideways in Excel

1. Open Excel to a blank spreadsheet or open an existing spreadsheet.2. Click a cell you want to add text to. Click the 'Home' tab on the ribbon if it is not already open. Click the 'Text Orientation' button in the Alignment group. The button has no name but shows the letters 'ab' with an arrow underneath pointing diagonally.3. Select the type of rotation you want. You can select 'Vertical text' to have letters appear vertically one at a time in your cell or select 'Rotate up' or 'Rotate down' to face your text left or right.4. Type the text as you would normally. Press 'Enter' to see...
Read more ►

How to Print Head Rows on Each Page in Excel

1. Click 'Insert.'2. Select 'Header and Footer.'3. Click on the left, center, or right header, depending on which one you want to use.4. Type in your header.5. Print your spreadsheet and the header will display on every pa...
Read more ►

Sunday, March 27, 2011

How to Insert Time Into an Excel Spreadsheet

Static Time1. Select the cell where you wish to enter the time.2. Press 'Ctrl' 'Shift' ';'.3. Click the 'Format' menu and select the 'Cells' option.4. Click the 'Numbers' tab.5. Select 'Time' from the drop-down list and select your preferred format in the second column. You can also create a custom display format. When you're finished, click 'OK.'Dynamic Time6. Select a cell in your spreadsheet and type '=NOW()' into the cell.7. Press 'Enter.' The time and date are displayed in the default format.8. Change the format by following steps 3 to 5 in Section...
Read more ►

How to Add a Column Number in Microsoft Excel 2003

1. Choose a cell on your spreadsheet to display the result of your formula.2. Click the 'Insert Formula' button next to the formula bar.3. Select 'Lookup and Reference' from the drop-down list of function categories.4. Select 'COLUMN' from the list of functions and click 'OK'.5. Provide a reference for the 'COLUMN' formula to use. If you want to use the cell you selected in Step 1, do not enter a reference; if you want to use a different cell, enter that cell's coordinates in the reference box.6. Click the 'OK' button. Your cell will now display the numerical value of the column...
Read more ►

How to Calculate Linear Regression Using Excel

1. Type these data pairs starting in cell c3. For this and the remaining steps, press the 'Tab' key where a comma is shown. These numbers are data pairs collected from a hypothetical science experiment. In this experiment, assume there's the possibility of a linear relationship between 'x,' the first column of numbers, and 'y,' the second column.X, Y1, 5.22, 7.83, 10.74, 13.95, 16.52. Type these additional three columns, starting with the first cell to the right of the cell containing 'y.' These columns are factors in the calculations for the slope, y-intercept and R values of linear equations...
Read more ►

Blogger news