How to Create a Report to Display Quarterly Sales in Excel 2007

1. Open a new Excel workbook. A blank spreadsheet will appear on the page.
2. Click on cell 'A1,' which is the top-left cell in the spreadsheet. Type 'Quarter' into the cell and press 'Enter.' Excel will automatically select cell 'A2,' as it is directly beneath the first cell.
3. Type the names of the quarters into the cells directly beneath the first one. Each quarter should have its own cell, and be sure to include year numbers of your data spans more than four quarters. After you type the name of each quarter, press 'Enter' to go to the next cell.
4. Select cell 'B1,' which is directly to the right of the 'Quarter' cell. Type in your data's header here. If you only have one set of sales numbers for each quarter, you can simply type 'Sales' into this cell. If your data is broken down by different regions, stores, channels, or in any other way, enter in a header for the first data series into this cell, then enter the next header into cell 'C1,' and continue until each series of data has a header.
5. Enter your numerical sales data into the cells where the rows representing the quarter intersect the columns representing the data fields.
6. Click cell 'A1.' Press 'Ctrl' and 'A' to select the entire table. Click the 'Insert' tab at the top of the screen. Select the 'Column' button, and choose one of the 'Clustered' column chart options. Excel will create a chart based on your table data. The column headers will automatically be listed to the right of the chart, and the quarters will be listed beneath it.
7. Select the first empty cell to the right of your column headers. Type 'Total' into this cell. Select the cell just beneath this one and enter this formula: '=sum(B2:XY)' where 'XY' is the column letter and row number of the cell just to the left of the current one. Press 'Enter' to complete the formula. Select the cell and move your mouse over the bottom-right corner. Click and hold the mouse button while you drag the mouse down to the last row in the data field. Release the button to copy the formula all the way down the table, making it easy to read the total sales for each quarter.

Read more ►

How to Delete a Single Cell Excel 2003

1. Click the Excel cell you wish to delete.
2. Select 'Edit' at the top of the Excel window. Click 'Delete' from the menu, which opens a dialog box.
3. Select one of the following options in the box: 'Shift Cells Left,' Shift Cells Up,' 'Entire Row' or 'Entire Column.'
4. Click the 'OK' button to close the dialog box, and complete the deletion of the cell.

Read more ►

How to Restore Microsoft Excel to Its Defaults

Option One
1. Open up Microsoft Excel.
2. Click on the 'Tools' menu and then click 'Customize.'
3. Right-click the menu you want to restore and then click the 'Reset' button. This will restore the menu to its original settings. Consequently, restoring all the menus will restore Microsoft Excel to its defaults.
Option Two
4. Click the 'Help' menu in the upper right-hand corner.
5. Select 'Detect and Repair' from the scroll-down menu. Make sure the 'Restore my shortcuts while repairing' is selected.
6. Click 'Start.' This process will restore Microsoft Excel to its original settings (i.e., how it appeared when you first installed it).

Read more ►

How to Repair a Corrupt XLSX File

1. Navigate to the folder containing the XLSX file you want to repair.
2. Right-click the file and select 'Copy' and then right-click on a blank space within the folder and select 'Paste.' This action generates a backup copy of the corrupted file.
3. Open Microsoft Excel 2007 or later.
4. Click the 'Office' button in the top left corner of the window and select 'Open.'
5. Navigate to the folder containing the copy of the XLSX file you generated previously and select it by single-clicking its icon.
6. Click the arrow located to the right of the 'Open' button and select 'Open and Repair.'
7. Select 'Repair.' If you previously attempted this method and the process failed, try to extract only the values and formulas by selecting 'Extract Data' instead. Regardless of the method you choose, your data will appear on the screen within a few seconds if the process completes successfully.

Read more ►

How to Calculate an Interest Rate Using Excel

1. Do your homework. To find the interest rate, you will need to know the time period or length of the loan or investment, the monthly payments and the principle of the loan or investment.
2. Create an Excel spreadsheet to determine your interest rate. Enter a list of headings-Current Value, Future Value, Monthly Payment and Number of Payments. If you begin in cell A1 with the heading 'Current Value,' the remaining headings listed here will fall in cells A2, A3 and A4.
3. Enter the information required in the cells to the right of the headings. If you began in cell A1 as suggested above, you will enter your financial information in cells B1 through B4.
4. Key in the following formula in the cell under your financial data to determine the interest rate of the investment or loan [=Rate (B4,B3,B1)]. Then click the Enter button on the formula bar.
5. Make your decision. When complete, the formula will tell you the interest rate you will be paying on your loan or earning on your investment. If the terms of the investment change during your negotiations, simply re-enter the new information to see if the interest rate is good for you.

Read more ►

How to Do Bar Charts in Excel 2007

1. Open Microsoft Excel 2007 by double-clicking on the Excel 2007 icon. After Excel loads, open up the spreadsheet you want to make a bar chart for by clicking 'Open,' then selecting the file.
2. Arrange the data on your spreadsheet into either columns or rows. Essentially, you want one heading, followed by data in the cells directly to the right of it (for rows) or directly below it (for columns). Do this for each bar you want to have in your chart. For example, if you want three bars in your bar chart, you'll need three headings, each followed with data.
3. Highlight all of the data. To do this, click on one cell, hold the mouse button down, and drag the cursor across the rest of the data until it's highlighted.
4. Click 'Charts,' which can be found under the 'Insert' tab near the top of Excel 2007. Click 'Bar Chart.' A bar chart will be embedded on your Excel worksheet. To move the chart to a different location, click on it, then click the 'Design' tab, then 'Move Chart.' You can also change the name of your chart by clicking the 'Properties' tab.

Read more ►

How to Draw a Scatter Plot on Microsoft Excel

1. Open a blank worksheet in Microsoft Excel. Enter two columns of data you want to plot on a scatter chart. The data should be two sets of value that intersect. For instance, in column A, you could enter daily rainfall in inches, and in column B, enter temperature in degrees. These are two sets of data that intersect at single data points. Enter the title of each set of data in the first cell of each column.
2. Highlight the cells you want to plot on the chart.
3. Click the 'Insert' tab. In the 'Charts' group, select 'Scatter.'
4. Select a chart icon for the scatter plot you want to use. For instance, click the 'Scatter with Only Markers' icon to create a scatter plot without lines. The chart will appear in your workbook.
5. Click in the chart area to display the 'Chart Tools' tabs.
6. Click the 'Design' tab to select a chart style.
7. Select the chart title and type a new name for the scatter plot. Right-click the title. Use the context menu to change the font and font size of the title.
8. Click the chart area. Click the 'Layout' tab. Click 'Axis Titles' in the 'Labels' group to add both horizontal axis and vertical axis titles, and choose the type you want. Select each title, type the text and press 'Enter.'
9. Select the plot area, and use the 'Format' tab to select the shape style you want to use for the plot.
10. Click the 'Microsoft Office' button, and click 'Save As' to save the scatter plot in your workbook.

Read more ►

How to Disable a Macros Using VBA Excel

1. Open the Excel workbook in which you want to change your macro settings.
2. Click the Microsoft Office icon button in the top, left of your window.
3. Select 'Excel Options' and click 'Trust Center.'
4. Click 'Trust Center Settings' and select 'Macro Settings.'
5. Uncheck the box for the security option 'Trust access to the VBA project object model.'
6. Click 'Apply' and close your settings windows.

Read more ►

How to Convert to VBA in Excel 2007

1. Open Excel. Click the Office button and select 'Excel Options' from the bottom of the menu that opens.
2. Select the 'Popular' tab from the menu on the left. Click the box next to 'Show Developer Tab in the Ribbon.' This will allow you access the VBA editor function.
3. Click the 'Trust Center' tab and select 'Trust Center Settings.'
4. Choose 'Enable All Macros' under 'Macro Settings' and then check the box next to 'Trust Access to the VBA Project Object Model.'
5. Click 'OK.' After you exit to 'Excel Options,' click 'OK' again to go back to Excel. VBA will now be activated.

Read more ►

How to Find Duplicate Cell Content on Excel 2003

1. Place the cursor in cell A1 (or the first cell where you want to test for duplicates). Click the 'Format' menu and then click 'Conditional Formatting.' Click the down-arrow in the box under 'Condition 1' and select 'Formula Is.' Enter the following formula into the text box to the right of 'Formula Is.'=COUNTIF(A:A,A1) > 1
2. Click the 'Format...' button on the right side of the window. Click the 'Patterns' tab and select an easy-to-find color such as red or yellow. Click 'OK.'
3. Click the 'Edit' menu with the cursor still in the cell where you entered the formula and select 'Copy.' Press and hold 'Ctrl' and then press the spacebar at the same time to select the entire column. Click the 'Edit' menu again and select 'Paste Special.' Choose the 'Formats' option in the Paste Special dialog and click 'OK.' Any duplicates found in the column will be highlighted with the selected color.

Read more ►

How to Create New Table Style in Excel 2007

1. Locate the Styles group under the Home tab. Click 'Format as Table.'
2. Choose an existing table. Table styles are organized under light, medium and dark. Each style includes a variety of color choices.
3. Click anywhere in the table to bring up Table Tools. Select the Design tab and click 'More.' Select 'New Table Style.' Type a name for the new table you are creating in the name box.
4. Makes changes to the Table Element box by clicking on each element. Click 'Format' to format or 'Clear' to clear the existing formatting.
5. Click the options you want from the Font, Border and Fill tabs. Press enter or click 'OK' after you make your choices. You can also change the look of a table by turning elements on and off from the Table Tool tab. This allows you to include or omit headers, rows, row banding, column banding, and emphasis on first or last columns.
6. Vary the colors of the table. Look in the Table Styles gallery to choose among sixty different color schemes.
7. Check the formatting changes you made by Previewing. Adjust your changes as needed, and then save.

Read more ►

Tutorial for Solving a System of Linear Equations With Excel

1. Type the equation into a cell, substituting another cell's reference for the equation's variable. For instance, if the equation is '6x 33 = -1,' type '=A2 * 6 33' into cell A1.
2. Click on 'Data' from the menu bar. Click 'Solver' from the 'Analysis' tab.
3. Type the formula's cell reference into the 'Set Objective:' box. With this example, type 'A1.'
4. Enter the equation's target value in the 'Value Of:' box. With this example, type '-1.'
5. Type the cell reference that you substituted in Step 1 into the 'By Changing Variable Cells:' box. With this example, type 'A2.'
6. Click 'Solve.' Excel will change the cells' values to solve the equation. With this example, cell A1 will become '33,' and cell A2 will become '-5.667.'
7. Repeat the process for all your linear equations.

Read more ►

How to Merge Workbooks in Excel

Preparing a Workbook to Be Shared
1. Open the workbook you want to distribute.
2. Open the Tools menu and click Share Workbook, and then click the Editing tab.
3. Select the 'Allow changes by more than one user at the same time' box.
4. Click the Advanced tab.
5. Under 'Track changes,' click 'Keep change history for.'
6. In the Days box, type a few days longer than the number of days reviewers will spend making changes and comments in the shared workbook.
7. Click OK.
8. Save the workbook.
9. Make copies of the workbook to distribute by using the Save As command in the File menu. Give each copy a different name, such as 'Budget - Sulhi copy' and 'Budget - Marina copy.'
Merging the Shared Workbooks Back Together
10. Open your base copy of the workbook you distributed.
11. Open the Tools menu and select Merge Workbooks.
12. Save the shared workbook if you are prompted.
13. In the box that appears, select one of the copies you made of the workbook.
14. Click OK.
15. Repeats steps 2 through 4 until all copies of the shared workbooks are merged.

Read more ►

How to Protect Macros in Excel 2003

1. Access the Excel 2003 workbook that contains the macro you need to protect. Click the 'Tools' menu and select 'Macros.'
2. Click 'Visual Basic Editor.' Click the 'Tools' option and then select 'VBAProject Properties.'
3. Navigate to the 'Protection' tab. Click the check box labeled 'Lock project from viewing.'
4. Type the password you want to use for the macro in the text box. Press 'Tab' and then type the password again in the second text box.
5. Click 'OK' and then save your Excel workbook.

Read more ►

How to Do an Outline in Excel

1. Open the Excel 2010 file that holds the data that you want to outline.
2. Insert summary columns into your data. These are the columns that will summarize the hidden numerical data when you outline is compressed. Right-click the column letter where you want to place the column and select 'Insert.' Select the cell next to the cells that you want to subtotal and enter in '=subtotal(9,X:Y)', where 'X' is the first cell in the range and 'Y' is the last.
3. Click the letter where you want to start your outline. Hold 'Shift' and select the letter where you want end your outline. If you have a summary column at the end of your data, do not include it in your selection.
4. Select the 'Data' tab from the top of the screen. Find the 'Outline' area and click the 'Group' button. A line will appear above the cells, with a '-' on one end. You can click the '-' to close the outline. Just click the ' ' button to open it again. Because your summary column was not included in your selection, it will remain visible when you close the outline.
5. Select additional columns within the overall outline selection. Click the 'Group' button again to group these columns together. Another line will appear, this time just below the first one.
6. Continue to group columns in the same manner until your outline is finished. Your outline can grow up to eight levels deep.

Read more ►