How to Widen Bars in Excel 2007

1. Open the chart that contains the bars that you want to widen. Click once directly on the data series (bar) that you want to widen. Note that all of the bars in the data series will widen equally, regardless of which you select. This action will launch a separate pop-up window.
2. Click the 'Format' tab and locate the 'Current Selection' section. Click the 'Format Selection' option.
3. Locate the 'Gap Width Field in the 'Series Options' section. Enter a value in the 'Gap Width' field that is lower than the current value. For example if the current gap width is listed as 150, try 125 or 100. The lower the number, the wider the bars become. You may have to try a few different gap width settings until you find an appropriate width. Click 'Close.'

Read more ►

How to Use Conditional Formatting in Microsoft Excel

1. Apply conditional formats to monitor cell values, such as formula results. Stay abreast of dramatic changes affecting your organization, business or personal financial situation like donations increase, sales decline or a bank account overdraft.
2. Know when conditions change. Utilize the conditional formatting color coding system to signal those changes (e.g., red text color can indicate a turn down in stock value). Use conditional formatting in Microsoft Excel to recognize changing conditions to better control the direction and outcome of activities.
3. Open Microsoft Excel and the file you want to affect. Select cells for applying conditional formatting. Use conditional formatting in Microsoft Excel for automatic cell change when a specific condition is met.
4. Choose 'Conditional Formatting' from the 'Format' menu within Excel. See a 'Conditional Formatting' box pop up with options to choose from. Select the 'Cell Value Is' option from the first drop-down menu to utilize existing values in the cells you've selected in the formatting condition. Pick 'Formula Is' instead to enter a formula for the formatting standard if you want to assess information or a condition besides that associated with the values within the cells selected.
5. Type in a constant (number or text) after you have selected the comparison phrase (e.g., 'less than' or 'equal to') for 'Cell Value Is.' Realize a constant is a value that doesn't change since it's not calculated. Start with an equal sign if you choose to enter in a formula.
6. Enter the formula which will evaluate to a logical value, TRUE or FALSE for the formatting criteria for 'Formula Is.' Apply formatting when another condition is met (not based on the evaluation of a condition or data of the selected cell value).
7. Hit the 'Format' button next so that you can access formatting options. Choose one of the tabs, 'Font,' 'Border' or 'Patterns,' once the 'Format Cells' option box pops up. Make your preferred formatting selections to be applied to a condition change or when the formula calculates to TRUE within your selected cells.
8. Click 'Add>>' to include a second or third condition to selected cells. Repeat the same procedure you used for the first condition. Keep in mind that the first condition takes precedence and not all conditions, if met all at once, will be applied by Excel.

Read more ►

How to Make a Formula in Excel

Simple Math Formulas
1. Open Microsoft Excel by clicking on your Desktop shortcut or by selecting it from the Windows Start menu. You will automatically get an Excel Workbook. The workbook has three blank worksheets that Excel has named Sheet1, Sheet 2 and Sheet 3.
2. Remember that each column has a title that Excel uses in formulas, and each row has a number. The place in a worksheet where a row and column meet is a cell. Each cell's name is made with a column letter and the row number. The first cell at the top of the worksheet is A1. The next cell to the right is B1.
3. Start typing your numbers that you want to calculate in Sheet 1. You can type the numbers in a single column or you can type them across the rows. You also have the option of typing your data in more than one column or row.
4. Put the cursor in the first empty cell below the data in your column or at the end of your first row. Notice that Excel displays the cursor location and cell name below the toolbars at the top of the screen.
5. Begin every formula by typing the equal sign. Excel immediately displays it in the Formula Bar that is above the worksheet's first row.
6. Click the first cell that you want to include in your formula. Excel adds the cell name to your formula. Type a mathematical function. If you are adding numbers, use the plus sign on your keyboard. For subtraction, use the minus sign. To divide, use the slash on the question mark key. To multiply, Excel uses the asterisk, above the number 8 on the keyboard.
7. Click each cell that you want in your formula, then type the arithmetic function that you need. Click the green check mark at the beginning of the formula bar when your formula is finished.
AutoSum
8. Use Excel's AutoSum button for faster addition of one column or row of numbers. It will be much easier than clicking on each cell and typing the plus sign.
9. Place your cursor in the first empty cell after your numbers. Click the AutoSum button. It resembles a fancy capital letter E and is located on Excel's editing toolbar. Excel highlights all the cells in the column above until it reaches an empty cell. For data in rows, Excel selects data to the left of the cursor.
10. Click the green check mark in the formula bar to complete the formula.
Use Excel Functions in Formulas
11. Make a formula with Excel's built-in mathematical functions by placing your cursor in an empty cell first. Then type the equal sign to start the formula. Choose Formulas, and then choose Insert Function in Excel 2007. In Excel 2003, click to open the Insert menu, then select Function from the drop-down list.
12. Select the function that you want. Your choices include financial, date, time, statistical, engineering, trigonometry, logical and many others, arranged in categories. To see all of the functions, select All in the category drop-down box.
13. Select the function that you need by highlighting it in the function list. Click on it to insert it into your formula. Excel places it in the formula bar. Select the function COUNT or AVERAGE to try this out.
14. Complete your formula by clicking each cell that you want to include in the formula. After you finish adding cells, click the green check mark. Excel displays the results of your function's calculation.

Read more ►

How to Create a Conditional Formula in Excel 2007

1. Open an existing or new Microsoft Excel 2007 document. Click 'Start' from the main operating system menu. Then choose 'Programs' from the start menu. Select 'Microsoft Office' from the programs menu. Next, choose 'Microsoft Excel' from the Microsoft Office menu. Now either choose 'New' from the main menu or locate the existing Excel document to use for a conditional formula.
2. Establish the parameters for the conditional formula. For example maybe a person can create a conditional formula for an invoice discount. That way if the invoice is paid in under a certain number of days then a client would receive a percentage discount.
3. Structure the conditional formula. In this example say that if the invoice is paid in less than thirty days, the customer receives a five percent discount. The conditional formula would look like this: IF((C5-B5)
4. Type the conditional formula in the spreadsheet. A person can either type the formula in or use the conditional function. To use the conditional function click on the 'Formulas' tab and choose the 'Logical' option from the format library.
5. Enter the conditional formula in the 'If' formula function dialogue box. Once the 'If' function dialogue box appears enter the previous formula parameter in the provided input boxes. In the 'Logical_test' box enter 'C5-B5
6. Test and save the Microsoft Excel 2007 spreadsheet. Be sure that the conditional formula is working correctly by observing the results and check them against the known data. When the formula is satisfactory, save and close the spreadsheet.

Read more ►

How to Set Up an Employee Schedule in Excel

1.
Open a blank Excel worksheet. Go to the 'Insert' tab in Excel 2007 or the 'View' menu in Excel 2003 or earlier and select 'Header Footer.' Select 'Custom Header' and enter 'Employee Schedule.'
2.
Go to the 'Page Layout' tab in Excel 2007 and click on 'Orientation.' Select 'Landscape.' In Excel 2003 or earlier, go to the 'File' menu and select 'Page Setup.' Select 'Landscape' on the 'Page' tab. Enter 'For the week of:' in cell 'A1.' Select cell 'A4.'
3.
Set up the cell by changing the font size to '12' and select 'Bold' in the 'Font' group of the 'Home' tab in Excel 2007 or on the 'Formatting' toolbar in Excel 2003 or earlier. Type in the first day of the scheduled workweek for employees.
4.
Select cell 'B4.' Type in the first scheduled time for employees to start work. Enter increments of time in the remaining cells of 'Row 4.' These may be hour or half hour increments, or you might want to only enter shift change times.
5.
Select cell 'A5.' Enter the name of the first employee by alphabetical order. In cell 'A6,' enter the next employee alphabetically, and so on until all employees are set up in the schedule.
6.
Skip a row and repeat steps 3 through 5 with the second day of the workweek. Repeat with the remaining days of the workweek. Add color to the cells containing days, times and employee names by using the 'Fill Color' button in the 'Font' group of the 'Home' tab in Excel 2007, or the 'Formatting' toolbar in Excel 2003 or earlier.
7.
Save the employee schedule as an Excel template. Click the 'Office Button' in Excel 2007 or the 'File' menu in Excel 2003 or earlier and select 'Save As.' Enter 'Employee Schedule' under 'File Name.' Select 'Excel Template (*.xltx)' under 'Save as Type' in Excel 2007 or 'Template' in Excel 2003 or earlier and click 'Save.' This will allow you to reuse the schedule without having to set it up again.

Read more ►

How to Remove 'Getting Started' From Microsoft Excel

1. Launch the Excel application.
2. Click 'Tools' and then 'Options.'
3. Click the 'View' tab. Remove the check mark next to 'Startup Task Pane' and click 'OK' in the dialog box.

Read more ►

How to Make an Excel Sheet Into a Form

1. Open Excel 2010 and select a workbook containing data. Click the 'File' tab and select 'Open.' Browse the files and locate the workbook. Click the workbook and select the 'Open' button. The workbook will open.
2. Add the form to the Quick Access Toolbar by clicking the right drop-down arrow on the Quick Access Toolbar. Select 'More Commands.' Click 'All Commands' in the 'Choose Commands From' section. Drag the scroll bar down and click 'Form.' Click the 'Add' button to add the button to the Quick Access Toolbar. Click 'OK.'
3. Highlight the data in your spreadsheet. Make sure you highlight the column headers too. Click the 'Form' button. A form will appear containing your data.

Read more ►

How to Create a Flow Chart in Excel 2007

1.
Open an Excel worksheet. Go to the 'Insert' tab of the ribbon and click the 'Shapes' drop-down arrow. Select the first shape you want to use from the 'Flow Chart' shape gallery.
2.
Click on the worksheet where you want to place the first shape. Go back to the 'Shapes' gallery, click on the next shape you want to use and place it on the worksheet. You can click on a shape, hold down the mouse button and drag it into position as well. Repeat until all the shapes you need are on the worksheet.
3.
Go back to the 'Shapes' gallery and select the first connector you want to use in the 'Lines' gallery. Click on the first shape in the flowchart from where you want the connector line to begin. Click on the second shape where you want the connector line to end. Repeat with the remaining shapes.
4.
Right-click the first shape and select 'Add Text.' Type a brief description for the first step in the process. Repeat with the remaining steps.
5.
Go to the 'Format' tab and select a color scheme from the 'Smart Art' gallery, or apply effects such as '3-D' or beveled lines. Save the worksheet when you are finished.

Read more ►

How to Reduce File Size in Excel Without Using Software

1. Click on any cell in the Excel file you want to reduce. Open the 'Go To' dialog box in Excel 2007 by clicking the 'Find' drop-down arrow on the Home tab of the ribbon and selecting 'Go To.' In Excel 2003 or earlier, go to the 'Edit' menu and select 'Go To.' You can also use the keyboard shortcut 'Ctrl G' in any version of Excel.
2. Click the 'Special' button on the 'Go To' dialog box. Select 'Blanks' and click 'OK.' Click the 'Clear' drop-down in the 'Editing' group in Excel 2007 and select 'Clear All.' In Excel 2003 or earlier, go to the 'Edit' menu, point to 'Clear' and select 'All.' This will clear any blank cells to help reduce the file size.
3. Go to the very last cell containing data in the Excel file. Select the entire row beneath this cell by clicking the number to the left of it. Hold 'Ctrl Shift' and then press the down arrow key to select all of the cells beneath this point.
4. Click the 'Clear' drop-down in the 'Editing' group in Excel 2007 and select 'Clear All.' In Excel 2003 or earlier, go to the 'Edit' menu, point to 'Clear' and select 'All.' Select the column to the right of the last cell. Hold 'Ctrl Shift' and then press the right arrow key. Again, select 'Clear All.'
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce. Save the files and then check the new file size by clicking the 'Office Button' in Excel 2007. Point to 'Prepare' and then click on 'Properties.' In Excel 2003 or earlier, go to the 'File' menu and select 'Properties.' The file size will be listed on the 'General' tab.

Read more ►

Microsoft Excel 2003 Is Slow in the Page Break Preview

1. Open the Microsoft Excel 2003 file on your computer that contains the page breaks that you are having problems with.
2. Click the 'Tool' menu from the top of the page and then click the 'Options' button. The Options dialog box will then appear on your screen.
3. Click the 'View' tab. Click the box next to the 'Page breaks' field so it is no longer checked.
4. Click the 'OK' button and you will close the dialog box. The page breaks view will be disabled.
5. Click the 'File' option and then click the 'Page Setup' option. Select any changes to meet your preferences and then return to your document.

Read more ►

How to Use Excel to Calculate Coefficient of Variation

1. Enter the data to be analyzed in one column of an Excel spreadsheet.
2. Use the Excel AVERAGE() function to calculate the mean of the data. In a blank cell on the spreadsheet, type '=AVERAGE(' (without quotes) and highlight all of the cells containing the data. Press 'Enter' to see the mean of the data.
3. Use the Excel STDEV() function to calculate the standard deviation of the data. In a second empty cell, type '=STDEV(' (without quotes) and highlight the data. Press 'Enter' to view the standard deviation of the data.
4. Divide the standard deviation by the mean: in a third empty cell, type '=' (without quotes) and click on the cell containing the standard deviation. Type '/' (without quotes) and click on the cell containing the mean. Press 'Enter' to view the coefficient of variation.

Read more ►

How to Convert Multiple Columns in Excel to a Single List in Word

1. Open the Excel 2010 file that you want to work with. Right-click on the 'A' above the first column and choose 'Insert.' This creates a blank first column that you will use to construct your list.
2. Press 'Alt' and 'F11' to launch the Excel VBA console. Right-click on any worksheet in your current workbook -- these are listed on the left side of the console -- move your mouse over 'Insert' and choose 'Module.' Double-click on the module which appears in the list.
3. Copy the following code and paste it into the white space on the right side of the VBA console:Sub Combine()Range('B1').SelectDo While ActiveCell > ''Range(ActiveCell, ActiveCell.End(xlDown)).Copy Destination:=Range('A10000').End(xlUp).Offset(1, 0)ActiveCell.Offset(0, 1).SelectLoopEnd SubThis code creates a macro, called 'Combine,' which combines all adjacent columns, starting with column 'B,' into one long list in column 'A.' If you think the total number of cells will be larger than 10,000, increase the number '10000' in the code so that it will be larger than the number of all your cells combined. The macro runs until it encounters a blank cell in the top row of a column.
4. Click the 'Play' button in the middle of the bar at the top of the VBA console. This creates your list in column 'A.' Click the 'X' in the top-right corner of the VBA console to close it.
5. Select the 'A' above the first column to select the entire column. Press 'Ctrl' and 'C' to copy the information to your clipboard.
6. Open the Microsoft Word 2010 file where you want to paste the list. Click the document to place your cursor wherever you want to insert the list.
7. Click the bottom of the 'Paste' button to open up a pop-up window. Choose the icon labeled with a large 'A' to insert the information as text.
8. Click the last item in the inserted items and hold the mouse button down. Drag the mouse up to the first item and release the mouse button, selecting the entire range of items. Click the 'Home' tab at the top of the screen and find the 'Paragraph' section. Click the 'Bullets' or 'Numbering' buttons to turn the information into a list.

Read more ►

How to Change Pivot Table Source Data

Microsoft Excel 2007
1. Open the Microsoft Excel 2007 application on your computer. Click on the “Microsoft Office” button from the top-right corner of the application.
2. Click on the “Open” option and then locate the Excel 2007 file that contains the pivot table for which you want to change the data source. Click on the “Open” button.
3. Click on the “Options” tab from the top toolbar menu and then click on the “Change Data Source” button from the “Data” group.
4. Click on the radio button next to the “Select a table or range” field. Click on the button in the “Table/Range” field.
5. Select the new range for your data within the pivot table and then click the “OK” button in the Change Pivot Table Data Source dialog box.
Microsoft Excel 2003
6. Open the Microsoft Excel 2003 application on your computer. Click on the “File” option from the top toolbar menu.
7. Click on the “Open” option and then find the Excel 2003 file that contain the pivot table for which you want to change the data source. Select the file and then click on the “Open” button.
8. Right-click on any cell in the pivot table and then click on the “Wizard” option. The PivotTable and PivotChart Wizard will appear on the screen.
9. Click on the “Back” button. Select the radio button next to the “Existing worksheet” field and then click inside of the text box.
10. Select the new range for your pivot table within the spreadsheet and then click on the “Finish” button from the dialog box.

Read more ►

How to Find Delete Multiple Instances in Excel

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' followed by 'Microsoft Excel' to open the spreadsheet software.
2. Click the 'File' ribbon tab, then click 'Open.' Double-click the Excel spreadsheet file that contains the duplicate values.
3. Highlight all the cells you want to check for duplicates. Click the 'Data' ribbon tab at the top of the window. Click 'Delete Duplicates' to start the wizard.
4. Check the box for each column you want to check from the selection. If you want to check all columns, click 'Select All.'
5. Click 'OK' to run the duplicate checker. The window displays the number of duplicates found. Click 'OK' to delete the duplicate instances.

Read more ►

How to Unlock an Excel Workbook Without Knowing the Password

1. Download and install Excel Password Remover 2010 from Straxx.com (see Resources). This is an Excel add-in file that will place two new options, 'Unlock sheet' and 'Unlock Workbook,' under the 'Tools' menu. This is an effective, free program.
2. Try Passware Kit Basic 10.1 (see Resources). This software can recover passwords for Microsoft Word, Excel, and Powerpoint files, as well as passwords for email accounts, network connections and local Administrators.
3. Download Excel Password Recovery Master (see Resources). This software offers near instant recovery of password. Length and complexity of passwords do not affect the speed at which they are recovered. Excel Password Recovery Master also supports Multilingual passwords.

Read more ►