How to Change the Case in Excel 2007

1. Open Excel 2007 and select a workbook that contains data that needs the case changed. Click the 'Office' button and select 'Open.' Browse your computer and locate the workbook. Click the workbook and select 'Open.'
2. Insert a column near the data. Click on the first cell in the column. Click on the 'Formulas' tab in the ribbon. Select the 'Text' option. Click 'Proper.' The Function Arguments window opens. Click on the red box in this window. Highlight the first cell that needs the case changed. The cell reference appears in the Function Arguments window. Click 'OK.'
3. Review the results of the Proper function. The case of the data has been changed to proper case. The first letter of each word is now capitalized.

Read more ►

How to Copy a Pivot Table to Another Worksheet

Copy the Worksheet
1. Click on the worksheet that contains the Pivot Table. You can do this easily by clicking the appropriate worksheet tab that appears at the bottom of the Excel window.
2. Right-click the worksheet tab again. A pop-up menu will appear. Choose the 'Move or Copy' option. Another pop-up menu appears.
3. Click the 'Create a copy' check box. Then click once on the existing worksheet in the menu list before which you wish to place the copy of the Pivot Table.
4. Press the 'OK' button. Excel copies the Pivot Table to another worksheet and places the copy in the specified worksheet location.
Copy the Pivot Table
5. Click on the worksheet that contains the Pivot Table you wish to copy.
6. Click once on an empty cell in the upper left of the Pivot Table, just above the Pivot Table data.
7. Drag the mouse down and to the right until you reach an empty cell on the lower right of the Pivot Table.
8. Right-click on the selected Pivot Table cells and choose the 'Copy' option. Alternately, press the 'Ctrl' and 'C' keys on your keyboard to copy the information.
9. Click in the worksheet where you wish to place the copied Pivot Table. Press the 'Ctrl' and 'V' keys, or right-click and choose the 'Paste' command.

Read more ►

How to Print Selected Areas of an Excel Worksheet

1. Start Microsoft Excel and open the file you want to change.
2. Drag to highlight the cells you want to print.
3. Open the File menu and select Print.
4. In the 'Print what' box, click Selection.
5. Select OK to print your selection.

Read more ►

Excel Tutorial on Statistics

1. Decide what statistical function or test you need to perform. For example, you might be trying to find an average, or mean, of several numbers, or you may want to find the slope for a graph that you've already plotted in Excel.
2. Click on the cell where you want to insert the statistical function.
3. Find the function name in Excel. Click on the 'Formulas' tab in Excel 2007 or Excel 2010, then click on 'More Functions.' Mouse over 'Statistical,' then click on the function you need. Most functions are named so that you can easily find what you are looking for. For example, AVERAGE finds the average of a range of numbers and MAX finds the maximum value in a range of numbers. If you are unsure about a particular function, mouse over the function name to find out more about the function or press the 'F1' key to bring up the help window for formulas and functions.
4. Fill out the information requested in the pop up window. The information will depend on which of the dozens of functions you have chosen. In general, you can expect to at least have to choose a range of cells to perform the function on. For example, if you want to find the average of a set of numbers in cells A1 to A10, then you'll need to enter 'A1:A10' as the range in the pop up window.
5. Press the 'OK' button. Excel will perform the requested function and return the result in the requested cell.

Read more ►

How to Create an Excel XLA Add

1. Launch the Microsoft Excel software. Click 'File' in the top navigational bar and select 'New' from the drop-down menu. A Workbook Options window will be displayed. Press 'Blank Workbook.' Excel will create a new workbook.
2. Select 'File' in the top menu again. Select 'Properties' from the drop-down menu. Look in the Document/Name Properties box and press the tab labeled 'Summary.' Name the new workbook. This name will be what is shown in the add-ins window after you are finished.
3. Click 'Tools' in the top menu bar and select 'Macro'; then click 'Visual Basic Editor.' The editor will appear on the screen.
4. Click 'Insert' in the top menu bar and click 'Module' from the drop-down menu. A code module box will be displayed. Enter in the function code with which you want the Excel add-in to work. For example, you may type 'Function' followed by a space, then 'Age(DoB As Date).' This add-in, if activated in an Excel worksheet, will convert any references to DoB to the numbers listed in the Date column. If you are unsure of how to structure a function code, browse the Microsoft Excel help site (see Resources).
5. Save the file. You may now add it to a current worksheet by selecting 'Tools' in the worksheet and choosing 'Add-Ins.' Navigate to the hard drive folder in which you saved the XLA file and click it; then press 'Open.'

Read more ►

How to Use an Access Pivot Table

1. Click 'Start,' 'All Programs,' 'Microsoft Office' and then select 'Microsoft Access 2010.'
2. Click 'File' and then 'Open' and browse to the Microsoft Access database you want to analyze.
3. Click 'View' and then select 'PivotTable View' and this displays the 'PivotTable Field List.'
4. Select a numerical field from the 'PivotTable Field List,' then drag and drop this field in the 'Drop Totals or Detail Fields Here' section of the pivot table view. For example, if you want to know how many orders you have in a store database, the order quantity field is the numerical field you select, since it represents the number of orders. A simple pivot table view is displayed showing the summarized list of the order quantities.
5. Select the field representing the store's product identifier from the 'PivotTable Field List,' then drag and drop it in the pivot table view section labeled 'Drop Row Fields Here.' Now the pivot table view is displayed listing the order quantities for each store product. The grouping of information by store product identifier makes the pivot table summary more meaningful for analysis.
6. Right-click the numerical field column name in the pivot table view and select 'AutoCalc' and then select 'Sum' and now you have a meaningful pivot table that summarizes the order quantity for every store product in your database.

Read more ►

How to Open QBB Files Without QuickBooks

1. Open either Quicken or Excel. Quicken is another financial program similar to QuickBooks while Excel is a spreadsheet program packaged in the Microsoft Office platform.
2. Select 'File,' 'Import,' then choose the QBB file you want to view.
3. Click 'OK' and wait for the software to convert the QuickBook document into its own format standard. Once complete, the financial information appears on your computer screen.

Read more ►

How to Learn Excel Spreadsheet

Free Excel Training from Microsoft
1. Download and install a free trial version of the Microsoft Office suite that includes Excel and several other useful programs in a limited time, fully functional trial version.
2. Click 'Start' at the Windows orb, 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.
3. Click 'File' and 'Help' to launch the interactive training series to learn basic and intermediate Excel functions and to find step-by-step guides to performing the most popular functions.
Basic Excel Functions
4. Click 'Start' at the Windows orb. Click 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.
5. Click once in the top left cell -- A1 -- and type in any number. Press 'Enter' to save the cell and move to the next cell down or press 'Tab' to save the cell and move to the next cell to the right. Alternately, type in any number and click another cell or use the arrow keys on the keyboard to save the cell contents and move to another cell.
6. Enter another number in a second cell. Press 'Enter' or otherwise save the cell contents by moving to another empty cell.
7. Press the '=' sign on the keyboard. Click the first cell with a number in it once with the mouse. Press the ' ' sign on the keyboard. Hold 'Shift' and press ' ' or press the ' ' key on the numeric keypad, if equipped, and then click once on the second cell with a number in it. Press 'Enter.' This creates a formula to add two cells together and display the results in a third cell.
8. Click in the first cell with a number and change the number. Press 'Enter' or otherwise save the cell contents by moving to another empty cell. Notice that the cell that displays the total updates automatically to reflect the new total. Formula cells update as new information is entered.

Read more ►

How to Create Invoices in Microsoft Word From Excel 2007

1. From a new blank workbook in Excel, click the 'Office' button and then the 'New' icon to display the 'New Workbook' dialog box. Under the 'Microsoft Office Online' section, choose 'Invoices' to view the invoice templates that are available for free download. Filter out customer-submitted templates, if desired, by clicking on the 'Hide customer submitted templates' icon at the top of the screen.
2. Preview the available templates by single-clicking on each one to view the template in the preview pane to the right. Click on the 'Download' button once you've selected the desired template. You will briefly see a status window until the file download is complete (downloading times are usually minimal, but will vary depending on the speed of your Internet connection). A new Excel window showing your template will pop up after the download has completed.
3. Select the cells containing data in this new worksheet, then right-click the selected data and choose 'Copy.'
4. With the Excel window still open, launch Microsoft Word. In the 'New Blank Document' screen, click the 'Paste' menu button in the 'Clipboard' group on the 'Home' tab. Choose 'Paste Special' to launch the 'Paste Special' dialog box.
5. Under the 'Paste As' section, choose the 'Microsoft Excel Binary Worksheet Object' option and then click 'OK.' Your invoice template will be pasted into Word as an Excel object. In order to enter your data into the template and temporarily alter the ribbon to show Excel commands, double-click the Excel object.

Read more ►

How to Sort a Row or Column in Excel

1. Start Microsoft Excel and open the file you want to change.
2. Drag over the two or more columns or rows that you want to sort.
3. Open the Data menu and select Sort. The Sort dialog box appears.
4. Select the Continue with the Current Selection option to sort a single column or row.
5. Select the Expand the Selection option to sort a series of columns or rows.
6. Choose Ascending or Descending to determine the sort order.
7. Click the Options button in the Sort dialog box.
8. Select 'Sort top to bottom' in the Sort Options dialog box to sort a column.
9. Select 'Sort left to right' in the Sort Options dialog box to sort a row.
10. Click OK in the Sort Options dialog box.
11. Click OK in the Sort dialog box.

Read more ►

How to Change the Pivot Table Default Settings in Excel 2007

1. Open your Microsoft Excel 2007 application on your computer. Click on any cell in the range you want to use for your pivot table.
2. Click on the 'Insert' tab and then click on the 'PivotTable' button from the Table group. Click on the 'Create PivotTable' button. The 'Create PivotTable' dialog box will then appear.
3. Change any defaults in the 'Create PivotTable' dialog box. For instance, you can click on the 'Use an external data source' option. Click on 'OK' once you've finished changing any of the default selections.
4. Continue to create your pivot table by clicking on any of the options in the 'PivotTable Field List' box. Click on the 'Update' button when you finish.
5. Change the display defaults by clicking on the 'Options' tab and then selecting the 'Options' button in the 'PivotTable' group. Click on the 'Layout and Forms' tab and then click on the 'For error values show' option.
6. Click on the box next to the 'For empty cells show' field. Click on the 'OK' button and the default display options will be changed.

Read more ►

How to Add a Spell

1. Click the 'View' drop-down menu and then the 'Toolbars' submenu. Make sure that the toolbar that will hold the spell-check button is visible by verifying that there is a check mark next to it or selecting it, if there is no check mark, to make it visible.
2. Click the 'Tools' drop-down menu and select 'Customize.'
3. Select the 'Commands' tab in the 'Customize' dialog box.
4. Select the 'Tools' category and scroll down until the 'Spelling' button is visible. The button will have the letters 'ABC' and a check mark on it.
5. Click and drag the 'Spelling' button from the Customize dialog box to the place on the toolbar where it will reside, and then release the mouse button. While the Customize dialog box is active, you can drag the button to a new location on the toolbar.
6. Click 'Close' to close the Customize dialog box.

Read more ►

How to Insert a Date in Microsoft Excel

Excel 2007
1. Right click on the cell and choose 'Format Cells.'
2. Click on the 'Number' tab.
3. Click on 'Date' in the 'Category' list box.
4. Choose the date format by clicking on one of the formats in the 'Type' box. For example, click on '3/14.'
5. Press 'OK.'
Excel 2003
6. Right click on the cell, the click on 'Format Cells.'
7. Left-click on the 'Number' tab.
8. Scroll to the 'Date' field and highlight it.
9. Scroll to the date format you'd like to use in the 'Type' box.
10. Click on 'OK.'

Read more ►

How to change the default font setting in Word 2003

1. Open Microsoft Word.
2. Right-click your mouse in the blank document. The Font dialog box will display.
3. Make any changes you want in this box. You can change the font, its style and size, as well as color and effects.
4. Click the 'Default' button in the lower left corner of the Font dialog box when you are done.
5. Click 'Yes' on the pop-up that appears. This will make your newly chosen settings the default for each future blank document.

Read more ►

How to Graph Two Lines in Excel 2007

Line Graph
1. Open the Excel file that contains the data you need to graph. To make two lines using a line graph, you will need two columns of numerical data. If you want the data to have labels, you should include a header in the cell at the top of each column.
2. Select the data that you want to include in the Line Graph. If your desired information is the only data in the two columns, you can simply click and hold the button on the letter above the first column, then move the mouse to the second column and release the button. If your data is not the only information in the column, click and hold on the top-left cell, then drag the mouse pointer to the bottom-right cell, and release it.
3. Select the 'Insert' tab at the top of the Excel 2007 window. Click the 'Line' button in the 'Charts' area and choose either the 'Line' or 'Line with Markers' option. Your two line graph will appear on the screen.
4. Right-click in the open space of the chart if you need to add custom labels to the x-axis. Choose 'Select Data' from the list of options. Press the 'Edit' button in the 'Horizontal Axis Labels' area. Select the labels from your spreadsheet, which will normally be located on a column just to the left of the data columns, and click 'OK'. Click 'OK' again and the labels will update.
Scatter Graph
5. Open the Excel file that hold your information. When using a scatter graph to make two lines, you will need to have data arranged in two sets of two columns. Select the first two columns that you want to use.
6. Select the 'Insert' button at the top of the window. Click the 'Scatter' button under the 'Charts' area. You will see five options. Choose any option other than 'Scatter with Only Markers' to create a graph that will include lines. You will see a graph appear on the spreadsheet that has one line.
7. Right-click on the graph and choose 'Select Data'. Click the 'Add' button under 'Legend Entries'. A small 'Edit Series' window will appear.
8. Type in a name for the series under 'Series Name'. This can be whatever you want. Click the box next to 'Series X Values' and choose the data from the first column of the second set. Once you have selected the data, click the box again to return to the 'Edit Series' box. Click the box next to the 'Series Y Values' and select the data from the final column. Click the box again, then click 'OK'. The graph will now show two lines on it.

Read more ►