1. Open Excel 2003 and select a workbook containing data that needs to be sorted. Click 'File' on the menu bar and select 'Open.' Browse your computer for the workbook. Click the workbook and select 'Open.' The workbook opens.2. Highlight the range of data that needs to be sorted. Click the first cell in the range you want to sort by. Click the 'Ascending' button on the Standard toolbar. The data is sorted in ascending order by the values in the column.3. Highlight the range of data you want to sort. Click 'Data' on the menu bar. Select 'Sort.' The 'Sort' dialog box opens. Select a column...
Browse » Home » All posts
Wednesday, August 15, 2012
How to Teach Yourself Microsoft Excel Virtually
1. Browse through Excel tutorials on the official Microsoft Excel website. Choose 'Getting Started With Excel 2010' if you are a total beginning, or 'Excel Skills Builder' to augment the skills you already have.2. Compare private databases of Excel tutorials. Examples include 'Excel-2010.com,' 'Excel 2010 Tutorials' and 'Lynda.com.' Although the accuracy of non-Microsoft materials isn't guaranteed, private websites often provide other users' personal experiences, which may help you work through difficulties better than straight instruction.3. Enroll in a formal online Excel 2010 training...
How to Control Multiple Users on One Excel Spreadsheet
1. Open the Excel spreadsheet you wish to share among multiple users.2. Click 'Tools' and select the 'Share Workbook' option. A pop-up window will appear.3. Place a check mark in the check box at the top of the 'Editing' tab on the Share Workbook pop-up window.4. Click the 'Advanced' tab at the top of the 'Share Workbook' pop-up window. The window will change to present a variety of customizations for controlling multiple users on the Excel spreadsheet.5. Choose desired options on the 'Advanced' tab. You may change the history log time frame and control how updates are handled.6. Click...
How to Create Mailing Labels in Microsoft Word
1. Open Microsoft Word 2010 and create a new document if one hasn't already been created. You can create a new document by clicking 'File' then 'New.'2. Click the 'Mailings' tab, then 'Labels.' The 'Envelopes and Labels' window will open.3. Type the address you wish to use on your labels in the address box. Choose if you want a whole sheet of the same label or just a single label printed in the 'Print' section.4. Click the 'Options...' button near the middle bottom section of the window to choose the labels to which you want to print. Under 'Label Information' select the brand of labels...
How to Make the Top Row Scroll in Excel
1. Open up to the worksheet in the Microsoft Excel workbook.2. Click the 'View' tab.3. Click the 'Freeze Panes' icon. Select 'Freeze Top Row' from the menu.4. Click the 'Windows Office' orb logo in the top left corner. Use the save options on the menu, if you want to make the top-row scroll permane...
How to Figure Percentage Using Excel
1. Click the 'Start' button on the taskbar, point to 'All Programs' and then click 'Microsoft Excel.'2. Click in an empty cell on the spreadsheet document in which you want the percentage value to be displayed (for example, B12).3. Type '=(total_value/number_of_values)*100' in cell B12 to get the percentage. Here, replace total_value with the total sum of the numbers whose percentage you want to calculate and number_of_values with the number of individual values. For example, to calculate the percentage of 12, 22, and 32, type '=(66/3)*100'. Here, 12 22 32=66 and there are 3 individual values...
Tuesday, August 14, 2012
How to Adjust Page Breaks in Excel 2007
1. Open the worksheet you want to print.2. Click 'View' then 'Page Break Preview.'3. Click on the page break and drag the break to the place you want the break to ...
Monday, August 13, 2012
How to Set Two Print Areas Using an Excel 2007 Worksheet
Printer Method1. Select your first desired print range by highlighting the cells within your worksheet; for example A1:H15.2. Hold down the 'Ctrl' key while highlighting the second set of cells to print--for example N5:V15--resulting in two separate highlighted areas.3. Select the 'Page Layout' tab, click on 'Print Area' and select 'Set Print Area.'4. Press 'Ctrl P,' a shortcut that brings up the Print Dialog Box.5. Verify the output printer displayed is the correct printer and click the 'Properties' button.6. Look through your different tabs and options for a setting asking you to...
How to Insert the Same Drop
1. Enter the list items in a column on the spreadsheet where you will not need to enter other data, such as on the far right or bottom of the page. Enter the items in the order you want them to appear in the list, one item per cell. Make sure there are no blank cells between the items.2. Select all of the cells into which you want to insert the drop-down list. If the cells are contiguous in one row or column, you can select them by clicking the first cell and dragging your mouse down or across the row or column. If they are in noncontiguous cells, press and hold the 'Ctrl' key while you click...
How to Center in a Row on Excel for Microsoft 2003
1. Select the row of text that you want to center by left clicking on the first cell and then dragging the cursor to the right.2. Right-click and then select 'Format Cells' from the pop-up window.3. Select the 'Alignment' tab.4. Click on the arrow next to the 'Horizontal' or 'Vertical' text alignment tab. If you want the text centered both horizontally and vertically, then choose both options.5. Click on 'Center Across Selection.'6. Click on 'O...
How to Create Free Receipts
1. Open a Microsoft Excel spreadsheet. Select 'New'. Select a free sales receipt template from the list of available spreadsheet templates.2. Fill in or delete the specified fields for company information, such as company name, address, company logo, and receipt number.3. Enter in the sales information for each item, which includes quantity, item number, item description, and the unit price.4. Enter a value in the discount cell if a discount applies and the discount is a flat number. If the discount is in the form or a percentage off, then enter '=xy*z' in the cell where x = the column...
Saturday, August 11, 2012
How to Convert Numbers Into Letters in MS Excel
1. Open your spreadsheet in Microsoft Excel.2. Click 'Tools' in the top menu bar, select 'Macro,' and choose the 'Visual Basic Editor' option. If you use Excel 2007 or later, click the 'Developer' tab and click the 'Visual Basic' button instead.3. Click 'Insert' in the top menu bar of the Visual Basic Editor and select 'Module.'4. Copy and paste all of the code shown below:Option ExplicitFunction SpellNumber(ByVal MyNumber)Dim Dollars, Cents, TempDim DecimalPlace, CountReDim Place(9) As StringPlace(2) = ' Thousand 'Place(3) = ' Million 'Place(4) = ' Billion 'Place(5) = ' Trillion 'MyNumber...
How to Make a Frequency Chart
1. Create a dataset of student grades; include student names and the grades 50, 60, 70, 80, 90 and 100. Enter or sort the grades in ascending order.2. Create a bin range of 50, 60, 70, 80, 90 and 100 and enter or sort it in ascending order.3. Go to 'Data Analysis.' In older versions of Excel, go to 'Tools,' 'Data Analysis.'4. Click on 'Histogram,' then click 'OK.' A frequency chart is also considered a Histogram.5. Select the 'Input Range' of the histogram. Click on the box beside the field.6. Highlight the 'Input Range' which is the 'Grade' column. Click on the box again to return...
How to Turn Off Calculations in Excel 2010
1. Open Microsoft Excel and click 'Formulas' in the Ribbon at the top of the Excel window.2. Click 'Calculation Options' on the far right side.3. Select 'Manual' to disable auto-calculation. If you want Excel to recalculate your spreadsheet while auto-calculation is disabled, you will need to click 'Calculate Now,' also located under 'Calculation Options.' When you are ready, you can re-enable auto-calculati...
How to Do a Scattergraph in Excel 2003
1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'2. Click 'File,' then 'Open.' Locate the Excel document that contains the data in it which you wish to make a scatter chart from.3. Highlight the cells that contain the data.4. Click 'Insert,' then 'Chart' to launch the Insert Chart wizard.5. Select 'XY (Scatter)' foam the list of options then click 'Next.' You can 'Press and Hold to View Sample' to see what the graph will look like. Click 'Next' then name the axes and the chart. Click 'Finish' when you have finished creating the gra...
Subscribe to:
Posts (Atom)