How to Compute Annual Gross Pay in Excel

1. Open a new Microsoft Excel 2010 spreadsheet.
2. Click in cell 'A1.' Type in the name of the first company from which you received money for the year in question. Press 'Enter' to move to the cell directly beneath this cell.
3. Enter your yearly gross pay for this company, if you know it, or your bi-weekly gross pay if you don't. Ensure that you are entering your gross pay, which is the amount before any taxes are taken out, and not your net pay, which is what you actually take home. Press 'Enter' to move to the next cell underneath this one.
4. Enter the following formula, without quotes: '=(A2/14)*365' if you entered your bi-weekly gross pay in the previous cell. Change '365' to '366' if you are calculating for a leap year. If you entered your yearly pay into the cell, just enter in '=A2.'
5. Click in cell 'B1' and repeat the process for the next source of income. Continue until you have each source of income in its own column.
6. Click in cell 'A4.' Enter the following formula, without quotes: '=sum(3:3).' When you press 'Enter,' the number that appears will be your total gross pay for the year.

Read more ►

How to Format Equations in Multiple Cells in MS Excel

Simple Equations
1. Launch Microsoft Excel 2010.
2. Click 'File' and 'Save As.' Navigate to a saved document location if necessary and type a name for the new spreadsheet into the 'File Name' box. Click 'Save' to save the new spreadsheet.
3. Click in the cell that is going to contain the results of the equation.
4. Press the 'Equal' sign ('=') on the keyboard to begin creating the formula for the equation.
5. Click on the first cell that contains data for the equation. Press the 'Plus' key (' ') on the keyboard to begin an addition formula with the current cell as the first item to be added. Alternately use a different operator, such as the 'Minus' sign ('-'), 'Asterisk' key ('*') or the 'Slash' key ('/') to subtract, multiply or divide, respectively.
6. Click on the next cell in the equation and press 'Enter' if the equation ends with this cell or press another mathematical operator and click on an additional cell to continue the formula. Repeat as necessary until the formula is complete.
Complex Formulas
7. Launch Excel 2010 and open every workbook that contains information that will be used in the complex formula.
8. Click the cell where the answer to the complex formula will be displayed.
9. Click 'Insert Function' from the 'Formulas' tab on the toolbar.
10. Type the name of the function or operation into the 'Search for a Function' dialog box and click 'Go' or select a category of function from the pull-down menu to see a list of functions. Click on the function name and click 'OK' to launch the function wizard.
11. Click in the first box in the 'Function Arguments' box and then click once on the cell that contains the information requested by the dialog box. Repeat for each requested input and click 'OK' to create the formula. Click 'Help on This Function' for a more detailed explanation of the function and what is needed to complete it properly.

Read more ►

How to Do Standard Error Bars on Excel Charts

1. Open a new workbook in Microsoft Excel. Enter data points in cells down two columns. For example, if we want to plot the number of students that earned a certain average exam grade, we would list the number of students down column A and the average grade in column B.
2. Highlight the data in both columns. Go to the 'Insert' tab and choose a chart type. For example, we can choose a scatter chart to plot the data.
3. Click on a data point to select all of the data points in the chart, or click twice on a data point to only select that data point. You can have standard error bars for one data point or all of the data points.
4. Go to the 'Layout' tab under Chart Tools and click on 'Error Bars.' Select 'Error Bars with Standard Error.'
5. Click on the 'Error Bars' menu and select 'More Error Bar Options.' You can change the direction of the error bars, the end style, and the error amount. The line color, style and shadow can also be customized.

Read more ►

How to Create an Excel Spreadsheet Online to Share

1. Collect the email addresses of those individuals with whom you will share the information. You will be able to link them and notify them of any changes via their email address.
2. Create the Excel spreadsheet you intend to share if you have the information handy. Otherwise, you can create your spreadsheet in any one of the office suite programs.
3. Create an account, if necessary, to access any one of the above office suite programs. If you already have a Windows Live or Google account, then you will sign into either program using that account. With Zoho Sheet, you can sign in using your Google, Yahoo or Facebook account. While Microsoft Office Live and Google Docs offer valuable preloaded templates (whereas Zoho Sheet requires you to find or create your own templates), using Microsoft Live does require that you download a plug-in. This makes it an excellent option for home or office use, but with a shared computer such as in a computer lab or library, it may not be a viable option for you, since many of these facilities don’t allow software to be installed by public users.
4. Upload an existing spreadsheet or create a new spreadsheet as you would in Microsoft Excel, as the user interface on all three programs is nearly identical. Then save the spreadsheet. To share it, you will need to title and save the document.
5. Share the document by entering the email addresses of those you wish to view or manipulate the document. As you select a user, you can designate their privilege, such as to 'read only' or 'edit.' With Google Docs, you also have the ability to assign additional editors who will then have the added permissions to invite others. Once you’ve given an email address, the recipient will receive an email and her designated privilege and she can begin accessing or editing the shared documents.

Read more ►

How to Change the Default Email in Excel 2003

1. Start Internet Explorer by double-clicking on the icon on the desktop or by clicking 'Start' and choosing the 'Internet Explorer' icon on the Start menu.
2. Select the 'Tools' menu option, and then click on 'Internet Options.'
3. Click on the 'Programs' tab on the 'Internet Options' dialog box.
4. Click on your desired email program from the 'Email' combo box.
5. Click 'Apply' and then 'OK' to save changes. Now you can use your desired email program as your default email for Excel 2003.

Read more ►

How to Unlock the Secrets of Microsoft Excel 2007 Macros

1. Open the Excel workbook that needs a new macro. Click the 'Microsoft Office' button at the top-left end of the window. Scroll to the bottom of the menu and click 'Excel Options.'
2. Navigate to the 'Popular' tab and click the 'Show Developer Tab in the Ribbon' box underneath the 'Top Options' heading. Choose 'OK.'
3. Click the 'Developer' tab at the top of the workbook. Click the 'Macro Security' button in the 'Code' heading.
4. Choose 'Enable all macros (not recommended, potentially dangerous code can run)' if you want all macros to be able to run automatically. Choose 'Disable all macros except digitally signed macros' if you only want macros from trusted sources to be able to run.
5. Select the 'Record Macro' icon in the 'Code' heading when you are ready to record your new macro. Type a name to identify the new macro in the text box and click 'OK.'
6. Perform whatever functions needs to be repeated by the macro, such as deleting or adding rows, changing font or background colors, centering text or summing together the values of cells. Click the 'Stop Recording' icon in the 'Code' heading to finish recording the new macro.
7. Click the 'Macros' button in the 'Code' heading. Click the name of the macro you created. Choose 'Run' to run the macro and perform the recorded operations or 'Delete' to delete the selected macro.

Read more ►

How to Delete Blank Pages in Excel

1. Click on the tab of the worksheet that you want to delete to select that sheet. The worksheet tabs are located at the bottom of the Excel workbook.
2. Click the 'Home' tab in the upper-left corner of the Office ribbon.
3. Click the drop-down menu next to the 'Delete' button in the 'Cells' section of the ribbon bar.
4. Select 'Delete Sheet' in the drop-down menu.

Read more ►

How to Set Up a Memo Format

1. Create a memo using Microsoft Word 2010 by selecting from several template designs. Click 'File,' 'New.' Select 'Memos' under Office.com Templates, and double-click on the memo style you want to use. You can edit the format, if necessary, and add information to it.
2. Create a memo using Microsoft Excel 2010. Click 'File,' 'New.' Select 'Memos' under Office.com Templates. Double-click on the memo style you want to use. Edit the memo format by deleting rows and columns or renaming the headings for the table.
3. An email may also serve as a memo and there is less formatting involved. Many fields correspond to the headings on a memo, including 'To,' 'From,' 'Date' and 'Subject.' The email message field contains the memo's body content.

Read more ►

How to Use Autofill in Excel 2007

1. Position the cursor in the first cell of the series and type in the data. For our example using days of the week, type 'Monday' into the first cell and press 'Enter' on your keyboard.
2. Click on the cell and move your mouse so that the pointer is positioned over the small black box in the lower right corner of the cell. The pointer will change from a white cross to a black cross when you have it positioned correctly.
3. Use your mouse to drag the black cross, known as the AutoFill handle, across the range of cells which you wish to fill with the rest of the series.
4. Release your mouse button and AutoFill will complete the rest of the data entry in the series. In our example, if you were to drag the AutoFill handle across 6 more cells, it would fill in the days of the week - Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday.
5. Make your own custom AutoFill series by clicking the Office button, clicking on 'Excel Options,' and then selecting the 'Popular' tab. Click on the 'Edit Custom Lists' button, then 'Add.' Type your custom list into the 'List Entries' text box. Click 'OK' twice to finish.

Read more ►

How to Change the Author of an Excel Spreadsheet

1. Open the Excel document that you want to change the author.
2. Click on the 'File' tab in the top-left corner of the Excel window. Then select 'Info' from the list of options on the left side of the 'File' screen.
3. Select 'Properties' on the right side of the 'Info' screen. Then select 'Show Document Panel' from the drop-down menu. You will automatically taken back to the 'Home' tab and your Excel worksheet will appear on the screen, with the document panel positioned just above it.
4. Select the text box next to 'Author.' Delete the data in that box and enter your desired author name. Click the 'X' in the upper-right corner of the document panel to close it.

Read more ►

How to Make a Multiple Baseline Graph in Excel

1. Type in your data into an Excel worksheet in which each column represents a separate baseline condition.
2. Label the first row of each column with the condition name.
3. Highlight the data you wish to include in the graph. Click on the 'Chart Wizard' icon in the toolbar and select the standard line graph. Press 'Next'.
4. Click on the vertical axis , then select the 'Scale' tab to change the scaling on the y axis so that vertical axis hangs over the horizontal axis.
5. Input the same minimum value for the 'x' and 'y' axes. Click 'OK.'
6. Draw phase changes using the line tool in the toolbar. Add text boxes as well to label each condition.
7. Click on one of the axes and modify the font size to make room for your additional baseline graphs.
8. Input the data for the second graph on the same data sheet you used for your first graph.
9. Highlight only the data you would like to include in the second graph.
10. Open the chart wizard. Save the new graph as an object in your first graph.
11. Repeat steps 1 through 6.

Read more ►

How to Combine Columns of Data in MS Excel

Combining Values Through Arithmetic
1. Launch Excel on your computer and open the spreadsheet for which you want to combine columns of data through arithmetic.
2. Click on the first row of an empty column and type the following formula into the cell:=$A1 $B1.Replace 'A' with the column holding the first value to be combined and 'B' with the column holding the second value to be combined. Replace the ' ' (sum) operator with whatever Excel operator you need to compute the combination.
3. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.
4. Press 'Ctrl-V' to paste the formula into all selected cells. Excel will compute the remaining entries of the column. The entries in the corresponding rows of pre-existing columns are combined.
Concatenating Cell Values
5. Launch Excel on your computer and open the spreadsheet for which you want to concatenate columns of data.
6. Click on the first row of an empty column and type the following formula into the cell:=$A1$B1.Replace 'A' with the column holding the first value to be combined and 'B' with the column holding the second value to be combined.
7. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.
8. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display the cells in a darker shade to indicate that they are selected.

Read more ►

How to Enable Macros in Excel 2003

The XLStart Folder
1. Open the folder that contains the workbook file with the macros you want to enable.
2. Right-click on that file and click \'Cut\' from the drop-down menu that appears.
3. Open the folder \'C:\\Documents and Settings\\[User Name]\\Application Data\\Microsoft\\Excel.\' Note: in this example, \'[User Name]\' is a generic placeholder for your actual user name on your computer. So, if you're logged on as \'JohnSmith\', the folder you would open is \'C:\\Documents and Settings\\JohnSmith\\Application Data\\Microsoft\\Excel.\'
4. Look for a folder titled \'XLStart.\' If you can't find that folder here, search for it in \'C:\\Program Files\\Microsoft Office\\Office11.\'
5. Open the XLStart folder. Right-click on the folder's window and click \'Paste\' from the drop-down menu. This will cause the workbook file from Step 2 to move into this folder.
6. Run Excel 2003. This will cause the workbook file you moved in Step 5 to automatically open. Its macros are now enabled.
Adjusting Security Settings
7. Run Excel 2003 and open the workbook file.
8. Click on \'Tools\' in the main toolbar, causing a drop-down menu to appear.
9. Select \'Macros\' from this menu and then click \'Security.\' This will cause a new window to appear.
10. Click on the \'Trusted Publishers\' tab in the window and check the box next to \'Trust all installed add-ins and templates.\'
11. Click \'OK.\' The macros within your workbook file are now enabled.

Read more ►

How to Apply Shading to the Whole Page

Apply Shading to a Word Document
1. Open the Word document.
2. Click the 'Page Layout' tab on the command ribbon.
3. Click the 'Page Color' button in the 'Page Background' group. A gallery of color samples appears.
4. Hover over a color sample to preview the effect on the document.
5. Click the color sample. The page color converts to the selected color.
Apply Shading to an Excel Worksheet
6. Open the Excel workbook.
7. Click the 'Select All' button in the upper left corner of the worksheet. The rectangular 'Select All' button displays a triangle adjacent to the 'A' and '1' headers. This button selects and highlights the whole worksheet.
8. Click the 'Home' tab on the command ribbon.
9. Click the arrow next to the 'Fill Color' button in the 'Font' group. This button displays a paint can tipped at an angle. A gallery of color samples appears.
10. Point over a color sample to preview the effect on the worksheet.
11. Click the preferred color sample. The worksheet converts to the selected color when you click in the worksheet.

Read more ►

How to Use Autofit in Excel

Autofit a Single Column in Excel
1. Start Microsoft Excel and open up an existing spreadsheet that contains one column that you would like to apply autofit to. You can also start a new spreadsheet so you can practice using Excel's autofit.
2. Position your mouse over the right border of the column that you would like to autofit the contents. Your mouse pointer will change into a double-headed arrow when you are directly over the border.
3. Double-click with your mouse on top of the border, only when you see the double-headed arrow.
4. Notice that your longest entry will now fit within the column in which you have applied the autofit setting.
Autofit Multiple Columns in Excel
5. Open Microsoft Excel. Start a new spreadsheet or open an existing one that contains multiple columns that you would like to apply autofit to so the contents will fit inside of the columns without being cut off.
6. Press the CTRL key down on your keyboard. Hold it down.
7. Click on the columns which you want to apply autofit.
8. Release the CTRL button. The columns that you selected will now be highlighted.
9. Hover your mouse over the right border of the first column you have selected until you see a double-headed arrow.
10. Double-click with your mouse on top of the border. Once you do this, all of the columns you have selected will now apply autofit to their contents.

Read more ►