How to Remove Filters in Excel 2003

1. Open Excel 2003 and select a workbook with data. Click 'File' on the menu bar. Click 'Open.' Search your files and locate the workbook. Double-click the workbook. The workbook opens.
2. Click the column header in the first column of your data. Select 'Data' on the menu bar and select 'Filter.' Click 'AutoFilter.' Drop-down lists appear in the column headers of your data. Click one of the drop-down lists and select a value. Notice your data is immediately filtered by this value.
3. Remove the filter by clicking 'Data' on the menu bar and selecting 'Filter.' Select 'AutoFilter.' The filter is removed from your data.

Read more ►

How to Change an Excel Chart to Ascending Order

1. Click on the column heading. This is Column A, B, C, etc, in a basic worksheet or the Table in a PivotTable report. Again, you must change the chart data in order to change the chart. Chart data can originate from a basic or PivotTable form.
2. Click the arrow Filter drop-down on Column heading or Column Labels. Again, a column label is the Column heading in a PivotTable.
3. Click the arrow Filter drop-down. In PivotTables, the Axis Fields are categories and the Legend Fields are Series.
4. Change the Excel Chart data to Ascending order by clicking 'Sort A to Z' for text, 'Sort Smallest to Largest' for numbers and 'Sort Oldest to Newest' for dates and times.

Read more ►

How to Use Negative Numbers to Calculate in Excel

Calculating Negative Numbers
1. Enter a negative number into an Excel spreadsheet cell by using the minus sign (-) before the number.'-12' is an example of a negative number.
2. Use the arithmetic operator, the minus sign (-), to subtract a number using a formula.An example is the formula, '=25-10' that will give a result of '15.'
3. Use a function to calculate negative and positive numbers.An example of this is '=sum(a1:a3)', where cell a1=10, cell a2=12 and cell a3=-25 will give a result of '-3.'
4. Use a function to transform a positive result into a negative result by applying the negative sign (-) to the function. An example of this is '=-sum(a1:a3)' using the established values for those cells will give a result of '3.'
Change Negative Number Formats
5. Select a number or range of numbers to change the way Excel displays these numbers.
6. Click the 'Home' tab on the top menu and select the arrow in the 'Number' section.
7. Choose either the 'Number' or the 'Currency' category in the 'Category:' list in the 'Format Cells' window.
8. Select the number of decimal places by either typing it in or selecting the up or down arrow in the 'Format Cells' window.
9. Choose the 'Use 1000 Separator (,)' check box. Skip this if you are formatting currency.
10. Choose the currency symbol by clicking the down arrow in the box next to 'Symbol.' Skip this if you are not formatting currency.
11. Select the number format in the 'Negative numbers:' box in the 'Format Cells' window.
12. Click the 'OK' button.

Read more ►

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.

Read more ►

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.

Read more ►

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 ►