1. Open Microsoft Excel 2003.2. Click 'Tools' on the top navigation bar and then click the 'Add-ins' option.3. Un-check the check box next to the add-in you want to disable.4. Click the 'OK' button.5. Close and restart Excel. The add-in is disabl...
Browse » Home » All posts
Saturday, July 13, 2013
How to Do Macros in Excel 2003
1. Open up the Excel 2003 file in which you want to create a macro. Select the 'Tools' menu at the top of the screen, then move your mouse to the 'Macro' option and select 'Security' from the pop-up menu. Select either medium or low in order for macros to operate correctly in the worksheet. Low will always prompt you if you want to run the macro, while medium will not. Click 'OK' to continue.2. Click on the cell where you want the macro to start. You will be given the option later to use relative references, and if you are then you will need to have selected the starting macro location beforehand.3....
How to Use Descriptive Statistics in Excel
1. Type your data into the spreadsheet. For example, you might type a list of heights into column A or a list of egg prices in column F.2. Click on a blank cell in a spreadsheet.3. Click on the 'Formulas' tab on the Excel toolbar, then click on 'More Functions' in the Function Library. Click on 'Statistical' and then mouse over the function for a description, and if it is the function you need, click on it to open a dialog box for the function. For example, 'Median' returns the median, or the middle number in the data set.4. Type the location of your data into the text box. For example,...
How to Graph Two Datas Scatter Plot in Excel
1. Open the Excel spreadsheet containing the two columns of data you want to turn into a scatter plot. Scroll down to the bottom of the column and click the lowest cell containing the data. Drag up and across until both columns are highlighted.2. Navigate to the 'Insert' tab at the top of the spreadsheet, which is positioned to the left of the 'Home' tab. Click the 'Scatter' button in the 'Charts' heading near the top of the screen.3. Click the icon in the drop-down menu for the specific type of scatter plot you want to use, such as 'Scatter With Only Markers,' 'Scatter With Smooth Lines...
How to Use Excel to Calculate Beta Coefficient
1. Create a new spreadsheet in Microsoft Excel. Type the historical data for the stock in question and the benchmark in two separate columns.2. Find the percent change of the data for the benchmark and the stock using the following formula:=((Cell2-Cell1)/Cell1)*100Cell 1 indicates the previous period data point, and cell 2 indicates a current period data point. Drag the formula with the mouse down the two columns.For example, if the stock's daily stock price was $100 per share in June 2010 and is $125 in June 2011, the $125 is cell 2 and the $100 is cell 1. Subtract 100 from 125 to get 25....
Friday, July 12, 2013
How to Add an Axis Title to an Excel Chart
1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you would like to add an axis title.2. Select the entire Excel chart by clicking in the white area of the chart. A light blue line will surround the entire chart indicating it has been selected.3. Choose the 'Layout' tab at the top of the Excel screen and locate the 'Labels' group within the 'Layout' ribbon.4. Click the 'Axis Titles' button in the 'Labels' section of the 'Layout' ribbon to display a drop-down list.5. Point to 'Primary Horizontal Axis Title' to create a title for your 'X'-axis...
How to Open .Xlsx Files in .Xls
1. Download the Microsoft Office Compatibility Pack to your computer.2. Launch the older version of Excel.3. Click the 'File' menu and select 'Open.' Use the 'Look in' menu to find the folder in which the XLSX file is saved. Highlight the XLSX file name and click 'Ope...
How to Create a Stacked Column Chart With the Data Plotted in Rows Using Excel
1. Open the Excel 2010 file that hold the data that you want to use in a chart.2. Check the data to ensure that you have headers in the first column. If you don't, right-click on the letter above the first column and choose 'Insert.' Type in a header for each row into the column you just created.3. Click on any cell that is part of your data field. Excel will automatically expand the selection to all adjacent cells when you create the chart. If you need to chart a specific area of your data, click on the top left cell of the area you want to chart, then hold 'Shift' and click on the bottom...
Thursday, July 11, 2013
How to Put a Command Button on a Spreadsheet in Excel
1. Open the spreadsheet in Excel that you want to add a command button to. Click the 'Office File' button on the main ribbon and click 'Excel Options.' Enable 'Show Developer tab in the ribbon' if it isn't already checked and click 'OK.'2. Click the 'Developer' tab, then click 'Insert.' This brings up the list of controls that you can insert. Click the 'Button' link from the list of options.3. Click in the spreadsheet where you want the command button to be placed.4. Choose a macro from the list to assign to your command button, then click 'OK.'5. Right-click the button and click 'Format...
How to Make Ledgers on Excel
1. Open a new Microsoft Excel spreadsheet. Type 'Opening Balance' into Cell A1. Type the opening balance into cell D1.2. Type the name of the first credit or deduction into cell A2. Type the amount -- positive for additions, negative for deductions -- into cell C2. Type the formula =(A1 C2) into cell D2.3. Input the names of amounts additional additions and credits as you become aware of them. Each time click cell D2 and drag the black border around it down into the 'D' column of the row where you notate the new transaction to display the new running balance in the 'D' cell of that r...
How to Password Protect an Excel 2007 File
1. Open the Excel 2007 file. Click the 'Office Button' located in the top-left corner.2. Select 'Prepare' from the list. Click the option to 'Encrypt Document.' Enter a password. Click 'OK.' Re-enter the password. Click 'OK.'3. Select 'Save As' from the list. Click 'Tools' located in the lower-left corner of the 'Save As' box. Select 'General Options' from the list. Set a password to open or modify the file. Click 'OK.' Re-enter the password. Click 'OK.'4. Click the Microsoft Office Button and select 'Sav...
How to Insert a Tick Mark in Excel
1. Reveal the Developer tab, if necessary. In Excel 2007, click the 'Office' button and choose 'Excel Options.' In the Popular options set, check the box labeled 'Show Developer tab in the Ribbon.' In Excel 2010, click 'File' then 'Options.' Choose 'Customize Ribbon' in the Categories pane and check 'Developer' in the list of tabs.2. Click the 'Developer' tab. Choose 'Insert' and from the Form Controls group choose the small box with a check mark in it.3. Draw a box with the cursor to define the location and size of tick mark and its label. These remain changeable.4. Click on the text,...
How to Copy VLookup to Multiple Rows
1. Open the Excel 2010 file where you want to copy the VLookup function down to multiple rows.2. Click on the cell that contains your VLookup formula. Place your cursor into the formula bar located just above the spreadsheet so that you can edit the formula.3. Place dollar sign symbols in front of any ranges that you don't want to change when you copy your formula down. Excel uses relative references when copying formulas, so if your VLookup function referenced the range A1:D10 and you copy that formula down one cell, the range would change to A2:D11. By placing dollar signs in front of...
How to Enable Scrolling in Excel 2007
1. Open the Microsoft Excel 2007 file on which you want to enable scrolling.2. Click on the 'Microsoft Office' button from the top of the page and click on the 'Excel Options' button.3. Click on the 'Advanced' button from the left side of the Excel Options dialog box.4. Click on the box next to the 'Zoom on Roll with Intellimouse' option so it's deselected.5. Click on the 'OK' button, and you should now be able to scroll throughout your workshe...
How to Change the Case in Microsoft Excel 2007
1. Open the Excel worksheet that has the case you want to change.2. Decide which case you want to use. You can choose from uppercase, lowercase or proper case (the first letter is capitalized).3. Use a blank cell, row or column next to the cell you want to change. If there is not a blank cell, row, or column, right-click next to the cell you want to change, select 'Insert' and choose whether you want to insert a new row or column. You can delete this later. If you need to change the entire spreadsheet, start with the column available at the end of the spreadsheet.4. Enter '=' and the function...
Subscribe to:
Posts (Atom)