How to Make an Invoice Using Excel

1. Navigate to the Excel templates website (see References below for link).
2. Select a template option and examine it for relevance to your needs. For example, click on 'Basic Invoice,' 'Sales Invoice,' or 'Service Invoice.' This brings up a window with a 'Download' button. Click on the button to download the template to your computer.
3. Locate the downloaded file on the computer by using Windows Explorer. To run Explorer, click on the 'Windows' button in Windows 7 or Vista or the 'Start' button in Windows XP, then click on 'Run.' Type 'Explorer' into the text box, then click 'OK.'
4. Double-click on the template file. The template will open up in Excel automatically, and you can then tailor the invoice to fit your needs by changing the business name, amount and other categories. When finished customizing the template, save it to the location of your choice on the computer for future use.

Read more ►

How to Find Standard Deviation on Excel 2007

1. Open Excel 2007 and select the 'Formulas' tab. Click the 'Statistical' button. A drop-down list appears.
2. Click 'Stdev.' The Standard Deviation function arguments window appears.
3. Type the first value in your standard deviation function in the 'Number 1' field. Type the second value in your standard deviation function in the 'Number 2' field. Click 'OK.' The standard deviation function is displayed in the cell.

Read more ►

How to Make a Stem Leaf Plot in Excel 2007

1. Rename a blank Excel worksheet “Data” by clicking the bottom tab for the worksheet and typing the new name.
2. Rename another blank Excel worksheet in the workbook “Stem” by clicking the bottom tab for that worksheet and typing the new name.
3. Enter your list of numbers in column A of the “Data” worksheet.
4. Press “Alt” and “F11” at the same time to open the visual basic editor.
5. Double click “This Workbook” under Microsoft Excel Objects in the left navigation pane to open a blank code window.
6. Paste the following VBA code into the blank window:
Sub StemAndLeaf()
dataColumn = 1'Clean everything out of the Stem worksheet.
Worksheets('Stem').Cells.Clear'Look at the Data worksheet.
Worksheets('Data').Activate'Find the maximum value.
rowPointer = 2
Do Until Cells(rowPointer, 1).Value = ''
rowPointer = rowPointer 1
Loop
Maximum = Cells(rowPointer - 1, dataColumn).Value'Set the divisor to strip off leaves.
divisor = 1
Do Until Maximum / divisor
divisor = divisor * 10
Loop'If the first digit of the largest value is less than 5, then
'use a smaller divisor.
'Otherwise you could end up with four or fewer rows in the plot.
If Fix(Maximum / divisor)
topStem = Fix(Maximum / divisor)'Set up the Stem worksheet.
Worksheets('Stem').Activate
Cells(1, 1).Value = 'Count'
Cells(1, 2).Value = 'Stem'
Cells(1, 3).Value = 'Leaves'
For rowPointer = 2 To topStem 2
Cells(rowPointer, 2).Value = rowPointer - 2
Cells(rowPointer, 3).Value = '|'
Next rowPointer'Calculate the counts.
'The following code is slower than it needs to be,
'but a faster code would be harder to read and understand.
Worksheets('Data').Activate
rowPointer = 2
Do Until Cells(rowPointer, dataColumn).Value = ''
measurement = Cells(rowPointer, dataColumn).Value
Stem = Fix(measurement / divisor)
Worksheets('Stem').Cells(Stem 2, 1).Value = Worksheets('Stem').Cells(Stem 2, 1).Value 1
rowPointer = rowPointer 1
Loop'Calculate the shrink factor.
Worksheets('Stem').Activate
maximumCount = 0
For rowPointer = 2 To topStem 2
If Cells(rowPointer, 1).Value > maximumCount Then
maximumCount = Cells(rowPointer, 1).Value
End If
Next rowPointershrinkFactor = Fix(maximumCount / 50)
If shrinkFactor
Cells(1, 4).Value = 'Each digit represents' Str(shrinkFactor) ' cases.''Return to the data, and fill the leaves in light of the values in the data.
Worksheets('Data').Activate
rowPointer = 2
Do Until Cells(rowPointer, dataColumn).Value = ''
measurement = Cells(rowPointer, dataColumn).Value
Stem = Fix(measurement / divisor)
leaf = measurement - Stem * divisor
leaf = Fix(leaf * 10 / divisor)Worksheets('Stem').Cells(Stem 2, 3).Value = Worksheets('Stem').Cells(Stem 2, 3).Value Trim(Str(leaf))
rowPointer = rowPointer shrinkFactor
Loop'Get to the Stem worksheet.
Worksheets('Stem').Activate
End Sub
7. Press “F5” to run the code. Your Stem and Leaf plot will appear in the “Stem” worksheet.

Read more ►

How to Reduce the Size of a Large Excel 2007 File

1. Press 'Ctrl' and 'End' at the same time. This will bring you to the bottom right cell of the worksheet.
2. Select all the rows between your real last used row, and the row that Ctrl End brought you to. To select a row, click on the row identifier (for example, 'A.'). To select multiple rows, hold down the 'Shift' key and click the first and last row. Press 'Delete.'
3. Select all the columns between your real last used column, and the column that Ctrl End brought you to. Press 'Delete.'

Read more ►

How to Use Scatter Plots in Excel

1. Open the Excel 2010 file containing the data you want to make into a scatter chart.
2. Arrange the data so the first row for each column has a header in the top row. The header is just a word that describes the data. If you need to add a row to accommodate the headers, right-click the number on the left side of the top row and select 'Insert' from the pop-up menu.
3. Arrange the information so that the leftmost column holds the values you want to use on the X-Axis. You can move a column by right-clicking on the letter at the top of the column and choosing 'Cut' from the pop-up menu. Then, right-click on the letter at the top of the first column and choose 'Insert Cut Cells.'
4. Select any cell within your data table. Click 'Insert' at the top of the screen. Find the 'Charts' area of the ribbon and click the 'Scatter' button. Choose one of the five different scatter chart types, which include 'Only Markers,' showing just the intersection of the data fields; 'Smooth Lines,' with a curved line running from one data point to another; and 'Straight Lines,' with a jagged line running between the data points. Smooth- and straight-line scatter charts are available with and without markers. Click the chart type and Excel will create the scatter chart.
5. Click the 'Quick Layout' button on the 'Design' tab to get a list of pre-set layouts for your chart. These layouts will control how the chart appears by adding axis titles, showing a number grid and displaying the marker data as numbers, as well as a few additional options. You can fine-tune the chart's appearance even more by selecting the 'Layout' or 'Format' tab and modifying the options from the ribbon.

Read more ►

How to Generate a Random Number in a Range in Excel

1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files or create a new blank spreadsheet into which you want to generate a random number within a range that you designate.
2. Select the cell or multiple cells that you want to generate the random number into. You can use the SHIFT or CTRL keys on your keyboard to select multiple cells at the same time. The cells that random numbers will be generated into will be outlined by a black heavy line.
3. Type '=RANDBETWEEN' (no quotes) into the 'Formula' textbox near the top of the Excel screen.
4. Continue to type the rest of the function that specifies the range you want the random numbers to fall into. '([Bottom],[Top])' (no quotes) should be inserted after '=RANDBETWEEN' (no quotes) with numbers replacing the word 'Bottom' and 'Top.' The 'Bottom' number should be the lowest random number you want to be generated ant the 'Top' number should be the highest number you want to be generated.
5. Press the 'Enter' key on your keyboard if you selected one cell or the 'CTRL ENTER' if you have selected multiple cells. You will now see random numbers have been generated in the range that you have specified.

Read more ►

How to Make a Bar Chart in Excel

1.
Open the Excel file that contains your data. If you have not created a file with your data yet, open a new Excel workbook and do that now. In this example, there is e a small list of data detailing how many people chose various animals as their favorite to use as an example.
2.
Use your mouse to highlight the cells that contain your data. In this example, cells A1 through B7 are highlighted.
3.
Choose the “Insert” menu from the toolbar in Excel. Now choose the “Bar” chart submenu. Pick which type of bar chart you would like to create. For the example, use the simplest 2-D version.
4.
Look over the chart you created and decide if you want to make any changes to the format. Feel free to experiment here. If you try something and find that you don’t like it, you can always use the “Undo” key to return to your file’s previous state.
5.
Save your file so that you don’t lose your work.

Read more ►

How to Use Microsoft Excel Date Difference Function

1. Type a date into a cell. For example, type '10/02/2010' into cell A1.
2. Type a second date into a cell. The second date should be later than the first date. For example, type '10/06/2010' into cell B1.
3. Type an interval into another cell. For example, type 'd' into cell C1.
4. Click on another cell and type the DATEDIF formula, inserting the cell locations of the DATEDIF components. In this example, type '=DATEDIF(A1,B1,C1)'.
5. Press the Enter key for the result. In the example, the result returned will be '4,' indicating there are four days difference between the two dates.

Read more ►

How to Set Margins in Powerpoint

Set Margins for Print
1. Open the presentation in Microsoft PowerPoint.
2. Select 'File' and 'Page Setup' from the toolbar. Select an option from 'Slides sized for.'
3. Use the scroll bar to adjust the height and width or type it in. Then click 'OK.'
Set Margins for Text Boxes and AutoShapes
4. Select the text box or AutoShape on your slide.
5. Double-click the selection to open the 'Format Text Box' or 'Format AutoShape' dialog box.
6. Go to the 'Internal margin' section under the 'Text Box' tab. Then change the left, right, top and bottom margins and click 'OK.'

Read more ►

How to Convert Dates in Excel

1. Open the worksheet.
2. Click the cell or a selection of cells.
3. Click the 'Home' tab on the command Ribbon.
4. Click the Dialog Box Launcher in the lower right corner of the 'Number' group. The dialog box opens.
5. Click the 'Number' tab. A list of categories displays.
6. Click 'Date.' A list of date formats displays in the 'Type' box. Examples include March 14, 2001 and 14-Mar-01.
7. Click the date format.
8. Click the down-arrow for the 'Locale (Location).' A menu includes 'English (United States),' for example. The formatted date can translate into other languages.
9. Click the preferred language.
10. Click 'OK.' The dates convert to a different format in the selected cells.

Read more ►

How to Make Clustered Histograms on Excel

1. Open your Microsoft Excel worksheet that contains the data for your chart. Label a new column as Bin Range, and type the groups of values that you want to use as your horizontal axis. For example, if you're counting the frequency of test scores, type '
2. Label a new column 'Frequency1' to the right of your Bin Range column. Count the number of occurrences for each of your groups of your first data set and type them into the 'Frequency1' column. Repeat the process for your second data set and label the column 'Frequency2'.
3. Highlight your 'Frequency1' and 'Frequency2' columns and click the 'Insert' tab on the Ribbon at the top of the page. Click the 'Column' drop-down box and select the style that you want to display on your chart. Click the 'Select Data' button on the Design tab of the ribbon, click 'Edit' under Horizontal Axis Labels and highlight your Bin Range values in the Axis Label Range text box.
4. Customize your chart with the tools in the Design, Layout and Format tabs of the Ribbon. Add chart titles, axis titles and data labels from the Labels area of the Layout tab. Change the color scheme from the Design tab and customize the shape styles and colors from the Format tab.

Read more ►

How to Change Interval of Value Axis in an Excel Chart

1. Start Microsoft Excel 2007 and open a spreadsheet that contains a chart to which you would like to change the interval of the value axis.
2. Select the entire chart by clicking in the white area of the chart. You will then see a light blue outline around the chart indicating you have selected the entire chart.
3. Choose the 'Format' tab at the top of the Excel screen and location the 'Current Selection' group. The 'Current Selection' group is the first group that appears on the 'Format' ribbon.
4. Click the 'Chart Elements' drop-down list and select '(Value) Axis' from the list. The 'Chart Elements' list is the top item in the 'Current Selection' group.
5. Click the 'Format Selection' button to open the 'Format Axis' dialog box. Click the 'Axis Options' option on the left side of the 'Format Axis' dialog box if necessary.
6. Change the minimum value, maximum value, major units and minor units by clicking the 'Fixed' radio buttons beside the options. This allows you to be able to type in the intervals you want to see in the text boxes to the right of the options.
7. Click the 'Close' button to close the 'Format Axis' dialog box and return to your Excel chart. You will notice that the interval of the value axis has changed.

Read more ►

How to Convert Excel Formulas to Hard Numbers

1. Highlight the cell(s) with that contain formulas you wish to convert to hard numbers.
2. Right click your mouse and select 'Copy'.
3. Right click again and select 'Paste Special'.
4. Select the 'Values' option in the Paste section of the Paste Special box.
5. Click 'OK.'
6. Hit the Enter key. The cell(s) selected will now display numbers rather than formulas.

Read more ►

How to Use the '' Symbol in the Header in Excel 2007

1. Open an Excel 2007 document and click the 'Insert' menu.
2. Click 'Header and Footer.'
3. Type the text you want to include in the 'Header' box. When typing the symbol, type '' two times. Microsoft Excel will now recognize one of those ampersands and include it in the header.

Read more ►

How to Create an Excel Macro for a Frequently Used Formula

1.
You will need to have the Developer tab displaying. If it is not displaying, click on the Microsoft Office Button (upper left corner red, blue, yellow, green logo). Click on the Excel Options button, and then under the Popular category, click to fill the box next to 'Show Developer tab in the Ribbon.' Click OK to exit. You will need to adjust the security level to run macros, so on the Developer tab, in the Code group, click on Macro Security. Fill the box next to 'Enable all macros (not recommended, potentially dangerous code can run).' Click OK. It is fine to run your own macros.
2.
This demonstration is to insert a formula into cell C2 that will extract the last word in cell A2, but any formula can be saved. In this case, the formula is long, making it a great candidate for a macro. The easiest way to create a macro for a formula is to open a workbook that currently contains the formula, or open a new workbook and input the formula. CUT THE FORMULA FROM THE CELL BY HIGHLIGHTING THE FORMULA AND PRESSING CRTL-X BEFORE YOU START CREATING THE MACRO. Click in any cell, and to start creating the macro, click Record Macro in the Excel Developer tab. The Record Macro dialog box will appear.
3.
Enter a name for the macro. If you use more than one word, separate the words with an underscore ( _ ). Next is the Shortcut key that you will use to later run the macro. The Ctrl key is shown by default as the first key, followed by a box into which you enter one letter. (If you choose a letter that is already assigned to a built-in macro, Shift will automatically appear after Ctrl .) Beneath the shortcut key, you are asked where to store the macro. To be able to use the macro in other workbooks, choose 'Personal Macro Workbook.' Lastly on the Record Macro is the option to enter a Description. When you have filled the boxes on the Record Macro dialog box, click OK. This process creates a file name for the macro.
4.
Next, you need to 'record' the steps that you want saved in the macro. These are the keystrokes or mouse clicks that you want to repeat at another location in the current, new, or saved Excel workbook. To record the macro, click on Record Macro on the Developer tab. After you click Record Macro, it will read Stop Recording, so any keystrokes or mouse clicks you make will be recorded. Click the cell into which you want the formula to appear, in this case, C2, and then press Ctrl-V to paste the formula in cell C2. Click Stop Recording in the toolbar. Your macro has been created.
5.
To use the macro, from any workbook, use your shortcut key selection, which would be Ctrl plus the letter you assigned to the macro. You can see from Step 3 that our macro shortcut key is Ctrl m. If you do not recall the shortcut keys, click on Macros on the Developer tab and the Macro dialog box will appear. Click on the macro name. Notice that if you included a description when creating the macro, the description will appear at the bottom of the Macro dialog box. With the desired macro highlighted, click the Run button and the formula will enter into, in this case, cell C2.

Read more ►