How to Make an Invoice Spreadsheet in Excel

1. Open Microsoft Excel. A blank spreadsheet will open, and you will notice that predetermined rows and columns are already set up.
2. Enter a title at the top of the spreadsheet. Start typing your title into cell A1. Having a clear and specific title for the spreadsheet will help you remember what invoices are on a particular spreadsheet. Perhaps you need separate spreadsheets for invoices received and invoices sent out. Bold the title by clicking on the cell and using the bold tool on the top toolbar.
3. Set up column headings a few lines down from the title. Begin entering column headings in column A. Some helpful column headings include Invoice Date, Invoice Number, Person or Company being invoiced, Invoice Amount, Date Received, Date Paid and others depending on your exact purpose for the invoice spreadsheet.
4. Bold and center the column headings. Click on the number to the left of the row where the column headings are entered; the entire row will be selected. Use the tools on the top toolbar to bold and center the column headings.
5. Enter data into the spreadsheet. Be sure to plug everything into the appropriate column. If you are missing a piece of information, simply leave the cell blank.
6. Format cells that contain numbers so that all of the numbers in the column look the same. To format cells, highlight all of the cells that have the same types of numbers in them, such as amounts. Then right-click on the highlighted cells and select 'Format Cells.' In the box that opens up, click on the 'Number' tab. Click 'Currency' in the 'Category' box to format all cells that contain amounts in the same way. Then choose how many decimal places you want to include and click 'OK.' You can also format dates, ZIP codes, phone numbers and other data. Select these options from the 'Category' box--if you don't see something listed there, it is most likely listed under 'Special.'
7. Add totals to the spreadsheet. To do this, click in the cell where you want the total to be located. Click on the sigma symbol (it looks sort of like a capital E) on the top toolbar. Click on the first cell to be included in the total, then drag down until the last cell to be included is selected. The cells will be outlined in a moving-dashed box. Press the 'Enter' key and the total will be inserted.

Read more ►

How to Alphabetize a List in Works/Word Documents

1. Type your list, in no particular order, with each item on a separate line.
2. Highlight the complete list.
3. In the 'Home' tab, in the 'Paragraph' group, select 'Sort.'
4. In the Sort Text dialog, navigate to 'Sort by.' Then select 'Paragraphs and Text, and then click either 'Ascending' or 'Descending.' Add more entries to the bottom of the list as necessary. Repeat the sort procedure of the list with the additions.

Read more ►

How to Close the Header Footer Screens in Excel 2007

Reset Normal View
1. Press the 'Esc' key if you are in 'Full Screen' mode and cannot see the Office Ribbon.
2. Click the 'Views' tab on the Office Ribbon.
3. Select 'Normal' in the 'Workbook Views' section. This will work from any view unless you have an open dialog box that you must address first. In that case, click 'Cancel' or 'OK' in the dialog box, depending on what the screen prompts say, then select the normal view.
Within Page Layout View
4. Place your cursor at the top edge of the page, where the white that represents the page ends before the top ruler or formula bar. The cursor will turn to an icon with two arrows pointing toward each other.
5. Click your mouse button while the cursor is in this mode. This hides your header and top margin while keeping you in 'Page Layout' view.
6. Scroll to the bottom of the page and place your cursor along the bottom edge until the double arrow icon appears again.
7. Click to close the footer.

Read more ►

How to Scatter Plot Data on Excel

Scatter Plot Data in Excel 2003
1. Open Microsoft Excel 2003.
2. Place one set of data in one column and another set of data in an adjacent column. For example, place one set of data in column A, which will be your X values, and then place another set of data in column B, which will be your Y values.
3. Select the range of values to be included in the scatter plot chart. To select the range, click the first cell to be included and then drag your mouse towards the last cell to be included.
4. Click the 'Insert' menu and click 'Chart.'
5. Click 'XY (Scatter)' under the 'Chart Type' box. Select the chart sub-type you want to use under the 'Chart sub-type' box.
6. Click 'Next.' This will show you the data range and a view of your chart.
7. Click 'Next' to proceed to the 'Chart Options' window. Enter the information for 'Chart Title,' 'Value (X) axis,' and 'Value (Y) axis.' The 'Value (X) axis' is a descriptive title for the values of the X axis, while the 'Value (Y) axis' is a descriptive title for the Y axis. For example, if you're tracking weekly expenses, you can use 'Days' for the title of the X axis and 'Total Daily Costs' for the title of the Y axis.
8. Click 'Next' to proceed to the 'Chart Location' box. You have the option of placing the chart in the same worksheet as your data or in a separate worksheet.
9. Click 'Finish' to exit and display the scatter plot chart.
Scatter Plot Data in Excel 2007 or 2010
10. Open Microsoft Excel.
11. Place one set of data in one column and another set of data in an adjacent column. For example, place one set of data in column A, which will be your X values, and then place another set of data in column B, which will be your Y values.
12. Select the range of values to be included in the scatter plot chart. To select the range, click the first cell to be included then drag your mouse towards the last cell to be included.
13. Go to the 'Insert' tab. Click 'Scatter' under the 'Charts' group menu.
14. Click 'Chart Area' for the XY chart. This displays the 'Chart Tools,' 'Design,' 'Layout,' and 'Format' tabs specific to the XY chart.
15. Go to the 'Design' tab and click the chart style you want to use.
16. Type the title for your chart under 'Chart Title.'
17. Go to the 'Layout' tab and click 'Axis Titles.' Click the 'Primary Horizontal Axis Title' to place a title for the horizontal axis. Click the 'Primary Vertical Axis Title' to place a title for the vertical axis.
18. Press 'Enter' to exit and show the chart.

Read more ►

How to Lock Column Width in Excel 2007

1. Open Excel 2007 and click the 'Office' button. Select 'Open.' Browse the files and locate the workbook. Click the workbook and select 'Open.'
2. Select the worksheet in the workbook where the locked column width will occur. Right click the column header and select the 'Protection' tab. Make sure 'Locked' is selected. Click 'Ok.'
3. Click the 'Review' tab and select 'Protect Sheet.' Make sure the 'Protect worksheet and contents of locked cells' is selected. De-select the option to 'Select Locked Cell.' Click 'Ok.'
4. Right click the column and notice the option to adjust the column width is grayed out and not available.

Read more ►

How to Remove Filters in Excel 2003

1. Open Excel 2003 and select a workbook with data. Click 'File' on the menu bar. Click 'Open.' Search your files and locate the workbook. Double-click the workbook. The workbook opens.
2. Click the column header in the first column of your data. Select 'Data' on the menu bar and select 'Filter.' Click 'AutoFilter.' Drop-down lists appear in the column headers of your data. Click one of the drop-down lists and select a value. Notice your data is immediately filtered by this value.
3. Remove the filter by clicking 'Data' on the menu bar and selecting 'Filter.' Select 'AutoFilter.' The filter is removed from your data.

Read more ►

How to Change an Excel Chart to Ascending Order

1. Click on the column heading. This is Column A, B, C, etc, in a basic worksheet or the Table in a PivotTable report. Again, you must change the chart data in order to change the chart. Chart data can originate from a basic or PivotTable form.
2. Click the arrow Filter drop-down on Column heading or Column Labels. Again, a column label is the Column heading in a PivotTable.
3. Click the arrow Filter drop-down. In PivotTables, the Axis Fields are categories and the Legend Fields are Series.
4. Change the Excel Chart data to Ascending order by clicking 'Sort A to Z' for text, 'Sort Smallest to Largest' for numbers and 'Sort Oldest to Newest' for dates and times.

Read more ►

How to Use Negative Numbers to Calculate in Excel

Calculating Negative Numbers
1. Enter a negative number into an Excel spreadsheet cell by using the minus sign (-) before the number.'-12' is an example of a negative number.
2. Use the arithmetic operator, the minus sign (-), to subtract a number using a formula.An example is the formula, '=25-10' that will give a result of '15.'
3. Use a function to calculate negative and positive numbers.An example of this is '=sum(a1:a3)', where cell a1=10, cell a2=12 and cell a3=-25 will give a result of '-3.'
4. Use a function to transform a positive result into a negative result by applying the negative sign (-) to the function. An example of this is '=-sum(a1:a3)' using the established values for those cells will give a result of '3.'
Change Negative Number Formats
5. Select a number or range of numbers to change the way Excel displays these numbers.
6. Click the 'Home' tab on the top menu and select the arrow in the 'Number' section.
7. Choose either the 'Number' or the 'Currency' category in the 'Category:' list in the 'Format Cells' window.
8. Select the number of decimal places by either typing it in or selecting the up or down arrow in the 'Format Cells' window.
9. Choose the 'Use 1000 Separator (,)' check box. Skip this if you are formatting currency.
10. Choose the currency symbol by clicking the down arrow in the box next to 'Symbol.' Skip this if you are not formatting currency.
11. Select the number format in the 'Negative numbers:' box in the 'Format Cells' window.
12. Click the 'OK' button.

Read more ►

How to Insert a Name in Excel 2007

1. Launch Excel 2007, and click on the cell for which you want to insert a name.
2. Click the 'Formulas' tab in the menu bar at the top of the window. In the 'Define Names' section, click the 'Define Name' button. Thereafter, a box titled 'New Name' will pop-up on your screen.
3. Enter the name you want to assign for the cell in the field displayed beside where it says 'Name.' If you choose a name that has two or more words, you'll need to separate each word with an underscore. Select the scope for the cell by clicking the 'Scope' drop-down menu and choosing to set the name for either the workbook or specific sheet of your Excel workbook.
4. Type any comments you may need to use as reference in the text field located beside where it says 'Comment.' You can use the comment area to remember the new name of the cell or how the cell is being used on your spreadsheet.
5. Click the 'OK' tab to finish inserting the name. Now you will see the name you inserted displayed on the upper-left region of the Excel spreadsheet whenever you click on the cell. For instance, if the cell you inserted a name for was cell F7, now instead of seeing F7 when you click on this cell you'll see the name you inserted. Now you can use this name when creating new formulas for your spreadsheet.

Read more ►

How to Insert a Column in Microsoft Excel

1. Open an Excel Worksheet or create a new document.
2.
Highlight the column directly to the left of where the new column should appear.
3.
Select 'Insert' on the standard taskbar.
4.
Click 'Columns' from the drop down menu list. The new column is now found to the left of your highlighted selection.

Read more ►

How to Set Custom Views in Microsoft Excel 2003

1. Set up the page the way you want it to be viewed. Zoom in or out as desired. Determine the page breaks and customize the page as desired.
2. Scroll to the “Views” tab on command bar to access the Views menu.
3. Select “Custom Views” from the drop-down list; a Custom Views properties box will open.
4. Click on the “Add” button to add a custom view. Under the “Name” field, you can name the view you've created. Check the relevant boxes to specify if you wish to include the print settings and any hidden columns, rows and cells in your custom view.
5. Implement the custom view. To add it to your spreadsheet, click the 'OK' button.

Read more ►

How to Change a Negative Currency Into Positive in Excel 2007

1. Select the cell range you would like to format or change on the spreadsheet. These should be the currency numbers you want to change. To select all the cells in the worksheet, right click and Select All or CTRL A.
2. Click on the 'Format' menu. Scroll down to 'Cells.'
3. Click on the 'Number' tab and select 'Currency' or 'Accounting' in the box. Select the currency symbol you want.
4. Select the display style for negative numbers in the 'Negative Numbers' box. You can also choose the number of decimal places you want to display in the cell.

Read more ►

How to Edit the Footer in Excel 2007

1. Open Excel 2007 and select a workbook. Click the 'Office' tab, and select the 'Open' icon. Browse your computer for the workbook. Click the workbook, and select the 'Open' button. The workbook opens.
2. Click the 'Insert' tab. Select the 'Header and Footer' icon. Look at your workbook and notice the visible header. Click the 'Footer' button, and notice the three sections of the footer.
3. Highlight any existing text in the left footer section to edit it. If no text exists, type information in this section. Use the 'Tab' key to advance to the center section.
4. Repeat Step 3 to edit text in the center and right sections of the footer.
5. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar. Your footer edits are saved in your workbook.

Read more ►

How to Calculate Kurtosis Skew

1. Enter the data. In Excel, enter each value in a cell in column A.
2. Go to an empty cell. Click on Formulas, then More functions, then Statistical, and then Kurt. In the first box, highlight the cells containing your data, then hit 'Enter.' This is the kurtosis.
3. Go to an empty cell. Click on Formulas, then More functions, then Statistical, and then Skew. In the first box, highlight the cells containing your data, then hit 'Enter.' This is the skewness.

Read more ►

How to Run a T

1. Click the 'Data' ribbon in Excel 2007, then click 'Data Analysis.'
2. Click the T-Test type you want to use in the box that appears.
3. Click and drag the cursor over the categories and numbers you want to use.
4. Enter the alpha required for your test in the 'probability' field.
5. Click 'OK' to generate results.

Read more ►