1. Open the Microsoft Excel application by clicking 'Start' and typing 'excel' into the search bar. Click on 'Excel' in the list that appears to open it. You can also click 'All Programs' and open Excel from there. You don't need a password to open Excel this way -- you only it when you double-click on a protected file.2. Click 'File,' then 'Open.' Click on the name of the file that is password-protected. Type the password and hit 'Enter' to open the document.3. Click 'File,' then 'Info' and 'Permissions.' Click 'Encrypt with Password.' The password entry box opens.4. Delete the password...
Browse » Home » All posts
Monday, April 22, 2013
Sunday, April 21, 2013
How to Detect Repair Excel 2003
1. Open Excel 2003 by clicking on the 'Start' button, then 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel 2003.'2. Click 'Help' on the main menu, then select Detect and Repair. The Detect and Repair dialog box is displayed on your screen. You may be prompted to select an installation source. If so, browse to the location of your Microsoft Office installation files or insert the installation disc.3. Choose if you want to restore your shortcuts or discard any customized settings by selecting the appropriate check boxes.4. Click 'Start' to begin the Detect and Repair process....
Saturday, April 20, 2013
How to Make a Cell in Excel 2007 Act Like a Checkbox
1. Open the Excel worksheet you want to modify by adding in a check box. Navigate to the 'Developer' tab in the ribbon at the top of the window.2. Click the 'Insert' icon in the 'Control' heading to bring up a drop-down menu. Select the 'Check Box' icon in the 'Form Controls' grouping.3. Locate the cell that needs to act as a check box. Click the cell to create the new check box. Click the outline of the box and drag it to any other cell if you need to move it.4. Highlight the text that reads 'Check Box 1' and press the 'Backspace' key. Type in the text you want to appear next to the check...
Friday, April 19, 2013
How to Create an XY Chart
1. Open Excel and in a new workbook, create a data spreadsheet for the XY chart to reference. Enter the months, as shown in the graphic depiction in cells 'A1' through 'M4.' (NOTE: You can create a chart similar to the one shown instead.)2. Select 'Insert' from the menu bar. Next, choose 'Chart.' (NOTE: You can choose the chart icon on the menu bar if it is available.)3. Go to the 'Standard Types' tab and select the 'XY(Scatter)' chart from the Chart Type list box.4. Press the 'Press and Hold to View Sample' button to preview the chart before making your final selection. When ready, click...
How to Create a Family Tree on Microsoft
1. Open PowerPoint 2010 and click the 'File' tab. Click 'New.' Type 'Family Tree' in the search box. Review the available family tree templates that appear.2. Click the family tree template to see a preview of it in the right task pane. Click the 'Download' icon to download the template.3. Click in the text boxes and highlight the default text. Type in your family information. Save your changes by clicking the 'Save' icon on the Quick Access Toolb...
How to Use Excel's GETPIVOTDATA Function
1. Understand the syntax of the GETPIVOTDATA function. The formula is =GETPIVOTDATA(pivot_table, name). Pivot_table references a cell in the PivotTable or a range of cells in the PivotTable, a label of a cell above the PivotTable or the name of the range that contains the PivotTable. 'Name' is text enclosed in quotations marks that describes the data.2. Create a new workbook to practice using pivot tables. Label columns A, B and C with the headers 'Name,' 'Month' and 'Sales.' Under the header row, fill in several of the rows with data. Include the same name and month more than once.3. Hold...
Thursday, April 18, 2013
How to Use the Find the Method in Excel 2003 Using Visual Basic
1. Launch Excel 2003.2. Open the 'File' menu at the top of the screen and click 'Open.' Double-click the spreadsheet that needs to use the 'Find' method.3. Click the 'Tools' menu at the top of the window and scroll down to the 'Macro' entry. Click the 'Visual Basic Editor' entry in the sub-menu.4. Click the name of the worksheet you need to use in the list of worksheets at the left side of the screen. Click inside the code editor screen at the left side of the window.5. Type the phrase 'Sub Finding()' at the top of the screen to let the Visual Basic editor know where the code should...
How to Find the Weighted Mean in Excel 2007
1. Input your data points into column A in your Excel 2007 worksheet, one number per cell. For example, you might input the numbers 90, 86, 45, 67, 78, 76, 79, 82.2. Input the weight of each of the numbers in column B. The weight of each number should sit directly to the right of the number. The weights you choose do not matter, they are only meaningful relative to each other. For example, if a data point has a weight of 1 and another point has a weight of 2, the second point will be twice as important to the mean, but if both data points have a weight of 2, they will be identically important....
How to Calculate a Standard Error Regression
1. Open Microsoft Excel 2007. Input your data into the spreadsheet into two columns. You should have known values for y (your dependent variable) and each independent variable.2. Go to the 'Data Analysis' command under the 'Data' tab on the user interface. If you do not have this function, you must add it in. To add the analysis to Excel, go to the 'Microsoft Excel' button in the right-hand corner of your screen. Go to 'Excel Options and Add-ins.' Select the 'Data Analysis' toolpak. Download to your Excel program.3. Select 'Data Analysis.' A list of statistical choices will appear. Choose...
How to Make a XY Graph on Excel
Create XY Graph In Excel 20031. Open Microsoft Excel 2003.2. Place your data such that all the X-values are in the same row or column. Place your other set of data in an adjacent row or column. For example, if you have six X-values and six Y-values, place all the X-values in column A and all the Y-values in column B.3. Select the range of values to be included in the XY chart. To select the range of the six XY-value example, click the first cell included, which is A1, then drag your mouse to the last cell to be included, which is B6.4. Go to the 'Insert' menu, and click 'Chart.'5. Select...
Wednesday, April 17, 2013
How to Disable Links in Excel 2007
1. Click the Excel button on the top toolbar, and then select the 'Excel Options' button at the bottom. Choose 'Proofing' from the left menu.2. Click the 'AutoCorrect Options...' button under the 'Autocorrect options' section. Select the 'Autoformat as you type' tab, then uncheck 'Internet and network paths as you type' under the 'Replace as you type' section. Click 'Ok' to save the changes.3. Click 'Ok' in the 'Excel Options' window to close it and return to the spreadsheet. Type or paste a URL into a blank cell then hit the space bar or enter key to verify the chang...
How to Turn on Sounds in Excel 2007
1. Click the 'Microsoft Office' button. A list of commands opens.2. Click 'Excel Options.' The 'Excel Options' window opens.3. Click the 'Advanced' tab.4. Scroll down to the 'General' section.5. Check the box for 'Provide Feedback With Sound.'6. Click 'O...
How to Reset the Excel 2003 Application to Default Settings
1. Save and rename your workbook and worksheet settings templates if you want to use them again. Save them in the Templates folder, which is located here: C:\Documents and Settings\user_name\Application Data\Microsoft\Templates.2. Click on your computer's start menu and search for the following in the search dialog box at the bottom of the menu: C:\Program Files\Microsoft Office\OFFICE11\XLSTART. Delete any template files in this folder. If you'd only like to delete workbook settings templates, delete templates with 'Book.xlt.' If you'd only like to delete worksheet settings templates, delete...
How to Make an Excel Chart With a Negative and Positive Axis
Numerical (Value) Axis1. Open the Microsoft Excel 2010 file that contains the chart you want to alter.2. Click anywhere on the chart. Select the 'Format' tab at the far-right end of the ribbon. Click the drop-down box that appears on the far-left end of the ribbon. Select your desired axis from the list. Then, choose the 'Format Selection' button located right below the drop-down box.3. Click the radio button next to 'Fixed' under the 'Minimum' heading. Place your cursor into the text box next to this button and enter the lowest number you want displayed on your axis. Place a dash before...
Tuesday, April 16, 2013
How to Import an Excel Spreadsheet into Another Sheet
Linking1. Launch Microsoft Excel and open the source file that contains the data to be linked.2. Open or create the destination file in which the data will be displayed.3. Navigate to the source spreadsheet and highlight (or 'Select') the cell or range of cells to be imported by clicking the cell, or clicking the top left corner of the range of cells and holding the mouse button down while dragging the cursor to the lower right corner of the range of cells and then releasing the mouse button. Alternately, click the gray button that contains the row number or column letter to select an entire...
Subscribe to:
Posts (Atom)