1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Office Excel.'2. Click cell 'A1,' type 'Expenses,' click cell 'B1' type 'Amount,' click cell 'D1,' type 'Income' and then click cell 'E1' and type 'Amount Earned.'3. Click cell 'A2,' type the name of a monthly expense (rent, car payment, food etc.) press the 'Enter' key, type the name of another expense and then continue in this manner until all expenses you plan to incur are listed in column A. Repeat this step, clicking on cell D2 and entering sources of income on each line instead of expenses (income from each...
Browse » Home » Archives for December 2012
Friday, December 28, 2012
How to Hide the Excel Pivot Table Data Area
1. Move the data you want to hide to the right. The easiest way to hide a large data field is to hide everything that lies on the right side of a selected column. Therefore, start by moving all the data you want to hide to the right. Click on 'Pivot Table Wizard' on the Pivot Table Toolbar. Now click on 'Layout.' Drag and drop the columns to arrange the data in such a way that all the data you wish to hide is to the right of the column(s) that will be visible and click 'OK.'2. Click on the first column from the left. Now go to the Pivot Table Toolbar and click on the icon that looks like a...
Thursday, December 27, 2012
How to Add a Custom Menu to an Excel Toolbar
Adding a Custom Menu to a Toolbar1. Open Microsoft Excel.2. Display the toolbar that contains the menu where you want to add your command.3. Open the Tools menu and select Customize.4. Select the Commands tab.5. In the Categories box, click New Menu.6. Drag New Menu from the Commands box to the desired location on toolbar.7. Right-click the new menu and select Name.8. Type a name for the menu in the Name box. Press Enter.9. Now add commands to the new menu, following the steps in the next section.Adding a Command to a Menu10. Open the Tools menu and select Customize.11. Select...
How to Convert Lotus 123 Files to Excel
From Lotus 1231. Open your file in Lotus 123.2. Go to the 'File' menu, select 'Save As,' and save it as a Microsoft 97 file (*.xls).3. Open the resulting .xls file in Excel.From Excel4. Open Excel.5. Locate the Lotus 123 file (with an extension of *.wk4 in most cases).6. Click 'Open.' Excel will prompt you for approval before converting the file.7. Go to the 'File' menu, and select 'Save As' to save a copy of the file as an Excel native form...
How to Create Diagonal Lines in a Cell in an Excel Spreadsheet
1. Open Microsoft Excel by double-clicking the Excel icon on your screen or selecting 'Programs' from the 'Start' menu and then selecting 'Microsoft Excel.'2. Select the cell you would like to place the diagonal line in by clicking on it once. The cell will be highlighted with a bold border around it to indicate that it has been selected.3. For Excel versions before 2007, move your cursor to the 'Format' pull-down menu and select the first item: 'Cells.' A pop-up box will appear named 'Format Cells.' Select the tab that says 'Border' within the box.4. For Excel 2007 or more recent versions,...
How to Make a Sales Order Form in Excel 2007
1. Open a new workbook in Microsoft Excel 2007. Click on the 'Office' button on the top left hand corner and select 'New.'2. Select the Microsoft Office Online under 'Templates' and type sales order in the search box. Hit 'Enter.'3. Select a template such as 'Sales order (Simple Blue design).' Click on the 'Download' button.4. Fill in information on the company name, slogan, date, invoice, customer ID, return address, and shipping address. In order to add the company logo, go to cell A1 and click on the 'Insert' tab in the toolbar. Click on 'Picture' and find the picture on your computer...
How to Insert Bullet Points Into Excel 2007
1. Select the cell or cells in which you want to insert bullet points. The cells can be empty, or they can have text already entered.2. Click the 'Format' button, which is found in the 'Cells' group under the 'Home' tab. Scroll to the bottom of the list that appears, and under 'Protection,' choose 'Format Cells.'3. Click 'Custom' under the 'Number' tab. If the selected cells are empty, the '@' symbol will appear in the 'Type' box. If there is already text in the cells, there will be text in the 'Type' box. Scroll down in the 'Type' menu until you see the '@' symbol, and select it; it will...
How to Use Excel Spreadsheet for Bills
1. Select cell 'A1,' located in the top-left corner of the Excel 2010 worksheet.2. Type 'Bill Type' into the the cell. This column will contain the name of the bill, like 'Rent' or 'Electricity.' Select the cell to the right of the first one and enter in 'Bill Amount.' Continue moving one cell to the right and enter in 'Bill Month,' 'Due Date,' 'Amount Paid' and 'Date Paid.' You can also add more fields if there is some other aspect of each bill that you want to track.3. Select cell A2. Enter in the bill type for the first bill you want to track. Then move to the cell directly to the right,...
How to Define Names Labels in Microsoft Excel 2003
1. Open the Microsoft Excel 2003 program and then click the 'Tools' option from the top toolbar menu.2. Click the 'Options' button and then click the 'Calculations' tab. Select the box next to the 'Accept labels in formulas' field, and then close out of the dialog box.3. Use your mouse to select a range of cells in your worksheet that you want to define names for.4. Click the 'Name' field from the left side of the formula bar. Enter the name you want for the group of cells.5. Press the 'Enter' key on your keyboard, and the names will be add...
Wednesday, December 26, 2012
How to Toggle a Grid in Excel 2007
1. Press down the 'Alt' key on your keyboard.2. Press the letter 'W,' then the letter 'V,' then the letter 'G.' Press them one at a time: don't try to press them all together at once. This keyboard action will make your gridlines disappear if you have them and will make them reappear if they are not showing.3. Repeat steps 1 and 2 to toggle the gridlines between showing and not showi...
How to Create Excel Spreadsheets in HTML
1. Click on 'File' in Excel 2003 or the 'Office' button in Excel 2007.2. Click on 'Save As Web Page' in Excel 2003. In Excel 2007, choose 'Other Formats,' then choose 'Web Page' from the 'Save as Type' box.3. Choose a save location from the 'Save In' list. For example, click on your Desktop.4. Type a name for your Web page in the in the 'File name' box.5. Click on 'Publish' twice. In Excel 2003, select the item you want to publish in the 'Choose' box (Excel 2007 does not require this extra step). Excel will save your workbook as an HTML Web pa...
How to Sort Information by Date in Excel 2003
1. Open Excel 2003 by double-clicking the icon. Click 'File,' then 'Open' and select the spreadsheet you want to work with.2. Click on the top left cell of the data you want to sort. Hold down the mouse button, and drag the cursor to the bottom right box, highlighting all of the data.3. Click the 'Data' button, then select 'Sort' from the drop-down menu that appears.4. Click the small arrow by the 'Sort By,' and select the column that holds all of the dates. Choose 'Ascending' if you want older dates to appear first or 'Descending' if you want the newest dates to appear first. Click 'OK,'...
Tuesday, December 25, 2012
How to Separate Cell Data in Excel
1. Start Microsoft Excel and open an existing workbook that contains cells with data you'd like to separate.2. Select the cells containing data you want to separate by clicking and dragging or using the SHIFT or CTRL keys on your keyboard.3. Click the 'Data' tab at the top of the screen to display the 'Data' ribbon.4. Select the 'Text to Columns' button to display the 'Convert Text to Columns Wizard' dialog box.5. Choose the 'Delimited' selection to separate the data by looking for commas or tabs or choose the 'Fixed width' selection to separate the data by looking for spaces. You will...
How to Resize Columns in a Microsoft Access Table
Resizing by Dragging1. Open your database file in Microsoft Access.2. Use the F11 key to open the Database window.3. Click on the Table tab, then click Open. A listing of tables appears.4. Select the table you want to modify, then click Open.5. Click in the label or title of the column that you want to resize.6. Move your cursor to the edge of the column. The cursor turns into a cross shape.7. When the cursor is a cross, grab the edge of the column and drag it to the width you want.Resizing From the Format Menu8. With your table open, click in the label or title of the column that...
How to Make a Histogram in Excel 2003
1. Open an Excel workbook. Click the Windows 'Start' button, click 'All programs,' click 'Microsoft Office' and then click 'Microsoft Office Excel 2003.' Alternatively, you can double-click the Excel shortcut icon on your computer's desktop.2. Click 'Tools' in the menu bar to open a drop-down menu, then click the 'Add-ins' option. You must first add this feature to Excel before a histogram can be created.3. Click the check box next to 'Analysis Toolpak' and click the 'OK' button in the Add-Ins window. This particular add-in will be loaded in to Excel.4. Click 'Tools' in the menu bar a...
How Do I Create a Histogram Using Continuous Data in Excel 2007?
1. Open the Microsoft Excel 2007 application on your computer. Enter the continuous data into the spreadsheet.2. Make sure to create one column with an input range of continuous data and another column with a bin range of data, which must be entered in ascending order.3. Click on the “Data” tab and then click on the “Data Analysis” option from the “Analysis” group. The Analysis Tools dialog box will then appear.4. Click on the “Histogram” option and then click on the “OK” option. Click on the “Collapse Dialog” button in the “Input Range” section and select the input range of data that...
Monday, December 24, 2012
How to Remove Trailing Commas in Excel
1. Open the worksheet that contains the data from which you want to remove trailing commas.2. Right-click the header of the column directly to the right of the data column that you want to clean. Click 'Insert' in the menu to insert a new function column.3. Type the following in the cell in the formula column adjacent to the first data cell:=IF(RIGHT(A1,1)=',',LEFT(A1,LEN(A1)-1),A1)Substitute the cell address of your first data cell in place of all instances of 'A1' in the above example.4. Press 'Enter.' Excel first determines whether the rightmost value in the data cell is a comma. If...
How to Change the Size of a Microsoft Office Drop
1. Open Microsoft Word by double-clicking the Word shortcut icon on your desktop or by clicking 'Start', pointing to 'Programs' or 'All Programs' and then finding Word in your programs list.2. Click 'Tools' on the toolbar and then click 'Customize'. The 'Customize' dialog box will open.3. Click on the 'Toolbars' tab. Make sure the name of the toolbar that contains the drop-down list you want to make wider or thinner has a checkmark beside it.4. Leave the 'Customize' dialog box open and click on the drop-down box that you want to resize. You will notice that it will now have a thick black...
How to Convert Excel 2007 to 2003
1. Open Excel 2007 if your computer has it. Click on the Windows icon at the top left-hand side of the screen and scroll to 'Open.' Click the command and browse your computer for the Excel 2007 file (it will have a file extension of '.xlsx'). Click on the file to select it, then click 'Open.'2. Let the file open. Click on the Windows Icon and scroll to 'Save As.' Click on 'Excel 97-2003 Workbook.'3. Name the file (the program will automatically name the file the same name as the 2007 version) in the space provided. Browse through your computer folders to find where you want to save it. Click...
How to Place a Picture in a Cell in Microsoft Excel 2007
1. Select the cell of the spreadsheet into which you want to insert a picture.2. Open the 'Insert' tab. This tab is located in between the 'Home' and 'Page Layout' tabs at the top left of the screen in the Ribbon, Office 2007's menu system.3. Press the 'Picture' button, located in the Illustrations section (second from the left).4. Navigate to the location of the picture you intend to insert and double-click the file to insert the picture into the selected cell of your Microsoft Excel docume...
Sunday, December 23, 2012
How to Create a Scrolling Section in an Excel Spreadsheet
1. Split the screen. To split the screen horizontally, place the cursor over the dash above the scroll bar at the far right of the spreadsheet just above the up arrow. The cursor becomes two lines with up and down arrows when placed over the dash. Left click on the dash and drag down under the last row you wish to freeze. The spreadsheet has been split into two sections. Each section can be scrolled independently. To split the screen vertically, place the cursor over the dash at the far right of the bottom scroll bar just after the right arrow. Click and drag to the end of the last column...
How to Use the Drop
1. Open Excel 2007 and select a workbook. Press 'Control' and 'O.' Browse your computer for the Excel workbook. Click the workbook and click 'Open.' The workbook opens.2. Select a cell or group of cells to apply the data validation. Select the 'Data' tab and click 'Data Validation.' Select 'Data Validation' from the drop-down list. On the 'Settings' tab, select 'List' from the 'Allow' drop down criteria. Type 'Yes,No,Maybe' in the 'Source' field.3. Click the 'Input Message' tab. Check the option for 'Show Input Message When The Cell Is Selected.' Type the title of your input message...
How to Protect One Cell in an Excel Spreadsheet
1. Open the Excel spreadsheet that contains that data and cells that you want to separately protect. Click on the individual cell that you want to lock.2. Click on the “Format” option from the top tool bar menu. Click on the “Cells” option and then click on the “Protections” tab.3. Click on the box next to the “Locked” field. Click on the “OK” button and you’ll be returned to the spreadsheet.4. Click on the “Tools” option from top tool bar menu. Scroll over the “Protection” option and then click on the “Protect Sheet” option.5. Type a password that will protect the cell from being unlocked...
How to Remove a Check Box in Excel
1. Open the Excel file that contains the check box you want to remove.2. Click the 'Design Mode' option on the 'Controls' group of the 'Developer' tab.3. Click once on the check box that you want to delete. Press the 'Delete' key on your keyboard. Repeat this step for each check box that you want to remo...
How to Use Excel's TAN Function
1. Enter your input values into a row or column in a blank spreadsheet. The 'input value' refers to the angle, represented by the 'x.' Let's assume you enter an input value of 5 and you enter it in cell A1.2. Click your cursor in a different cell and type the formula '=Tan(A1).' This gives you the result of -0.14255. This number represents the tangent of your angle.3. Change the number of decimal points in your answer if necessary. Go to 'Format' and 'Cells.' Select the 'Number' tab, then 'Number' and enter the number of decimal points you would like.4. Compare your answers with the most...
How to Set Row Height in Excel 2007
1. Open the Excel spreadsheet. Select the rows for which you want to set the row heights. Click on a row in the left column to select the entire row. Press and hold 'Ctrl' and click more rows to select multiple rows, or click the diagonal arrow in the top-left corner of the spreadsheet, above the first row, to select every row.2. Click the 'Home' tab from the Ribbon if it's not already selected. Click on 'Format' from the Cells section and select 'Row Height.' This opens a dialog box.3. Type a number into the text box and click 'OK.' This sets the row height for your selected cells to the...
How to Use Autofill With Numbers in Excel 2007
Autofill the Same Number1. Type the number in the first cell that you would like to contain that number.2. Click on the cell to highlight it.3. Click the small square in the lower-right corner of the cell and hold the mouse button down.4. Drag the square in whichever direction you would like to AutoFill. Release the mouse button when all desired cells are highlighted. The value is copied into the cells.Autofill a Sequence5. Type the first two numbers of your sequence in the first two cells in your list. For instance, to start an integer sequence in the 'A' column you would type '1' in...
How to Enable Extra Rows in Excel 2007
1. Select the row above which you want to place the new row. You can do this by left- or right-clicking the row number on the left-hand side. For example, if you want to insert a single row between rows three and four, select row four. If you want to insert three rows between rows three and four, select rows four, five and six by clicking on row four, holding down the left mouse button and dragging the cursor down over rows five and six to highlight them as well. To select rows that are not adjacent to each other hold down the 'Ctrl' key and click on the rows you wish to highlight.2. Click...
Saturday, December 22, 2012
How to Use Spin Buttons in Excel
1. Use Excel to create your chart or document. Note: Be sure to save your work every few minutes.2. Open the 'Developer' tab, select 'Controls,' and then 'Form.'3. Select the 'Insert' option on that tab. You will see this with a little folderlike icon and some tools.4. Click on your Excel document where you want the spin button to appear. The place where you click is where the upper-left hand corner of the button will appear.5. Select the 'Properties' option from the 'Developer' tab and 'Controls.'6. Start setting your options for the spin button. Let's say that you decided on the...
How to Split a Merged Cell
1. Right click on the merged cell. Click 'Format Cells.'2. Click on the 'Alignment' tab.3. Uncheck the 'Merge Cells' check box by clicking on it.4. Click 'OK'. The merged cells are now split.5. Click on the icon for merged cells on the menu bar if available to enable or disable merged cells when needing a quick shortc...
How to Password Protect an Excel Worksheet Using a Macro
1. Open the Microsoft Excel spreadsheet you wish to protect.2. Press 'ALT F11' to open Visual Basic.3. Click on the 'Insert' menu and select 'UserForm.'4. Click on the 'TextBox' tool and drag it onto the 'UserForm' work area. Adjust the size of the text box as desired.5. Press 'F4' with the 'TextBox' still selected to enter the 'Properties' pane and scroll down to 'PasswordChar.' Insert an asterisk (*) in the value column.6. Click on the 'UserForm' to bring the toolbox back and drag a 'CommandButton' onto the 'UserForm.' For aesthetic purposes, position the button to the right of...
How Do I Repeat Headers on Every Page In Excel?
1. Open the Excel spreadsheet that you want to print with repeating headings.2. Click the 'Page Layout' tab on the ribbon.3. Click the 'Print Titles' button in the Page Setup group. This will open a window with several tabs. Select the 'Sheet' tab if it is not already open.4. Click the little blue icon with a red arrow at the far right of the box called 'Rows to repeat at the top.' This will bring up a narrow window with a blank line. Click the row in your spreadsheet that you want repeated. Usually this is the first row with column headings. To select several rows, click and drag down...
How to Change Cell Font Alignment in Microsoft Excel 2003
1. Select all of the cells. To change the alignment in all of the cells, make sure that you have your spreadsheet file open, then use the hotkeys “CTRL-A” to select all of the cells in the spreadsheet.2. Open the cell properties box. Once you have selected all of the cells, right-click on the highlighted cells; a cell submenu will open. Select “Format Cells” and a cell properties box will open.3. Select the desired font alignment. Scroll to the “Alignment” tab in the cell properties box to change the alignment. You can set the vertical and horizontal attributes as well as specifying whether...
How to Format Worksheet Groups in Excel
1. Start Microsoft Excel 2007 and open an existing workbook that contains worksheets that are grouped together to form a group.2. Look at the sheet tabs in the lower left corner of the Excel screen. The sheet tabs that are white represent the worksheets that are part of the group.3. Click on a white sheet tab so you bring up one of the worksheets that are in the worksheet group. It does not matter which one you choose, the formatting will be applied to all the worksheets in the group.4. Select the cells in the worksheet that you want to apply formatting to in the selected cell on this...
How to Sort Microsoft Excel Rows Alphabetically
1. Select the data you would like to sort alphabetically. Maybe it's just a small selection in a large worksheet, so simply select only the cells and any corresponding data; everything else remains the same.2. Click on 'Data' from the main toolbar at the top of the worksheet and in the sub-menu that drops down, click on 'Sort.' The Excel program automatically selects the entire set of data and opens a new window.3. Check to see that the data you select matches what you want to sort. If the program indicates that there isn't enough data or the data selection is too limited in some way, a...
How to Create a Normal Distribution Graph in Excel
1. Enter -4 in cell A1. Enter -3.75 in cell A2. Highlight both cells and grab the fill handle (the tiny box in the bottom right hand corner) with your mouse. Drag the fill handle to cell A33 and release the mouse.2. Enter =NORMDIST(a1,0,1,0) into cell B1. This tells Excel to calculate the standard normal distribution from the value you entered in cell A1 with a mean of 0 and a standard deviation of 1. Press enter.3. Using the same motion you used in Step 1, drag the fill handle from the corner of cell B1 down to cell B33.4. Highlight cells A1 through A33 by holding the the left mouse button...
Friday, December 21, 2012
How to Create a Drop
1. Open Excel 2007 and click a blank cell in the workbook. Select the 'Data' tab and select 'Data Validation.' A drop-down list appears. Click 'Data Validation.' On the 'Setting' tab, change the Allow field to 'List.' In the source field, type 'yes,no,maybe.'2. Click the 'Input Message' tab. Click 'Show input message when the cell is selected.' Add a title for your input message in the 'Title' field. Add a custom input message in the 'Input Message' notes field.3. Click the 'Error Message' tab. Click 'Show error message when invalid data is entered.' Add a title for your error message...
How to Calculate Correlation Coefficient Between Two Data Sets
1. Open Excel 2007 and sum in one column the numbers for the first set of data. For example, you would add the numbers 10, 20, 30, 40, 50 and 60 in the A2, A3, A4, A5, A6 and A7 cells of your Excel worksheet. In a second column, sum the numbers for the second set of data. For example, you would add the numbers 5, 2, 6, 6, 7 and 4 in the B2, B3, B4, B5, B6 and B7 cells of your Excel worksheet. Your goal is to find the correlation coefficient for these two sets of data.2. Click on the 'A9' cell. This is the cell where you will calculate the correlation coefficient.3. Click on the 'Formulas'...
How to Freeze a Row in Microsoft Excel
1. Open the Excel worksheet.2. Click the top row heading. The row heading displays a number just left of the first column of cells. The selected row appears shaded.3. Click the 'View' tab on the command ribbon.4. Click the 'Freeze Panes' button in the 'Window' group. A list of options appears.5. Click the 'Freeze Top Row' option. A black horizontal line appears on the worksheet. This line indicates the locked row that stays on the screen as you scroll down the workshe...
How to Add a Title to an Excel Chart
1. Start Microsoft Excel 2007 and open a spreadsheet that contains a chart to which you would like to add a title.2. Click in the white area of the chart to select the entire chart. There should be a light blue outline surrounding the chart indicating that you have selected the entire chart.3. Select the 'Layout' tab at the top of the Excel screen to display the layout options for the selected chart.4. Click the 'Chart Title' button in the 'Labels' section of the 'Layout' ribbon. A drop-down menu will appear that will display the different locations that you can add a title for the selected...
How to Use a Filter in Excel
1. Isolate column headings to one cell. If a column heading spills over into another cell, use text wrapping to place the heading in one cell. Highlight a multi-cell column header, press 'Format' on the menu bar, click 'Row', select 'Autofit and then Format', select 'Cells' and 'Wrap Text' to place headers in one cell.2. Format the row that contains the column heading differently than the rows that contain data, so Excel recognizes it is a row heading. Embolden characters, change the font color or place a border around the column heading to differentiate from data cells.3. Ensure each column...
Thursday, December 20, 2012
How to Put Roman Numerals in Microsoft Office 2003
1. Open Microsoft Office Excel 2003.2. In the Excel spreadsheet, click on a cell where you wish to put a Roman numeral.3. Type '=Roman(58)' and press 'Enter.' The Roman numeral 'LVIII' that represents '58' will appear in the cell. Note that you can enter any number from 1 to 3,999 in parentheses.4. Repeat Step 3 for other cells and/or numbers.5. Click on a cell with the Roman numeral created in steps 3 or 4, and press 'Ctrl-C' on the keyboard to copy it.6. Launch Microsoft Office Word 2003. Click the menu 'File' and select 'New' to create a new document, or 'File' and 'Open' to open...
How to Use a Saved Template for Pivot Charts
1. Click 'Start' and 'All Programs.'2. Navigate to the 'Microsoft Office' folder, click it once to display the folder contents and then click 'Microsoft Excel' to launch the program.3. Click the 'Office' button in the upper left corner, and then select 'New' to create a new document. Or click 'Open' to locate and open an existing Excel spreadsheet.4. Click and hold your mouse on the uppermost cell containing your target data, and then drag the mouse until all of your target data has been selected.5. Click the 'Insert' tab at the top of the screen. Then click on the 'PivotTable' icon,...
How to Create a Calendar in a Pull
Create a Calendar Using Excel 20071. Enable the 'Developer' tab. The Excel 'Developer' tab is inactive by default, so you may need to activate it to create a pull-down menu. To activate the 'Developer' tab, click the 'Office' button in the top-left corner of Excel. Locate and click the 'Excel Options' button along the bottom right of the menu. Select and click the 'Show Developer in Ribbon' check-box from the pop-up menu, then click 'OK' to exit.2. Insert a pull-down calendar. Click the 'Developer' tab from the Excel main menu ribbon. Click 'Insert' to display a menu of options and then click...
Wednesday, December 19, 2012
How to Make a Dashboard in Excel
1. Open an Excel workbook containing data you want to manipulate. Create a new worksheet, inserted at the front of the workbook, and call it 'Dashboard.'2. Click 'File' and then 'Options.' Click 'Customize Ribbon.' Tick the checkbox next to 'Developer' and click 'OK.' This enables your form control. Forms can be a vital component in an Excel dashboard.3. Insert form items by clicking 'Developer,' 'Insert' and selecting a form option. With forms, such as a combo box, you can 'Format Control' and choose an output cell. That cell, in the case of a combo box, will show a number representing...
How to Make a Graph in MS Excel That You Change Every Day
1. Open the Microsoft Excel 2010 spreadsheet that contains the data you want to make into a dynamic graph.2. Click anywhere in your data, then click the 'Insert' tab at the top of the screen. Click the chart button that corresponds to the type of graph you wan to use, then select your desired graph from the popup menu to make it appear on the spreadsheet.3. Click the 'Formulas' tab at the top of the screen, then click the 'Define Name' button in the middle of the ribbon. Type a name for the first data series in your chart. This is normally the same text as appears in the header above the...
How to Make an Address Book on a Computer
1. Open up Microsoft Excel on your computer. You will see that a spreadsheet opens up with predetermined rows and columns. You will use these rows and columns to set up your address book.2. Add a title to the top of the spreadsheet. This will help you remember what information is in a particular address book. You may need to set up different address books for various purposes--for example, one for members of a book club and one for family members. Having a clear title will help you keep everything organized. Make the title bold and increase the size of the font, using the tools on the top...
How to Draw a Histogram With MS Excel
1. Type your data into column A of your worksheet. For example, click on cell 'A1' and type your first data item, click on cell 'A2' and type your second data item. Continue down the column, clicking on cells and typing your data in until all of your values are on the worksheet.2. Place your bin widths into column 'B.' Type the top value of each bin, starting in cell B1. For example, if your bin widths were 0 to 4 feet, 5 to 6 feet and 6 feet to 8 feet, type '4' into cell B1, '6' into cell B2 and '8' into cell B3.3. Click on the 'Data' tab, then click 'Data Analysis.'4. Click on 'Histogram,'...
Tuesday, December 18, 2012
How to Insert an Excel Spreadsheet to a VB Form
1. Open Microsoft Excel and type 'A' in 'A1,' 'B' in 'B1,' 'Column A' in 'A2,' and 'Column B' in 'B2.' Save your spreadsheet to 'C:\' as 'ExcelFile.xlsx.'2. Open Microsoft Visual Basic 2010 Express, click the 'File' menu and select 'New Project.' Click 'Installed Templates,' select 'Windows Forms Application' and click 'OK.'3. Press 'Ctrl' 'Alt' 'X' to open the 'Toolbox' window. Double-click 'DataGridView' to add a new Data Grid View control to 'Form1.' Double-click 'Button' in 'Toolbox' to add a new button to 'Form1.'4. Double-click 'Button1' to open the 'Form1.vb' module. Type...
How to Tell If a Worksheet Is Protected in Microsoft Excel 2003
Single Worksheet1. Click on the 'Tools' menu.2. Select 'Protection->Protect Sheet.'3. Read the dialog box. If 'Protect worksheet and contents of locked cells' is checked, the sheet is protected.Workbook (All Worksheets)4. Open the workbook. If you cannot open the workbook, it is protected at the file level.5. Add another worksheet to the workbook. If you can't add another sheet, the workbook is protected.6. Resize the Excel window. If you can't, the workbook is protect...
How to Fill a Series in Excel 2007
1. Type out a series of numbers in the cells you want the start your series. For example, type '1' in cell A1, '2' in cell A2, then '3' in cell A3.2. Click on the first number in your series, then press 'Shift' and using the arrow buttons highlight the remainder of the series you typed. In the example, highlight cells A1 through A33. Click and hold the click in the lower, right-hand corner of the highlighted cells, then move the mouse down to highlight the empty cells where you want to continue your series. In the example, click and hold on the bottom right of cell A3, then drag the mouse...
How to Make Custom Receipts
Excel 20101. Select the 'File' tab and select 'New.' Click 'Receipts' in the left task pane. Review the receipts that appear. Click a receipt to see a preview in the right task pane. Download a receipt by clicking the receipt image and the 'Download' button in the right task pane. The template opens in Excel 2010.2. Update the logo section by right-clicking on the default logo and selecting 'Change Picture.' Browse your PC for the logo you want to use. Click the logo and the 'Open' button. Your logo replaces the default logo.3. Highlight the default text and type your customized information...
Monday, December 17, 2012
How to Delete Every Other Row of an Excel Spreadsheet
1. Open the Excel Visual Basic Editor. With your spreadsheet open in Excel, click 'Tools' from the menu near the top of your screen, then select 'Macro' and 'Visual Basic Editor.' If you use Excel 2003 or older, go on to the next step.Excel 2007 users will notice that the previous command does not exist in the current version of Excel, and that no macro editing tools appear by default. Turn on access to these tools by clicking the Office button at the top-left corner of your screen, then clicking the 'Excel Options' button at the bottom of the menu. Locate the heading labeled 'Top options for...
Sunday, December 16, 2012
How to Remove Borders From Cells in Microsoft Excel 2003
1. Open the file that you wish to work on. Scroll to the “File” tab on the command bar and select “Open.” Then browse to the desired Excel file and click “Okay” to open it.2. Access the cell with the borders that you wish to remove. You can activate the cell by scrolling to the cell of choice and left-clicking on it.3. Remove the border from the cell. Scroll to the “Format” tab on the command bar and select “Cells.” Under the cells properties box, left-click on the “Border” tab.4. Set the border presets. There will be box under this tab labeled “Border Presets.” You will need to left-click...
How to Create a Spreadsheet Template in Excel 2003
1. Open a new Excel document.2. Make your spreadsheet. Include all the formatting you would like for your template. Add the fonts, cell colors, macros and anything else you would like.3. Include only the information that needs to be on every spreadsheet. For example, if you are making a template for a budget, add the headings but not the entries for each transaction.4. Go to File > Save As. Below the box where you name the file, there is a drop-down menu with file types. Save your file as a '.xlt' Template file. Name the file and click Save.5. Use the template. Go to File > New....
How to Create a Form Using Mircosoft 2007 Excel
1. Launch the Microsoft Excel 2007 program and open a blank spreadsheet. Click the 'Start' button and then 'Excel.' If you do not have Excel 2007, a free trial of Office may be downloaded from the Microsoft site (see Resources section). If a blank spreadsheet does not open automatically, click the 'Microsoft Office' button and then 'New.' Double-click the 'Blank Spreadsheet' icon to open a blank document.2. Make certain the 'Developer' tab is available in the 'Ribbon.' Click the 'Microsoft Office' button and select 'Excel Options' to launch a separate dialogue window. Click the 'Show Developer...
How to Add Data Labels to a Pie Chart
Adding Data Labels to a Pie Chart in Excel 2007 and Excel 20101. Start the Microsoft Excel program and open the worksheet containing the pie chart to which you wish to add data labels.2. Select the chart by clicking on it. A translucent ribbon will appear at the edges of the chart, indicating its selection.3. Click on the 'Layout' tab in the toolbar above the chart to display the 'Layout' ribbon.4. Locate the 'Data Labels' button and click on the downward arrow to reveal a drop-down list of options.5. Select the desired location for the labels. This will add data labels on your pie chart.Adding...
How to Construct a Histogram in Microsoft Excel
1. Click on the 'Data' tab in Excel 2007 or the 'Tools' tab in Excel 2003.2. Click on 'Data Analysis.'3. Choose 'Histogram' from the list box, then press 'OK.'4. Tell Excel where your data is by entering a range in the 'Input range' box. For example, if your data is in column A2 to A11, type 'A2:A11' into the box. If you have entered your own bin values (a range of data for the columns), enter the location of the data in the 'Bin values' box in the same format. For example, if your bins are located in B2 to B5, enter 'B2:B5' in the bin values box.5. Check the 'Chart Output' box, then...
How to Get Stock Quotes in Excel
1. Open Microsoft Excel. First, select 'Start' from the main operating system menu. Next, choose 'Programs.' Then, click on 'Microsoft Office' in the programs menu. Finally, select 'Microsoft Excel' from the Microsoft Office menu.2. Click on the 'Data' menu from the Microsoft Excel main menu screen. Then, choose 'Get External Data' from the data menu. A dialog box will appear with a list of established data sources. Finally, choose the data source labeled 'Investor Stock Quotes.'3. Select the cell in the spreadsheet for the stock quote information input or choose the 'Create New Worksheet'...
Saturday, December 15, 2012
How to Do a Pamphlet in Excel
1. Click on the 'File' tab and select 'Print.' Set the layout of the spreadsheet to 'Landscape' and set the margins to '0.25' on all four sides of the page. This will give you the maximum printable area on your pamphlet.2. Click on the “View” tab and select 'Page Layout' on the left side of the Ribbon. This will change the view of your spreadsheet to one with page borders set. In this view you will also be able to set the width of columns in inches or fractions of an inch which is essential to using Excel as a page layout program.3. Click on the box at the upper left hand corner of the...
How to Convert the First Letter to an Uppercase in Excel
1. Decide if you want the first letter of every word to be capitalized ('Pete Is Great'), or just the first letter in the cell ('Pete is great'). In this example, assume that the original text ('pete is great' - note no capitals) is in cell A1, and you want the text capitalized in cell B1.2. Enter the following Excel code into cell B1 if you want every word to be capitalized:=PROPER(A1)This will give the output 'Pete Is Great'.3. Type the following Excel code into cell B1 if you only want the first letter of the cell capitalized:=UPPER(LEFT(A1,1))LOWER(RIGHT(A1,LEN(A1)-1))This will give...
How to Build Drop
1. Scroll to the area of the spreadsheet where you want to create the drop-down list's contents. You build a drop-down list menu in Excel from data typed into any set of cells. If you want this to be inconspicuous to the Excel user, do not use the beginning of the spreadsheet. Instead, you can scroll to the right several columns or scroll down many rows to a less obvious part of the spreadsheet.2. Type the list you want in your drop-down list menu. You can either type the list as a series of vertical cells, all in the same column, or as a horizontal list, all in the same row. For example,...
How to Use Excel Charts
1. Launch Microsoft Excel 2010.2. Open a file with some data already present in the cells or populate a blank sheet with some data that will be used for the chart. Include data labels for the rows and columns by typing descriptive names for the data in the next cell above the first entry in each column and in the next cell to the left of each row of entries.3. Click in the cell above the first row label and to the left of the first column label and hold the mouse button down. Drag the mouse across the data diagonally until it is pointed at the lower right entry in the last row and last column...
How to Copy Vertically Paste Horizontally in Excel
1. Open the document in Microsoft Excel and highlight the cells you want to copy.2. Click the 'Home' tab on the Microsoft Office ribbon and click 'Copy.'3. Click on the cell where you want to paste the data.4. Click the pull-down menu next to 'Paste' on the 'Home' tab to view a list of paste options, then click 'Transpose.' The copied data is pasted into the highlighted cell and its adjacent cells with the rows and columns revers...
Friday, December 14, 2012
How to Calculate Descriptive Statistics Using Analysis ToolPak
1. Open Excel 2007 and add the numbers for which you want to calculate descriptive statistics in the first column. For example, add the numbers 210, 110, 50, 50, 70 and 80 in A2, A3, A4, A5, A6 and A7 cells of Excel.2. Click on the 'A9' cell. This is the cell where you will calculate the descriptive statistics using Analysis ToolPak. Please note, you don't have to select 'A9' cell for the descriptive statistics calculation; any cell under your chosen values can be selected.3. Click on the 'Data' tab and then 'Data Analysis' found on the top right-hand side of the Excel spreadsheet. A window...
How to Make a Log with Microsoft Excel 2003
How to Make a Log with Microsoft Excel 20031. Choose the column headings you wish to use and determine the number of columns you will need. If your log requires the headings 'Date,' 'Time,' 'Comment' and 'Initials,' you will need 4 columns.2. Open Microsoft Excel 2003 and type your column headers in the first row. For this example, type 'Date' in Cell A1, 'Time' in Cell B1, 'Comment' in Cell C1 and 'Initials' in Cell D1. Highlight those 4 cells and choose the format and font you wish to use for the text.3. Highlight columns A through D and right click somewhere on the highlighted cells....
How to Calculate Probability Using Excel
1. Go to Start>Programs>Microsoft Office>Microsoft Excel. If Excel has been used recently, simply go to Start>Microsoft Excel.2. Create two columns, one entitled 'Numeric grades' and the other 'Probability of getting each grade.'3. List the grades from 50, 60, 70, 80, 90 and 100 in cells A2 to A7.4. List the probabilities associated with each grade from cells B2 to B7. List the numbers as follows: 0.05, 0.1, 0.4, 0.3, 0.1 and 0.05.5. Enter '=Prob(A2:A7,B2:B7,70,100)'. This formula for probability isolates the numeric range of numbers (A2:A7), the probability of getting...
How to Link an Excel Cell to a Word Document
1. Open the Excel document within Excel and right-click on the cell to be linked to the Word document.2. Select 'Hyperlink' from the cell menu and locate the Word document to link it to and then click 'OK.'3. Save the Excel spreadsheet and then click on the cell to open up the linked Word docume...
Thursday, December 13, 2012
How to Make a Parabola on Excel
1. Enter a series of x values into the cells in a column, entering multiple values on either side of the vertex. If you are unsure of the vertex, enter a wide range of x values.2. Enter an equal sign followed by the formula being graphed into a cell next to the top x value, then click on the lower right corner of the cell and drag down to the cell next to the bottom x value to copy the formula automatically. Excel will not display the formula in the cells, it will show the results.3. Highlight the values entered in both columns. If you were not sure of the vertex, find the point where the...
How to Convert a Mac Date System to Excel
1. Open the Excel file that contains the cells with incorrect dates.2. Click on any empty cell. Type '1462' into this cell, as this signifies the number of days between the two date systems. Right-click the cell and choose 'Copy.'3. Select the cells that contain the incorrect dates. To select multiple cells, click and hold on the top left cell in a range and then drag your mouse to the bottom right cell. Hold the 'Ctrl' button to select ranges that aren't adjacent to each other.4. Right-click on any of the selected cells. Move your mouse over 'Paste Special' in the first pop-up menu that...
Wednesday, December 12, 2012
How to Insert a PDF Into Excel
1. Open Excel 2007 and select the 'Insert' tab. Select 'Object' from the 'Text' group. The Object dialog box appears. Click the 'Create from File' tab. Select the 'Browse' button. Search your files to locate the PDF that you plan to insert. Click the file and select 'Insert.' Click 'OK.' Excel inserts the PDF into your document as an image.2. Review the image of the PDF in your workbook. Open the PDF by right-clicking the image and select 'Adobe Document Object.' Select 'Open.' The PDF opens with Adobe in a separate Adobe window.3. Save your changes by clicking the 'Save' icon the...
How to Subtract Cells in Excel
Create a Formula1. Enter your data. For the purpose of this example, type the number 34 in cell A1 and the number 15 in B1.2. Choose the cell where you want your results to appear. Use C1, for instance.3. Place an equal sign (=) in C1. The equal sign always precedes formulas in Excel and goes into the cell where your results will be displayed.4. Click on cell A1. Clicking on this cell automatically places 'A1' in cell C1.5. Type a minus sign (-) in cell C1.6. Click on cell B1. Clicking on this cell automatically places 'B1' in cell C1.7. Press the 'Enter' key on your keyboard, or...
How to Convert Excel 2007 to Excel 2002
Instructions1. Complete your spreadsheet. Save as usual by clicking on the 'Office' button and selecting 'Save' from the drop-down menu. This will open a pop-up window. Type your file name in the 'File Name' box and click 'Save.' This will save your spreadsheet as an Excel 2007 file with the extension '.xlxs' and ensure that you have access to the original document.2. Use the 'Save As' option to convert your Excel 2007 file to one that is compatible with earlier versions of Excel. Click on the 'Office' button again to reveal the drop-down menu.3. Select 'Save As' from the drop-down menu....
How to Copy an Excel Worksheet
1. Open Microsoft Excel and the file you want to change.2. Open the Edit menu and select Move or Copy Worksheet.3. Click the Create a Copy option in the dialog box.4. Select OK to create a copy.5. Rename your newly copied worksheet by double-clicking its tab at the bottom of the Excel wind...
How to Remove Characters in Excel 2007
1. Open your spreadsheet and select all cells from which you want to remove the character string.2. Click the 'Home' tab and click 'Find Select' in the 'Editing' group. Click 'Replace' to open a Find and Replace dialog box.3. Type the character or string of characters that you want to eliminate in the 'Find what' field.4. Type the new characters that you want to insert in place of the removed characters in the 'Replace with' field. If you simply want to delete the characters, then don't type anything in this field.5. Click the 'Find Next' button if you want to perform the search-and-replace...
How to Get Started With Excel VBA
Record a Macro1. If you have ever recorded a macro, you are already using VBA. The Visual Basic editor translates your keystrokes into VBA commands. The resulting code is inefficient, but it can help you get familiar with VBA syntax and commands.2. In Excel, record a simple macro. In Office XP, select Macro, Record New Macro from the Tools menu. (In Excel 2007, commands are on the Developer tab.) Change the macro name or leave the default, and press OK.3. With the macro recorder running, type 'Hello World' in cell A1. Apply Bold, Italic, and Underline, and change the font color to red. Double-click...
Tuesday, December 11, 2012
How to Create Multiple Graphs in One Chart
1. Open your spreadsheet program and enter your two data sets into adjacent columns. Type a label for your data sets in the first row of each column. (Note: These instructions are based on Open Office Calc, a free spreadsheet program, but the process will be similar when using Microsoft Excel.)2. Click and drag to select all of the cells whose data you wish to include in your chart, including the 'label' cells at the top of each column.3. Click 'Insert' and then 'Chart.' Select 'Line' from the 'Choose a chart type' column. Select 'Lines and Points' from the icons on the right-hand side of...
How to Create a 4 Axis Chart in Excel
1. Create a new spreadsheet in Excel.2. Type the label names of your axes in each column, for example, Axis 01, Axis 02, Axis 03, and Axis 04 as headers in columns A, B, C, and D respectively.3. Type the corresponding data for each column and row. The row data will be the “Series” plotted against the actual axis of each column.4. Highlight the entire set of rows and columns by dragging the mouse cursor across the axis and data fields while holding the left mouse button down.5. Click “Insert,' 'Charts,' then 'Other Charts' and choose a 'Radar' option from the main me...
How to Print Odd Even Pages in Excel 2007
1. Click on the 'Developer' tab in Excel 2007.2. Click on 'Visual Basic' to open the Visual Basic Editor (VBE).3. Click 'Insert,' then 'Module' to open a blank module window.4. Copy and paste the following code into the module window:Sub PrintOddEven()Dim TotalPages As LongDim StartPage As LongDim Page As IntegerStartPage = InputBox('Enter starting page number')TotalPages = Application.ExecuteExcel4Macro('GET.DOCUMENT(50)')If StartPage > 0 And StartPage 5. Press 'F5' to run the macro. A pop-up window will appear and you will be returned to the Excel spreadsheet.6. Type the starting...
How to Make a 2 Column List in an Excel Spreadsheet
1. Open Microsoft Excel 2007 on your computer. As you can see, several columns and rows already come up in Excel.2. Place a title at the top of the spreadsheet. This is very important so that you know what is actually listed in the spreadsheet. Place the title at the very top of the page, starting in cell A1.3. Add titles to the two columns that will compose the list. Place the column titles a few lines down from the title of the spreadsheet. This will help you remember what information is in each column. Center the columns by highlighting both cells and click on the centering icon (showing...
Subscribe to:
Posts (Atom)