Microsoft Excel 20071. Open Microsoft Excel 2007.2. Select the 'Microsoft Office' button. Click the 'Excel Options' button.3. Select 'Resources' located on the left side. Click the 'Diagnose' button and then click 'Continue.'4. Click the 'Start Diagnostics' button. Office tries to identify your software problem and attempts to repair any problems. Click 'Close' when the diagnostics are complete. If Microsoft Diagnostics cannot fix the problem, repair the software through the Control Panel.Control Panel5. Open the 'Start' menu. Choose 'Control Panel' from the menu. Click the link to 'Uninstall...
Browse » Home » All posts
Friday, October 11, 2013
How to Calculate a Date in Excel
1. Populate today's date with the Today function. Type '=TODAY()' in a blank cell to return today's date. The Now function returns the date and the time stamp: '=NOW()'.2. Calculate a future date by entering a date in a cell. Click on an empty cell and type '=cell reference number of days' where cell reference refers to the date that was entered and the number of days should be substituted for the actual number of days you want to calculate. For example, if we enter 5/22/2009 in cell A1 and want to know what the date will be in 21 days, the formula would be '=A1 21', which returns 6/12/2009.3....
How to Learn Basic Microsoft Excel
1. Learn Excel online through the Microsoft Office website, which includes Excel tutorials for all levels. Click the 'support' tab at the top of your page and select 'Excel' from the drop-down list. Select the Excel version you want to learn from the right and click 'Getting started.' Pick a topic -- such as 'Basic tasks in Excel 2010' -- that interests you. (see References)2. Learn how to complete basic tasks in Excel through video tutorials at Microsoft Office. Click the video that interests you, such as 'Video: Getting Started with Excel 2010,' 'Video: Create a workbook,' or 'Video: Print...
How to Embed a PDF File in Excel
1. Select the cell in your Excel spreadsheet where you wish to embed a PDF. The PDF file will take up more than just one cell; select the cell you want the top left-hand corner of the file to appear. Click on the 'Insert Object' button in the Text group under the Insert tab. Highlight 'Adobe Acrobat Document' under Object type in the Object pop-up window .2. Decide how you want your PDF to appear in your Excel document. If you want the PDF to appear as the first page of the PDF, simply click the OK button. If you want the PDF to appear as an icon, click the check mark labeled 'Display as...
Saturday, September 28, 2013
How to Unlock a Chart in Excel
1. Open Excel 2010 and the chart that is locked.2. Click 'Unprotect Sheet,' which is located in the 'Changes' grouping on the 'Review' tab along the toolbar.3. Enter the password to the chart if you are asked to provide one and click 'OK.' If you didn't create the chart or set the password, speak to the person who d...
How to Do an OHLC Chart in Excel
1. Open the Excel worksheet.2. Type the data with four series of values in this order: open, high, low and close. For example, row 1 can include the five column headers: “Date,” Open,” “High,” “Low” and “Close.”3. Click and drag the cursor to select the categories and data values you wish to convert to a chart.4. Click the “Insert” tab on the command ribbon.5. Click the arrow for the “Other Charts” button in the “Charts” group. A gallery of thumbnail images for charts and subtypes displays.6. Click the “Open-High-Low-Close” image link in the “Stock” section. The “Open-High-Low-Close”...
How to Import XML to XL
Import XML Data as an External File1. Open Microsoft Excel. Click on the 'Data' tab and locate the 'Get External Data' group. Click on the icon for 'From Other Sources' and select 'From XML Data' from the drop-down menu.2. Locate the XML data file. Select the file name and then click on 'Open' in the lower right hand corner of the current dialog box. The 'Import Data' dialog box will appear.3. In the 'Import Data' dialog box, specify whether to import the data as an XML table in a new worksheet, XML table in an existing worksheet, or whether to flatten the data into a two-dimensional table...
Friday, September 27, 2013
How to Change Default Colors in Excel
Adjust the Color in a Worksheet1. Change the font color. Click on one cell to select it or click on the first cell in a group and drag the mouse to highlight all the cells. You can also click on the gray box at the top left corner of the worksheet to select all the cells on the page.2. Click on the 'Font Color' button on the tool bar. Click to select one of the standard colors displayed on the palette. The font color button has an 'A' on it, with a bar of the current font color underneath the A.3. Change the background color of a cell. Highlight the cell or cells you would like to adjust...
Thursday, September 26, 2013
How to Unsync Split Pane in Excel
1. Open the spreadsheet that has the split screens.2. Click the 'Synchronous Scrolling' button in the 'Window' group on the 'View' tab.3. Close the split panes by clicking on the 'Close' button in the upper-right corner of the pane. Repeat this step until only one pane remains open.4. Click the 'Maximize' button in the upper-right corner of the pane.5. Click the 'Save' button on the 'Quick Launch' toolbar to save the chang...
How to Replace Blank Cells With Value in Excel 2003
1. Select the range of cells that contain the blank cells you want to replace. Do this by clicking on the uppermost cell on the left side, then drag the cursor down to the right until the last cell of the range is highlighted. Not all of the cells in the range have to be blank.2. Go to 'Edit' on the menu bar and select 'Replace.' A pop-up menu will appear.3. Leave the 'Find what' box blank to search for blank cells.4. Enter the value you want to replace the blanks with in the 'Replace with' box. For example, if you want '4' to replace all the blank cells, type '4' (no quotation marks).5....
How to Create a Pivot Table in Excel 2003
1. Create a spreadsheet in Excel with all of the data you want to place in your PivotTable.2. Open a new a workbook for your PivotTable report.3. Click on 'Data' in the menu bar, and then 'PivotTable and PivotChart Report.' This launches the PivotTable and PivotChart Wizard.4. Select the option to use data from one Excel list or database. Click 'PivotTable.'5. Select your data range. This is the actual data for your PivotTable. Click on the 'Browse' button and select the file and datasheet for your PivotTable. Click 'Finish.'6. Drag your fields from the PivotTable Field List into the...
How to Use the Auto Filter in Microsoft Excel 2003
1. Highlight the cells and columns you wish to apply the auto filter to. Click and hold the mouse button in as you scroll the cursor over the desired groups of cells and columns, release the mouse button and they will remain highlighted.2. Apply the auto filter. Scroll to “Data” and select “Auto Filter” from the submenu. Downward arrows will appear over all the columns you highlighted, from the top portion of the highlighted columns.3. Filter the data as desired. Click on any down arrow to filter data in that column. When you click on the arrow a submenu will open. You can filter data by...
How to Move the Excel 2007 Pivot Table Field List
1. Open the Microsoft Excel 2007 application on your computer. Click on the 'Microsoft Office' button and the select the 'Open' option.2. Locate the Excel 2007 file that contains the PivotTable that you want work with and then click on the 'Open' button to load the file onto your spreadsheet.3. Click on the 'Options' tab if you don't see the PivotTable Field List after you've clicked on your PivotTable. Click on the 'Field List' option from the 'Show/Hide' group.4. Locate the layout section at the bottom of the Field List and then click on the 'Move Up' option to move any select field...
How to Set Excel Macro Security to Medium
1. Open Microsoft Excel. Go to Start–Programs–Microsoft Office–Microsoft Office Excel. Please note that in some versions of Microsoft Office, you will Microsoft Office Excel straight from Programs.2. Go to the Tools menu at the top of your Excel window.3. Open the Tools menu and go to Macros.4. Choose Security from the Macros menu.5. Choose Medium from the Security Level tab. You also have the options of Very High, High, and Low. For most users High or Medium is best.6. Click the OK button and restart Excel by closing the program and re-opening it. Your macro security level is...
Wednesday, September 25, 2013
How to Restore MS Excel Toolbar
1. Access the toolbar setting in Microsoft Excel 2008 by going to the “View” menu and selecting “Customize Toolbars and Menus.”2. Restore the toolbars by clicking the boxes next to the toolbar names. The most commonly used toolbars are the “Standard” and “Formatting” toolbars. If you want these toolbars to appear at the top of the document, click the “Dock” option for each one.3. Press “OK” to complete to process and return to your docume...
Subscribe to:
Posts (Atom)