Monday, May 20, 2013

How to Create Microsoft Flow Charts

1. Open Excel 2010 and click the 'Insert' tab. Select 'SmartArt.' Click the 'Process' category in the left task pane. Click on the different process flow charts in the center task pane. Select a flow chart. For example, select the 'Basic Bending Process' flow chart. Click 'OK.' The SmartArt flow chart and Text Pane appear.2. Type your flow chart tasks in the bulleted 'Text' pane. Move to each shape in the flow chart by pressing the 'Enter' key as you complete each task. Click on the outside border of the flow chart pane.3. Notice the new 'SmartArt' tab on the ribbon. Use the 'Design'...
Read more ►

How to Remove a Hyperlink in Excel 2003

1. Right-click the cell with a hyperlink.2. Click 'Hyperlink.'3. Select 'Remove Hyperlink.' The hyperlink is now removed from your Excel docume...
Read more ►

How to Set Page Breaks in Microsoft Word 2003

1. Set your cursor where you want to page break to occur. Scroll to the “Insert” tab and the click on “Break.” Select “Page Break” from the drop down menu.2. Insert a page break using hotkeys. Select where you wish for the break to occur and the press hotkeys “CTRL ENTER” to create the break.3. Remove a page break. To remove a page break, left-click on the page that the break begins and press the “Backspace” button to delete the added page.4. Insert a custom page break. Scroll to “Insert” and then select “Break.” You can choose several custom breaks including: page break, a column break...
Read more ►

Sunday, May 19, 2013

How to Align Images in Excel

1. Open Microsoft Excel 2007 and open a workbook from your files that contains at least two images you wan to align to each other.2. Hold down the 'Shift' key on your keyboard and click to select the first image you want to align. Continue holding down your shift key and click to select any other images that you want to align in relation to the first image. Once selected, the images will be surrounded by a thin, black line and white sizing handles.3. Select the 'Format' tab from the top of the screen (if necessary) to display the Format ribbon. Locate the 'Arrange' section in the Format...
Read more ►

How to Graph Linear Equations in Excel 2007

1. Open a new document in Microsoft Excel 2007.2. Enter 'x' in the top left cell. Press 'Tab' and enter 'y' in the next cell over.3. Enter a series of values in the first column under 'x' (cells A2 and down). These values will make up the parameters of the horizontal axis. For instance, enter '-5' in cell A2. In the next cell down, enter '-4' and onward: -3, -2, -1, 0, 1...all the way up to 5.4. Define the name of the x values so you can enter the formula for the 'y' column. Use your cursor to highlight the cell values in column A. In other words, highlight cell A2 and drag your cursor...
Read more ►

How to Make Text Vertical in Excel

1. Click the Excel cell containing the text you want to rotate.2. Click 'Home' at the top of the Excel window.3. Click on the 'Orientation' button. The 'Orientation' button has 'AB' written diagonally with a diagonal arrow pointed up on it. It is located under the words 'Data' near the top of the Excel window.4. Select 'Vertical Tex...
Read more ►

How to Do a Calibration Curve on Excel

1. Run a set of known X variables through the equipment to produce a series of Y outputs.2. Open Microsoft Excel. In cell A1 type 'concentration.' In cell B1 type 'output' or the appropriate unit of measure for your experiment.3. Enter experimental concentrations for the X variable in column A, starting at A2.4. Enter experimental outputs for the Y variable in column B, starting at B25. Highlight entire data set.6. Click the 'Insert' ribbon.7. Click the 'Scatter' button and select the 'Scatter plot with markers and straight lines.' The graph should now appear and the Excel ribbon...
Read more ►

Saturday, May 18, 2013

How to Make a Graph on Excel With X Y Coordinates

1. Open a new Microsoft Excel 2010 worksheet. Click on cell 'A1' and type in the header for your first series of data. This series will wind up on the horizontal, or 'X,' axis.2. Click on cell 'B1' and enter the header for your second series of data. This series will be plotted on the vertical, or 'Y,' axis.3. Select cell 'A2' and enter the first value you want to plot. Then select cell 'B2' and enter the corresponding coordinate. Continue entering your coordinates down the columns until you have entered all your data.4. Click on any cell in the data field you have just created. Click...
Read more ►

How to Create Criteria Ranges in Excel for Database Functions

1. Open the Excel application on your computer that contains the table of database functions that you want to create criteria for.2. Highlight the range of cells containing numeric data using your mouse. Click on the “Data” tab for Excel 2007 or the “Data” option from the top toolbar menu for Excel 2003.3. Click on the “Filter” option and the click on the drop-down arrow located in the column header.4. Move your mouse over the “Number Filters” option and then click on the “Custom Filter” option. The Custom AutoFilter dialog box will appear.5. Select the number criteria for your ranges...
Read more ►

How to Restore Gridlines in Excel 2003

1. Click 'Tools' in the menu bar.2. Select 'Options.'3. Click on the 'View' tab, then check the 'Gridlines' box.4. Save your docume...
Read more ►

How to Convert a Microsoft Word Table Into an Excel Workbook

1. Open Microsoft Word and Excel from the desktop menu. In Word, find the document containing the text to be converted. In Excel, open a blank worksheet.2. Return to the Word document and confirm that the text appears in true table format. If there are gridlines or a compass symbol enclosed in a box at the top left corner of the first column, the text is a true table. If not, the text appears in columned format only and must be converted to a true table.3. Convert columned text to a true table by inserting a tab, a comma or an asterisk in between each row of the columns. Highlight all the...
Read more ►

How to Unfreeze Panes

Freezing Panes in Excel 97/2000/XP/20031. Open the spreadsheet you want to freeze.2. Select the row below the one you want to freeze by clicking on the row header.3. Select 'Window' from your menu and choose the 'Freeze Panes' option.Unfreezing Panes in Excel 97/2000/XP/20034. Open the spreadsheet with frozen panes.5. Select 'Window' from the menu.6. Choose the 'Unfreeze Panes' option.Freezing Panes in Excel 20077. Select the row just below the one you want to freeze by clicking on the row header. This will make a specific row or rows visible as you scroll within Excel. Select the...
Read more ►

Friday, May 17, 2013

How to Move Averages in Excel 2010

1. Enter the date, or other reference information, in column A, and enter its corresponding data in column B. Repeat for each data point. As an example, you might have 'Jan 1, 2011' in cell A1 and '$43.25' in cell B1. On the next row, you might have 'Jan 2, 2011' in cell A2 and '$44.50' in cell B2. This continues for however many data points you have, but you will need several data points to construct a moving average.2. Click the cell in column C whose row number corresponds to the number of data points you want to include in the moving average. As an example, to include the last 20 data...
Read more ►

How to Make Double Line Graphs on Excel

1. Open the Excel worksheet that contains the data values.2. Click and drag on the categories and two data series you want to plot.3. Click the “Insert” tab in the Command Ribbon.4. Click the arrow for the “Line” button in the Charts group. A gallery of seven thumbnail charts appears.5. Click the preferred chart sub-type.6. Click “OK.” The two data series convert to a line graph. The Chart Tools Ribbon displays.7. Customize the chart with the commands in the Chart Tools Ribbon. Chart Tools contains three tabs: “Design,” “Layout” and “Format.” Experiment with the commands in each...
Read more ►

How to Format Dates in Microsoft Excel 2003

1. Select a cell and activate it. You will need to first left-click on a cell that you wish to enter a date into.2. Create a date inside of a cell. Enter in any date that you like in the cell and then press enter; this will store the information into that cell.3. Access the cell formatting menu. To access this menu, right-click on the cell that you just entered the date into and select “Format Cells.”4. Format the date as desired. Under the cell formatting properties menu, left-click on the “Number” tab and then scroll to and highlight the “Date” field. Under the “Type” box you can scroll...
Read more ►

Blogger news