How to Open a Xlxs File

1. Open your web browser and go to the following URL:
http://us20.trymicrosoftoffice.com/product.aspx?re_ms=oofamily=officeproculture=en-US
2. Download the free 60-day trial version of Microsoft Office Pro 2007, which includes Excel 2007.
3. Follow the onscreen install-wizard instructions to install the software on your computer.
4. Open Microsoft Excel and click on the Office start button in the upper-left corner of the window. From the list of options, select 'Open.'
5. Select the xlxs file that you wish to open and click the 'open' button at the lower right of the window. Excel 2007 will open the file.

Read more ►

How to Do Error Bars on a Line Graph

1. Open the Excel 2010 spreadsheet that holds your line graph.
2. Click anywhere on the line graph to select it, then click the 'Layout' tab on top of the window, near the right end.
3. Locate the drop-down box in the 'Current Selection' area of the ribbon. Click the box and choose the data series that you want to display with error bars. To display all of your data series with error bars, choose 'Plot Area.'
4. Click the 'Error Bars' button in the 'Analysis' area of the ribbon. From the menu that appears, choose to add error bars for the standard error, for one standard deviation or for a 5 percent error on each value. If you want more precise control, choose 'More Error Bar Options,' then choose a data series from a small window that appears, as you can only add error bars this way for one series at a time. If you choose this option, another window appears.
5. Click the radio button next to 'Both,' 'Minus' or 'Plus' under the 'Direction' heading to determine which way your error bars will appear from the line on the graph. Under the 'End Style' heading, choose either to add or not to add a cap on the end of the bar.
6. Select your method for determining the error bar size under the 'Error Amount' heading. If you choose 'Fixed Amount,' 'Percentage' or 'Standard Deviation,' enter an amount into the box next to the option. You can also choose 'Standard Error,' but this option has no entry box, as the error bar sizes are determined solely by the values.
7. Change the appearance of the error bars from the 'Line Color,' 'Line Style,' 'Shadow' and 'Glow and Soft Edges' menus from the left side of the window. Each of these menus has numerous options to specify the exact look of the bars. Click 'Close' at the bottom of the window when done. Your error bars appear on the line graph.

Read more ►

How to Rank Without Duplicating in Excel 2007

Creating the Formula
1. Start Excel and open up the data range you want to use. For this example, we're assuming that the data values to be ranked are in column A, starting in column A2.
2. Enter the following formula in cell B2: =RANK(A2,$A$2:$A$10) COUNTIF($A$2:A2,A2)-1. This formula ranks the data, using the value in A2 as the seed value, going through the ranks from top to bottom. The COUNTIF in the second part of the formula increments the rank number by 1, EXCEPT if the rank value is the same.
3. Copy the formula in cell B2 through the entire range of cells from B3 to B10.

Read more ►

How to Create a Gantt Chart Using Excel 2003

1. Type a schedule into four columns in Excel. Type the names of milestones for your project in column 'A,' then type the start dates in column 'B,' then type the duration in days in column 'C' and the project end date in column 'D.'
2. Click the 'Chart Wizard' button, then click the 'Bar Chart' on the left-hand side. Click 'Stacked Bar Chart' as the chart subtype.
3. Click the 'Series' tab.
4. Click 'add' to add a series from your spreadsheet. Type a name for one of the series in the 'Series name' text box -- for example, type 'Start Date.' Type the location for your series into the 'Values' box -- for example, if your start dates are in cells 'B1' to 'B10,' type 'B1:B10.'
5. Repeat Step 4 to add the name and location of the 'Duration' series.
6. Click the 'Category Axis' button and highlight the tasks you listed in column 'A.' This adds labels on the left-hand side of your chart. Click the 'Finish' button.
7. Drag the bottom right corner of the chart until the chart fills the screen.
8. Right-click the 'X' axis on the chart. Click 'Format Axis,' then click '10' for the font size. Click 'OK.'
9. Right-click the 'Y' axis on the chart. Click 'Format Axis,' then click '10' for the font size. Click 'OK.'
10. Right-click the blue bars on the chart, then click 'Format Series.' Click the 'None' radio buttons next to Border and Area. Click 'OK.'
11. Right-click on the 'Y-axis' label, then click 'Format Axis.' Click the 'Scale' tab, then click the 'Categories in Reverse Order' check box. Click 'OK.'

Read more ►

How to Use Excel Tornado Diagrams

1. Open your spreadsheet and highlight the data you want to include in your tornado diagram. Go to 'Insert' and select 'Bar,' then 'Clustered Bar.'
2. Right-click on the horizontal axis and select 'Format Axis.' Select 'Axis Value' under 'Vertical Axis Crosses,' then enter your base case value.
3. Select the vertical axis for your diagram, then check next to 'Categories in Reverse Order' and click 'Low' on the 'Axis Labels' menu.
4. Click one of the bars to open a pane labeled 'Series Options' and slide the button under 'Series Overlap' over to the far right. Click 'Finish.'

Read more ►

How to Add Print Preview Ribbon to Main Ribbon

1. Open Microsoft Word 2010 and click the 'File' button, then select 'Options.' Click the 'Customize Ribbon' button on the left side of the Word Options menu.
2. Decide where you want to place this shortcut. You must create a custom group to place your shortcuts. For example, if you plan to add the shortcut to the Home tab, add a new group to this tab. Select 'New Group' on the right side of the Options. Select 'Rename' and type a name for this group. Click 'OK.'
3. Select the 'Choose Commands From' drop-down list, select 'Not On The Ribbon.' Select 'Print Preview Edit Mode.' Click 'Add' to move this command to the newly created group. Click 'OK.'

Read more ►

How to Print Selected Areas of a Worksheet in Excel 2003

1. Open your Excel worksheet and select the area you want to print. To select, hold down the left mouse button and drag your mouse over the area.
2. Right click on the selected area to summon a small pop-up menu of options.
3. Select 'Print' from the menu to bring up the print menu and select 'Print Selected Area.'
4. Click 'Print' to print the selected section.

Read more ►

How to Insert Copied Cells Multiple Times in Excel

Fill Handle
1. Open the Excel 2010 spreadsheet that has the information you want to copy. Click on the cell you want to copy.
2. Move the mouse to the lower right corner of the cell where there is a small square along the border. When you move your mouse over this square, called a fill handle, the mouse pointer turns into a plus sign.
3. Click and hold the mouse button over the fill handle, then drag the mouse in the direction that you want to copy the information. When you reach the last cell where you want to copy the information, release the mouse button. Excel now automatically copies the information into every cell between the first and last ones.
Paste Feature
4. Open the Microsoft Excel 2010 spreadsheet that you want to work with.
5. Click on the cell that you want to copy and press “Ctrl” and “C” to copy the cell’s contents to your clipboard.
6. Click on the first cell where you want to paste the information. To paste the information in a range of cells, click and hold the mouse button over the first cell, then drag the mouse down to the last cell and release the button.
7. Hold the “Ctrl” key and select the second cell, or group of cells, where you want to paste the information. Continue to hold “Ctrl” until you have selected every cell where you want to paste the information.
8. Press “Ctrl” and “V” to paste the information into every cell you have selected.

Read more ►

How to Create a Simple Budget Using Excel 2007

1. Open Excel, double click the tab called 'Sheet 1' and change the name to 'Expenses.' All of your expenses will be listed in this first Expense worksheet.
2. Click cell A1 and type 'Date,' press tab and type 'Expense Name,' press tab and type 'Amount ($)' and press tab one more time and type 'Notes.' These four headings will now be the titles of the first four columns.
3. For every expense you have, record the date of the expense in the 'Date' column, a description of the expense in the 'Expense Name' column, how much you spent in the 'Amount ($)' column and include any notes about the expense that are relevant in the final column.
4. Double-click on the second worksheet tab called 'Sheet 2,' and change the name to 'Income.'
5. Click on cell A1 and type 'Date,' press tab and type 'Income Name,' press tab and type 'Amount ($)' and finally press tab once more and type 'Notes.'
6. Record any income you take in on this worksheet, noting the date of the payment, a description of the income, the amount and any notes about the income in the appropriate columns.

Read more ►

How to Delete Punctuation All Caps in Excel

1. Open the Excel 2010 spreadsheet where you want to remove punctuation and use a different case. Click the 'Developer' tab at the top of the screen. Click the 'Record Macro' button, located on the left end of the Ribbon.
2. Type 'RemovePunctuationCaps' in to the 'Macro name' field. Enter 'q' into the 'Shortcut Key' field. Click 'OK' to close the window. Click the 'Stop' button on the ribbon to stop the macro from recording.
3. Click the 'Visual Basic' button on the ribbon to launch the VBA editor. Double-click 'Module 1' on the left side of the editor. If you have already created a module in this workbook, you will need to click on the last listed module, instead of 'Module 1.' You will see 'Sub RemovePunctuationCaps()' on the right side of the window.
4. Click on the right side of the window. Drag your mouse over the green text between 'Sub Remove...' and 'End Sub.' Delete all this text so that the 'Sub' and 'End Sub' lines are all that exist.
5. Copy and paste the following code between the 'Sub' and 'End Sub' lines in the VBA editor:Dim rng As RangeFor Each rng In Selectionrng.Value = StrConv(rng.Text, vbProperCase)Next rngThis will establish a variable named 'rng' and provide the code needed to change your selection into proper case. If you would rather use lower case, change 'vbProperCase' to 'vbLowerCase.'
6. Enter the following piece of code between the last code and the ''End Sub' line:With CreateObject('vbscript.regexp').Pattern = '[^A-Za-z0-9\ ]'.Global = TrueFor Each rng In Selection.SpecialCells(xlCellTypeConstants)rng.Value = .Replace(rng.Value, vbNullString)Next rngEnd WithThis will remove all punctuation from the selected cells.
7. Click the 'X' in the upper-right corner of the editor to close it. Click on the cell or cells where you have the text you want to convert. Press 'Ctr-Q' and the macro will perform the task.

Read more ►

How to Deselect a Cell

1. Launch Microsoft Excel.
2. Hold down the 'Alt' key and press 'F11.' This will open the Visual Basic editor.
3. Click 'Insert' and click 'Add new module.' Paste the following code in the module on the right and press 'Enter:'Sub UnSelectActiveCell()Dim Rng As RangeDim FullRange As RangeIf Selection.Cells.Count > 1 ThenFor Each Rng In Selection.CellsIf Rng.Address
ActiveCell.Address ThenIf FullRange Is Nothing ThenSet FullRange = RngElseSet FullRange = Application.Union(FullRange, Rng)End IfEnd IfNext RngIf FullRange.Cells.Count > 0 ThenFullRange.SelectEnd IfEnd IfEnd Sub
4. Exit the Visual Basic Editor to get back to Excel.
5. Click 'Tools' >> 'Macro' >> 'Macros' and then double-click 'UnSelectActiveCell.'
6. Hold down the 'Ctrl' key and select the cells that you wish to deselect.
7. Repeat Step 5.

Read more ►

How to Use Form Control Scrollbar in Excel

1. Open the 'Forms' toolbar in Excel 2003 by going to the 'View' menu, pointing to 'Toolbars' and selecting 'Forms.' Click the scroll bar button on this toolbar. Click on the first cell onto which you want to place the scroll bar and drag the mouse to the last cell onto which you want to place the scroll bar. In Excel 2007, go the 'Developer' tab. Click 'Insert' and select 'Scroll Bar' in the 'Form Controls' group. Click on the first cell onto which you want to place the scroll bar and drag the mouse to the last cell onto which you want to place the scroll bar.
2. Right-click the scroll bar on the Excel worksheet. Select 'Format Control.' The 'Format Control' dialog box will open. Go to the 'Control' tab.
3. Enter '1' into the 'Current Value' box to enable the scroll bar and direct the 'Index' formula to refer to the first item in the range or list. Type '1' into the 'Minimum Value' box, which confines the scroll bar to stop at the first item in the list or range. In the 'Maximum Value' box, type the number of entries in the list or range to limit the scroll bar to the last item. Type the number of increments by which you want to be able to scroll in the 'Incremental Change' box. Type an incremental number in the 'Page Change' box, as well. This form control dictates the increments the scroll bar will move if the users clicks the scroll arrows.
4. Type a cell reference into the 'Cell Link' box or click inside the 'Cell Link' box to place the cursor in it and then click on the cell you wish to use to display the number value showing the item selected when the scroll bar is in use.
5. Click 'OK' to save the changes and close the dialog box. Click onto the Excel worksheet anywhere outside of the scroll bar. Your scroll bar will now be functional.

Read more ►

How to Insert a Tab Character In a Cell

1. Open your Excel workbook and navigate to the worksheet you are working with. Click inside the cell that you want to modify.
2. Press the 'Ctrl,' 'Alt,' and 'Tab' keys simultaneously and see if a tab character is added to the active cell. Click the 'Format' button if the key combination does not add the tab character.
3. Click 'Cells' and then navigate to 'Alignment.' Click 'Left Indent' and then click the arrow key to add in an indentation that is the equivalent of a tab character. Click again to add another level of indentation.

Read more ►

How to Use WordArt in Microsoft Excel 2007

1.
On the 'Ribbon,' the group of icons and tools above the work area of the Excel workbook, select the tab called 'Insert.' On this tab you find a group called 'Text'. Within that group select the 'WordArt' option.
2.
A menu of choices will drop down. Select the option you would like to use.
3.
A text box will appear in your worksheet. Notice that the Ribbon has changed to include tools for you to use to tweak your WordArt to appear the way you would like it to.Double click inside the text box and type the text you would like to appear.
4.
If you would like to rotate your WordArt, click and drag the green circle appearing at the top of the text box.
5. To move your WordArt to a different part of the worksheet simply click and drag it to the location of your choice.
6.
The text in WordArt can be changed by clicking on the Home tab of the Ribbon and editing the text the same way traditional text is edited.
7.
Once your WordArt is adjusted to the style and location you choose, you can now print your document. WordArt will appear exactly as you created it on the printed page.

Read more ►

How to Make a Histogram in Microsoft Excel

1. Open Microsoft Excel and go to 'Tools', 'Add-ins'. Place a check in the box beside 'Analysis ToolPak', click OK.
2.
Create a table with the following columns: Time of Day, Accidents, Range. Enter the data in the following image.
3. Go to 'Tools', 'Data Analysis' or 'Data', 'Data Analysis'. Click on 'Histogram' then click OK.
4. Click the box beside 'Input Range' and highlight the 'Accidents' data. Click the box beside 'Bin Range' and highlight the 'Range' data. The Input Range is the raw data while the Bin Range provides the intervals to separate the data into.
5.
In the 'Output Options' select 'Output Range'. Select an empty cell within the worksheet then press OK. This places the histogram and corresponding table on the same worksheet as the original information.
6.
According to the histogram, the most accidents occur at five hours during the day; when referring to the data table, those hours are 1am, 4am, 2pm (1400 hours), 5pm (1700 hours), and 11pm (2300 hours).

Read more ►