How to Get Solver for Excel 2007

1. Open a spreadsheet in Excel.
2. Click 'Add-ins' on the Tools menu. Select 'Solver Add-in' check box.
3. Click 'OK,' and the Solver installation will begin automatically.
4. Click on 'Solver' on the Tools menu to run the program.

Read more ►

How to Protect a Pivot Table

1. Open the worksheet with the pivot table. Select the pivot table information in your Excel worksheet that you would like to protect.
2. Click 'Review' from the ribbon menu. Under the Changes group, click 'Protect Sheet.'
3. Click the 'Use PivotTable Report' check box. Type a password in the 'Password to Unprotect Sheet' box.
4. Click 'OK' and re-enter the password. Your pivot table is now protected.

Read more ►

How to Calculate Mode Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 9,6,5,9,4,9,2 and 1 in A2, A3, A4, A5, A6, A7, A8 and A9.
2. For this example, click on the 'A11' cell. This is the cell where you will calculate the mode. When you calculate another mode, choose any cell at the bottom of the list of numbers you are using.
3. Click 'Insert Function' on the top, left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open. With Microsoft Excel 2007, click on the 'Formulas' tab and then 'Insert Function.'
4. Click on the drop-down menu of 'Or select a category.' Select 'Statistical' from the drop-down menu.
5. Scroll down the 'Select a function' window. Choose 'MODE,' which is the function of mode.
6. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A9 is populated. If A2:A9 is not populated, enter A2:A9 manually. Click 'OK.'
7. The mode has been successfully calculated. In this example, the calculated value of the mode is 9.

Read more ►

How to Add a Calendar Date Picker to an Excel Spreadsheet

1. Download the free 'Calendar' tool available at isamrad.com/ExcelCal/default.htm. This plugin is a standard Excel add-in program. It is offered as a compressed ZIP file which must be unzipped after download. Once the XLA file is placed into the Excel 'XLSTART' directory in the 'Program Files' folder of Windows, Excel will show a date picker icon next to cells that are already formatted as dates. Additionally, the date picker can be launched by right-clicking on any cell and choosing the 'Pick from Calendar' option. The applet also installs a toolbar button for the feature.
2. Activate a free 30-day trial of the Pop-up Excel Calendar created by Office Kit. This program offers a robust calendar interface that includes quick jumps to any month or year as well as shortcut buttons. Additionally, the program installs a unique calendar toolbar which features a quick launch for the Pop-up Excel Calendar as well as other features, including a settings button. The applet works on all major versions of Excel. If you are pleased with the demo, Pop-up Excel Calendar costs $20 as of February 2010.
3. Download the WinCalendar utility. The software comes in multiple versions, including a free option. The program is a robust date picker that displays multiple calendars simultaneously for quick selection of any date within a three-month period. Additionally it highlights holidays and offers user customization of new holiday entries. The calendar can be re-sized to suit the user's preference. It also functions in other Microsoft Office programs, or as a standalone program. The free version is functional but excludes emphasis of some holidays and limits the size of the pop-up interface. The free version also limits the number of entries that may be made.

Read more ►

How to Enter Formulas in Excel Divide the Sum of Several Numbers by a Number

1. Click on an empty cell in your spreadsheet.
2. Type an '=' sign.
3. Type the following formula into the cell: UM(A1:A10).
4. Replace 'A1:A10' with the cell locations of the numbers you want to add. In this example, the series of numbers is in cells A1 through A10.
5. Type a division sign '/' followed by the number you want to divide by. For example, if you wanted to divide the total of cells A1 to A10 by 3, type '/3.'
6. Press the 'Enter' key; Excel will perform the calculation.

Read more ►

How to Create a Flow Chart in MS Word

1. Open Microsoft Word, which automatically defaults to a blank portrait-oriented page on the screen. To change your flow chart to landscape orientation, click the 'Page Layout' tab at the top of the screen and click the 'Orientation' button directly below it. The page changes to landscape.
2. Type the name of the flow chart at the top of the page, such as 'Weather Closing Phone Tree.' Highlight the words, click the 'Home' tab at the top of the screen and change their appearance using the options in the 'Font' section of the ribbon/toolbar, such as font style and text color.
3. Click the 'Insert' tab at the top of the screen. Click the 'SmartArt' button on the ribbon/toolbar below it, which opens the 'Choose a SmartArt graphic' window.
4. Scroll through the different flow chart options, including vertical hexagons, triangles of different sizes and boxes and arrows in a horizontal line. The flow chart options in the 'Process' section of the window may be especially applicable to a flow chart.
5. Double-click a SmartArt shape group and it appears on the Word window. Enlarge the flow chart to fit the page by grabbing a corner and dragging it toward one of the edges of the Word workspace.
6. Click one of the '[Text]' words within the SmartArt flow chart shape and type the shape's information, such as a worker's name. Repeat this to fill the rest of the flow chart with labels for each shape.
7. Recolor the flow chart (optional) by double-clicking anywhere on it to bring up a new 'SmartArt Tools' toolbar. Click the 'Change Colors' button on the toolbar and hover your cursor over the options in the drop-down menu. As you hover over each group of colors, the flow chart changes. Click a color group to commit the change.
8. Click the 'File' tab, click 'Save As,' give the flow chart a name and save it to your computer.

Read more ►

How to Exit Out of Header Footer Option in Excel 2007

1. Add a header or footer. Click 'Header Footer' in the 'Text' area of the 'Insert' tab. Click on the document in the area marked 'Click to add header' or 'Click to add footer.'
2. Design the header or footer. Select preformatted options from the menu, type in your own text, or use a combination of menu items and typed text. When you finish the header or footer, click anywhere on the body of the document.
3. Change to Normal View. Click 'Normal' in the 'Workbook Views' area of the 'View' tab. You will leave header/footer mode and return to your worksheet.

Read more ►

How to Print Address Labels in Excel

1.
Open a blank worksheet in Excel. Go to the 'File' menu, click on 'Page Setup' and go to the 'Margins' tab in Excel 2003. In Excel 2007, go to the 'Page Layout' tab and click 'Margins.'
2.
Enter '0' in the Top and Bottom boxes. Change the margins in the left and right boxes to '.19.' Under Center on Page, select 'Horizontally' and 'Vertically.' Apply these changes by clicking 'OK.'
3.
Select cells A1 through A10 with the mouse. Go to the 'Format' menu in Excel 2003, point to 'Row' and select 'Height.' In Excel 2007, click 'Format' on the Home tab and click 'Row Height.' Enter '72' and click 'OK.' In the same manner, change the Column Width to 35. Repeat the steps in cells C1 through C10 and E1 through E10.
4.
Use the mouse to select the cells in B1 through B10. Change the width of the column to 1.29. Repeat with cells D1 through D10.
5.
Select all of the cells from A1 through E10 with the mouse. Click the 'Borders' drop-down on the Format toolbar in Excel 2003 or the Font group on the Home tab in Excel 2007. Click 'All Borders.'
6. Enter the names and addresses into the label cells. The cells in columns A, C and E are the label areas. Columns B and D are the margins between labels. Print onto the label paper.

Read more ►

How to Use the Transpose Function in Excel

1. Highlight the range of cells where you want the transposed data to appear. For example, if you want to transpose cells A1:A10 into a row in cells B1:K1, you would highlight B1:K1.
2. Go to the 'Formulas' tab and click on 'Insert Function.' Type 'Transpose' in the 'Search for a function' field and click on the 'Go' button. Select 'Transpose' from the 'Select a function' section and click 'OK.'
3. Highlight the range of cells you would like to transpose. In our example, we would highlight cells A1 through A10. The range will appear in the 'Array' field of the Function Arguments window.
4. Hit 'Ctrl,' 'Shift' and 'Enter' on your keyboard simultaneously. The transposed data will appear in the new location, which is B1 through K1 in the example.

Read more ►

How to Delete Shading From Alternate Rows in Excel 2003

1. Open the spreadsheet which contains the unwanted shading.
2. Click on the row number of one of the shaded rows. This will highlight the entire row. Ctrl-click on each row number where there is shading you want to delete.
3. Click on 'Format' on the menu then 'Format Cells.' Click on the 'Patterns' tab. Click the bar above the color palette that says, 'No Color.' This will delete the shading from alternate rows in Excel 2003.

Read more ►

How to Draw a Histogram in Windows Excel

Load the Analysis ToolPak
1. Open a new Excel spreadsheet. Click on the 'File' tab at the top of the screen, and then click 'Options' on the menu that appears.
2. Click 'Add-Ins' from the list on the left side of the Excel Options menu. Click the drop-down arrow next to the 'Manage' box at the bottom of the window. Choose 'Excel Add-Ins' from this drop-down menu, and click 'Go.'
3. Click the small box next to 'Analysis ToolPak' to place a check in the box. Click 'OK' to close this window.
Create the Histogram
4. Click on cell 'A1' and enter the title for the data that you want to use with the histogram. Then select cell 'A2' and enter your first value. Continue to enter values using the cells in column 'A' until you have added all of your data.
5. Click cell 'B1' and type in 'Bin Range.' This column of cells will contain the numbers that represent the number ranges that will make up the horizontal axis of your histogram. Remember that each bin number represents the top of the range of values that will be counted as part of that bin, so be sure to include the highest possible value for your data as part of the bin numbers. Enter the values starting at call 'B2,' and continue down the column until you have entered all your desired bin ranges.
6. Click the 'Data' tab at the top of the screen, and then click the 'Data Analysis' button on the far right side of the ribbon. Select 'Histogram' from the list of options and then click 'OK.' A small 'Histogram' window will appear.
7. Click in the blank next to 'Input Range' in the Histogram window. Click on cell 'A2' and hold down the mouse button. Drag your mouse down until you reach the last cell that holds data in column 'A'; then release the mouse button. Click on the blank next to 'Bin Range' and do the same thing as you did in column 'A,' but this time do it in column 'B' starting with cell 'B2.'
8. Select the radio button next to the output option that you desire. You can place the histogram somewhere on this worksheet, you can place it on a new worksheet within this workbook or you can place it in an entirely new workbook.
9. Place a check next to any of the bottom three options, if any apply to your desired histogram output. 'Pareto' will sort your data in descending order of frequency, 'Cumulative Percentage' will include another column on the histogram that has the cumulative percentages for your frequency data, and 'Chart Output' will display a chart of the histogram in addition to the standard table.
10. Click 'OK' to close the window and Excel will create your histogram.

Read more ►

How to Remove Multiple Duplicate Rows in Excel 2003

1. Open the spreadsheet and select the cells that may include duplicate rows. The values in the rows can be text or numbers.
2. Click the 'Data' menu, hover over the 'Filter' option and choose 'Advanced Filter' from the submenu.
3. Choose 'Copy to another location,' which leaves the original range of data intact, just in case.
4. Check the prepopulated 'List range' to confirm it's the range of data you want to filter of any duplicate values.
5. Choose, in the 'Copy to' field, the first cell to which you want to copy the filtered cells.
6. Place a tick mark in the box labeled 'Unique records only.' Click 'OK' to close the box and filter duplicates from the list of data.
7. Delete the original data when you're satisfied with the filtered results.

Read more ►

How to Make a 2nd Line on MS Office Excel

1. Click 'Start,' then 'All Programs.'
2. Click the 'Microsoft Office' folder, then click 'Microsoft Office Excel.' This will open a new workbook. To open an existing workbook, click the 'File' tab, then click 'Open' and browse to your file.
3. Click the cell into which you wish to add a second line.
4. Add the data for the first line, then press 'Alt Enter' to create a second line within the cell. You can continue to use 'Alt Enter' to add additional lines to your cell as well.

Read more ►

How to Add Data Labels to an Excel Chart

1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add data labels.
2. Select the chart you want to add the data labels to by clicking it. The chart will be surrounded by a light blur border indicating it is selected.
3. Choose the 'Layout' tab at the top of the Excel 2007 screen to display the options in the 'Layout' ribbon. Locate the 'Labels' group in the 'Layout' ribbon.
4. Click the 'Data Labels' button in the 'Labels' group of the 'Layout' ribbon to display a drop-down list of options.
5. Opt for 'Center' from the 'Data Labels' drop-down list to display the data labels centered on the data points of your chart. 'Inside End' will display the data labels inside the end of the data points while 'Inside Base' will display the data labels inside the base of the data points.
6. Watch as the data labels are added to the selected Excel chart in the position you have chosen.

Read more ►

How to Add a Custom Menu to an Excel Toolbar in Excel 2003

1. Log on to your computer and open your Excel worksheet. 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 'Tools' in the toolbar. Hold the mouse over the arrow to expand the menu and select 'Customize'.
3. Add the functions that appeal to you by checking desired toolbars under the 'Toolbars' heading.
4. Click on the 'Commands' tab. Choose a category from the displayed list, then choose a command and drag it off the dialog box to the toolbar. Repeat as desired.
5. Delete a command by dragging the icon outside the toolbar and letting go of your left mouse button.
6. Determine whether you want a command by selecting the command under the 'Commands' heading, then choose 'Description'. This allows you to view a description of the command.
7. Close your 'Customize' window by clicking the 'X' in the left-hand corner of the window.

Read more ►