1. Click the 'Start' button in the bottom-left of the desktop. Click 'All Programs' and then click 'Microsoft Excel 2007' to launch the program.2. Click the 'Microsoft Office Button' from the upper-left of the Excel program and then click 'Open.' Click the Excel workbook of choice and then click 'Open.'3. Click the 'Microsoft Office Button,' and then select 'Print' from the drop-down menu. Then click 'Print' again, and click 'Properties.'4. Click the 'Layout' tab and click 'Duplex' or turn on whatever two-sided printing option is available.5. Click 'OK' to print.6. Repeat the steps...
Browse » Home » All posts
Saturday, February 16, 2013
How to Insert Functions in Excel 2007
1. Insert a function into an Excel cell manually by clicking in the cell, typing it in and pressing the 'Enter' key. The AutoComplete menu will pop up as you begin to type the formula. If you do not need it, ignore it. If you are unsure how to enter a function without assistance, use the 'Formulas' menu.2. Insert a function into an Excel cell by selecting the 'Formulas' tab on the Top menu. This is especially helpful if you are unsure what function to use.3. Click the button that most closely describes the action you are trying to perform with the function. A pull-down list of functions...
Friday, February 15, 2013
How do I Recover an Overwritten Excel File?
1. Locate the document that overwrote the old one you want to retrieve. Right-click the file name, then select 'Rename.' A box will pop up with the file name. Add the word 'new' or today's date to make it easier to tell it apart from the file you want to recover. Once you've edited the name, click 'OK' or 'Continue.'2. Download XLS Regenerator (see 'Resources'). This program is made specifically to recover Excel files. Start with the free trial by clicking 'Free trial' on the main page, then following the instructions to download for your operating system. Once it's downloaded, double-click...
How to Name a Column in Excel 2007
Using Name Box1. Click the column heading, such as 'A,' 'B' or 'C,' to select the column you want to name in Excel 2007.2. Go to the 'Name Box' just above column A.3. Type the column's name into the box and press 'Enter.' The column's name displays when you select the column header.Using R1C1 Reference Style4. Click the Customize Quick Access Toolbar button and select 'More Commands' in Excel 2007.5. Select the 'Formulas' tab in the Excel Options window.6. Check 'R1C1 reference style' under the 'Working with formulas' section. Click 'O...
How to Split Excel Data Into Two Columns
Prepare Your Columns1. Open the Excel file with data that you want to split.2. Insert a blank column to the right of the column with data you want to split. For example, if the column you want to split is column F and data exist in column G that you do not want overwritten, insert a new column between columns F and G. To insert a column, click any cell in the column to the right of your data column.3. Click the 'Home' tab on the ribbon.4. Click the 'Insert' button in the Cells group.5. Select 'Insert Sheet Columns' to create a blank column to the left of your cursor, that is, to the...
How to Do a Comparative Chart in Excel
1. Open the Excel worksheet that contains the data for the chart.2. Click and drag to select the data values and categories.3. Click the “Insert” tab on the command ribbon.4. A column chart can display different categories or data seriesin different colors.Click the arrow for a preferred chart type in the 'Charts' group. For example, a “2-D Column” chart type can display two or more data series as different colors or shades. A gallery of chart sub-types appears.5. Click the preferred chart sample. The worksheet data converts to the selected chart type. The chart appears with the worksheet....
Excel Graph Tutorials
1. Open the Excel 2010 spreadsheet that contains the data that you want to use in a graph.2. Organize your data so that you have headers at the top of each column, and, if necessary, at the left end of each row. If you need to create a header row or column, just right-click the top or leftmost row or column and click 'Insert' from the pop-up menu. A blank row or column will appear, and you can use that to enter your column or row headers.3. Click on any cell in the data field, and then click the 'Insert' tab at the top of the screen. Click the small button in the lower-right corner of the...
How to Highlight Minimum Maximum Values in Excel
1. Click the cell at one end of the range that you are analyzing.2. Drag the mouse to the cell at the other end, selecting the entire range.3. Click 'Conditional Formatting' from the 'Styles' tab of the 'Home' ribbon. A drop-down menu will open.4. Click 'New Rule...' from the bottom of the list.5. Click 'Format only top or bottom ranked values' from the 'Select a Rule Type' pane.6. Select 'Top' from the first of the drop-down boxes in the 'Edit the Rule Description' pane.7. Type '1' into the text box in the 'Edit the Rule Description' pane.8. Click the 'Format' button, which opens...
Thursday, February 14, 2013
How to Make a Coordinate Plane in MS Excel
1. Open a new, blank Excel document. Click the rectangle in the upper-left corner of the spreadsheet located at the intersection of column A and row 1. This will select the entire spreadsheet. Click the View tab. In the Show/Hide group, deselect 'Gridlines'.2. Place your cursor on a line between any two column headers. Your cursor will change to a vertical line crossed by a horizontal arrow. Drag the line left until the column width is exactly 20 pixels. When you release the mouse, all cells will be square. Click in cell A1 to remove the highlighting.3. Click cell C3 and drag and highlight...
How to Create a Stacked Chart in Excel 2003
1. Enter your data in column 'A,' with the label for the data in cell 'A1,' and each data value put into cells 'A2,' 'A3' and so on, until you've entered all of the data needed for the chart.2. Select the range of cells from cell 'A1' through the last cell with a data value in it.3. Click the 'Insert' menu and select 'Chart.' This will start the Chart Wizard.4. Click 'Column' for the Chart Wizard from the options under 'Chart Type.' A 'Chart sub-type' menu will show up.5. Click '100% Stacked Column' and click 'Next.' This selects the stacked chart subtype.6. Click 'Rows' on the next...
How to Use Indirect in Excel to Link to an External Spreadsheet
1. Create two spreadsheets. One will be named PullData.xlsx. The other will be ReviewData.xlsx.2. Enter the following into cell A1 of Sheet1 of PullData.xlsx: 'Shazam!'3. Enter the following formula into cell A2 of PullData.xlsx: '=27 54'4. Switch to ReviewData.xlsx. Enter the following text into the following cells: In cell B1, enter 'PullData.xslx'. In cell B2, enter 'Sheet1'. In cell B3, enter 'A1' and in cell B4, enter 'A2'.5. Enter the following formula in cell A1 on ReviewData.xlsx: '=INDIRECT(''['B1']'B2''!'B3)'. Note that there are both double quotes (') and single quotes...
How to Insert a Title Into a Table in Excel 2007
1. Click on the table.2. Click 'Design.' This is a tab near the top of Microsoft Excel.3. Select 'Table Name' in the 'Properties' group.4. Type your title in the text box that appea...
How to Lock Specific Cells in Excel 2007
1. Highlight the entire sheet by clicking the 'Select All' button in the top-right corner of the sheet. It's just to the left of the A column and immediately above the 1 line.2. Right-click anywhere on the sheet and select 'Format Cells.' The Format Cells pop-up window will open.3. Click the 'Protection' tap at the top of the window.4. Click the block next to 'Locked' to clear the check mark, and click 'OK' to close the window.5. Click anywhere on the sheet to remove the highlighting. Select all the cells you want to lock. You can drag to select cells that are connected. To select individual...
How to Create a Histogram in Microsoft Word
1. Open a blank Word document, or open the document in which you want to create a histogram. Insert a table onto the document. In Word 2007, go to the 'Insert' tab, click the 'Table' dropdown and select 'Insert Table.' In earlier versions of Word, go to the 'Table' menu, point to 'Insert' and click on 'Table.' Choose the number of columns you need in your chart, including a column to label the rows, and enough rows to present your data.2. Enter the y-axis data for the histogram into the first column of the table. For example, if you are making a histogram showing how much money employees earned...
How to Create an Amortization Table in Excel
1. Use the loan APR, amount and term in Excel's 'PMT' function to calculate the monthly payment. If you have a 30-year mortgage for $200,000 at a 6 percent APR, type the following in cell A1.=-PMT(0.06/12,30*12,200000)2. Type in column headings for the amortization table. In cell A3, type 'Unpaid Balance.' In cell B3, type 'Principal.' In cell C3, type 'Interest.' Adjust the column widths as necessary.3. In cell A4, type the initial loan value. For the previous example, you would type '200000.'4. Calculate the interest on the first month's payment. In cell C4, based on the previous example,...
Subscribe to:
Posts (Atom)