Excel

Browse » Home » All posts

Sunday, September 25, 2011

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.

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.

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.

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.

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.

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.

Saturday, September 24, 2011

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.

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.

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.”

Friday, September 23, 2011

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.

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.

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.

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.

Thursday, September 22, 2011

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.

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.

Subscribe to: Posts (Atom)