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 ►

How to Remove 0 From a Chart in Excel

1. Open the Excel spreadsheet file that contains the chart with the zero value.
2. Double-click the '0' to select it.
3. Press 'Delete' to remove the zero from your chart.

Read more ►

How to Convert a Microsoft Excel File to a PDF File

Converting Excel Worksheet to PDF
1. Go to Excel 2007 and open the spreadsheet you want to convert.
2. Select the Microsoft Office Button, then click “Print” and “Publish as PDF or XPS.”
3. Navigate to the folder where you want to save the file and name the PDF, then click “Publish.'
Converting a Selected Area to PDF
4. Open your file in Excel 2007. To convert a section of your document to a PDF, select the area and click the “Page Layout” tab.
5. Choose “Print Area” from the “Page Setup” group and click “Set Print Area.”
6. Select the Microsoft Office Button, then “Print” and “Publish as PDF or XPS.” Name your file and click “Publish.”

Read more ►

How to Use Microsoft Excel 2007 in a PowerPoint Presentation

1. Open your PowerPoint presentation and create a new slide where you want the Excel item to be by choosing 'Insert' from the menu at the top, followed by 'New Slide.'
2. Choose 'Insert' again from the menu at the top, then 'Chart,' and choose the type of chart you want (bar, line, etc.).
3. Insert your data for the chart into the Excel spreadsheet that opens up. You don't have to use the data that appears on the spreadsheet (it is just a suggestion). The headers for the chart will run along the top (Row 1) and left side (Column A).
4. Close the Excel window to save your information. Your data will be reflected on the chart.
5. Edit the chart formatting by clicking on the chart element you want to change and making the changes on the menu that appears. You can reformat the color, fonts and many other features.
6. Edit the data on the chart by clicking on the 'Edit in Excel' button on the formatting palette. If you do not see the formatting palette, click on the 'Toolbox' icon just above the presentation window.

Read more ►

How to Filter Using Keystrokes

Microsoft Excel
1. Open the saved Excel 2010 worksheet.
2. Click a cell in the column you wish to filter.
3. Press the “Alt” key to display the alphabetical labels over the command ribbon.
4. Press the “H” key to access the “Home” tab. Alphabetical labels display over the Home tab commands.
5. Press the “S” key to open the “Sort Filter” menu in the “Editing” group. The “Sort Filter” options are “Sort Oldest to Newest,” “Sort Newest to Oldest,” “Custom Sort” and Filter.”
6. Press the navigation arrow keys to select the row with the preferred “Sort Filter” option you wish to apply to the worksheet data. If you highlight “Filter” and press “Tab,” the column header displays an arrow. The filter is enabled, but requires you to click the drop-menu and click the menu option.
7. Press “Enter” to filter the data.
Microsoft Word
8. Open the Word 2010 document you wish to filter.
9. Press the “Alt” key to display the alphabetical labels over the command ribbon.
10. Press the “H” key to access the “Home” tab. Alphabetical labels display over the “Home” tab commands.
11. Press the “S” and “O” keys to open the “Sort Text” dialogue box.
12. Press the navigation arrow keys located on the right section of the keyboard to navigate the options in the screen’s dialogue box. Categories include 'Sort by,' 'Type,' and 'Ascending' and 'Descending.'
13. Press the “Tab” key to tab to the next category to the right. Continue pressing the navigation arrow keys to highlight the preferred option in each text box.
14. Press “Enter.” The Word document sorts.

Read more ►

How to Create a Data Entry Form for an Excel Spreadsheet

Restricting the Type of Data Entered
1. Select the cell or range of cells in which you want to restrict data entry.
2. Go to the Data tab in Excel 2007 and select 'Data Validation.' (In Excel 2003 or earlier, click on the 'Data' menu, and select 'Validation'). A dialog box will appear with three tabs: Input, Input Message and Error Message.
3. Select the Input tab if it isn't up already. Allowed Validation will show 'Any Value.' Clicking the drop-down list will show the options you can restrict the field to. The most useful kinds of restrictions include whole numbers (for quantities of goods sold or purchased), dates and times (when something was done) and text length (to make entering names easier). Select the input type that best suits your needs. The list type validation is covered in the next section.
4. Select the logical operators (greater than, less than, in between) that suit the data entry form you're building.
5. Click on the Input Message tab and enter the message you want displayed when the cell is selected. This can help your end users figure out the form more quickly.
6. Click in the Error Message tab and enter the message you want displayed when the data is entered incorrectly. Click the 'OK' button on the lower-right edge of the dialog box to finish.
Using a Drop-Down List on a Data Entry Form
7. Create a range of acceptable data values in another set of cells in Excel; for example, a list of branch locations.
8. Select the cell you want the drop-down list to be in.
9. Go to the Data tab in Excel 2007 and select 'Data Validation.' For earlier versions of Excel, click on the 'Data' menu and select 'Validation.' This will bring up the Data Validation dialog box.
10. Select 'List' from the drop-down menu. The field for Source will become available.
11. Click on the 'Source' box. Then select the range of cells you created. Click the 'OK' button at the lower edge of the dialog box to finish.

Read more ►

How to Change the Field Properties to Default Values in Excel 2007

1. Click the MS Office Button in Excel 2007, and scroll down to 'Prepare' and then select 'Properties'.
2. Type in the new values and information you want into the property field boxes under the Document Information Panel. You can choose to change the default title, subject, keywords, category, status, and change the default comments.
3. Click the 'X' on the right of the Document Information Panel to close the properties box and return to your Excel spreadsheet.

Read more ►

How to Change the Default Comment in MS Excel

1.
To change the username, select 'Tools' from the main menu (generally found across the top of the Excel worksheet). Select 'Options' from the drop-down menu that opens. A pop-up window opens; select the 'General' tab. In the box labeled 'User Name,' type in the desired name. This is the name to which all comments on this workbook will be attributed.
2.
Use the 'Format Comment' pop-up window to change the other parameters of the text box . Right-click on the cell that contains the comment. A drop-down menu opens; select 'Show/Hide Comment.' Place your cursor over the edge of the comment box and right-click. Select 'Format Comment' from the drop-down menu that opens.
3.
To change the comment text font, navigate to the 'Format Comment' pop-up window as described in Step 2. Select the 'Font' tab. Make desired changes to the font, font style, font size, font color and font effects. Click 'OK' to save the changes.
4.
To change the comment text alignment, navigate to the 'Format Comment' pop-up window. Select the 'Alignment' tab. Make the desired changes to the text alignment, the orientation of the text and the text direction. Click 'OK' to save the changes.
5.
To change the comment box lines and colors, select the 'Colors and Lines' tab in the 'Format Comment' pop-up window. Make desired changes to the fill (the color of the inside of the comment text box) and line (what type of border will be around the comment text box). Click 'OK.'
6.
To change the comment box size, select the 'Size' tab in the 'Format Comment' pop-up window. Make the desired changes to the height and width. Click 'OK' to save the changes.
7.
To change the protection of the comment box, select the 'Protection' tab in the 'Format Comment' pop-up window. Change the status of the comment from locked to unlocked, or from lock text to unlock text, by placing a check mark in the appropriate box. Click 'OK' to save the changes.
8.
To change the comment text box properties, select the 'Properties' tab in the 'Format Comment' pop-up window. You can use this tab to determine the positioning of the comment text box. 'Move with Cells' means that, if you copy and paste cells, the comment will be copied and pasted as well. 'Size with cells' means that, if you change the size of the cell (row height), the comment size will change as well. Click 'OK' to save the changes.
9.
To change the comment text box margins, select the 'Margins' tab in the 'Format Comment' pop-up window. Make the desired changes to the left, right, top and bottom margins of the comment text. This affects the comment and the user name to which the comment is attributed. Click 'OK' to save the changes.
10. To change the comment text box web functionality, select the 'Web' tab in the 'Format Comment' pop-up window. If you are linking this workbook and its comment to the web, you can insert alternative text that is viewable by users when the image of the workbook or comment is not available. Click 'OK' to save the changes.
11.

Read more ►

How to Do Line Graphs in Excel 2003

1. Open Microsoft Excel 2003 and create a new spreadsheet.
2. Type the names for each line in the first row. For example, if your data will contain information from months on the calendar, type 'January' in cell A1, 'February' into B1, and so on. Each column will correspond to one line on the graph.
3. Enter the data points for each column. Type the data for the 'January' line in column 'A' starting at 'A2,' for 'February' in column 'B' and continue until you have entered all of the data.
4. Click and drag over all of the data you entered to select it, including the label names in the first row. With the data highlighted, click on 'Insert' and select 'Chart.' This opens the Chart Wizard. In the 'Chart Type' list, select 'Line.' Select one of the 'Chart Sub-Types' from the images on the right. Click 'Next.'
5. Click on the 'Series' tab. Change the names for the labels if you want to and then click 'Next' to open the Chart Wizard's options.
6. Type a title for the graph in the 'Chart Title' field under the 'Titles' tab. Configure the options under the rest of the tabs as needed but you do not have to make anything different other than the default settings. Click 'Finish' to make your line graph.

Read more ►

How to Create Data Entry Forms

1. Click on the 'Forms' button on the left-hand of the screen. Use the Form Wizard for an automated guide through the data entry form creation.
2. Follow the Wizard instructions. When the Wizard asks you which fields you would like to use, either input the fields you would like or use the suggestions. For the purposes of this tutorial select 'All.' Use the double arrow (>>) to perform this action in one step.
3. Choose a layout. You can experiment with several different layouts within the Wizard to see which one is best suited for your needs. The most basic layout is Columnar. Choose 'Columnar' and select 'Next.'
4. Choose the style you would like your form to be in and the title. Select 'Standard' and title your form with a relevant name. For this example, use Client Contacts.
5. Choose 'Open the form to view or enter information.' This is the last screen. Select the 'Finish' button.
6. Add records by using the buttons at the bottom of the table. To customize the form go to Design View by clicking on 'View' at the upper left-hand side of the screen. Use controls like text boxes, labels, and combo boxes to provide the user with predefined information about the kind of data needed for input into the form. If you don't see the Toolbox, click on 'View' and select 'Toolbox.' When finished, the form will automatically save. See Resources for Access data entry form templates.

Read more ►

How to Copy an Excel Spreadsheet Into a Word Document

1. Click and hold the left, top cell in your Excel spreadsheet using your mouse and then move it down and right to select all cells you want to copy.
2. Open the Word document and click the 'Home' tab on top.
3. Click 'Paste' and select 'Paste Special.'
4. Select 'Excel Worksheet Object' from the 'As' list and check 'Paste link' in the 'Paste Special' window. Click 'OK.'

Read more ►