Friday, April 20, 2012

How to Manipulate Data in an Excel 2007 Pivot Table

1. Open Excel 2007 and select a workbook containing data. Click the 'Office' button and select 'Open.' Browse your files and select the workbook. Click the 'Open' button to open the workbook.2. Highlight the data you want included in the PivotTable. Select 'Insert' on the menu bar, and then select 'PivotTable.' A drop-down menu appears. Select 'PivotTable' again. Click 'OK.'3. Add fields to the PivotTable by checking fields from the right 'PivotTable Field List.' By default, the fields appear in the column section. Manually drag the fields to any of these sections (row, totals or filter)...
Read more ►

How to Convert Excel Time Difference to Decimal Number

1. Click a cell where you want the decimal representation of the time difference to appear.2. Type '= A1 * 24' and then press 'Enter.'3. Change the cell location 'A1' to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type 'C3' into the formula instead of 'A1.' Pressing 'Enter' for this result will give you the decimal result '1.2...
Read more ►

How Do I Graph on a Secondary Axis in Excel Office Professional 2003?

1. Click on the data series on the chart that you want to plot on a secondary axis. For example, if you have a chart that shows price and volume and you want to display volume on a secondary axis, then click on 'volume.'2. Click on 'Selected Data Series' on the Format menu.3. Click on the 'Axis' tab, then click on 'Secondary axis.' Excel inserts a secondary axis into your workshe...
Read more ►

How to Create a Pivot Table from Multiple Worksheets

1. Open the workbook in which you want to create the PivotTable.2. Click 'PivotTable and PivotChart Report' on the 'Data' menu.3. Follow the instructions in the wizard. For the first step, you will be asked to identify the source for your data. Click the black box on the right-hand side of the source data box. This will disconnect the source box from the wizard.4. Select the data ranges in the worksheets you need data from. Start with the first range and then move on to the next. The wizard will automatically put a comma between each range of data you select.5. Click the black box on...
Read more ►

Wednesday, April 18, 2012

How to Calculate Days by Subtracting Two Dates in Excel

1. Launch Microsoft Excel and open a new worksheet. Type the date in one cell. For example, type '1/1/2010' in cell A1.2. Type your first date in cell A1. For example, input the date '1/1/2010.'3. Type your second date in cell B1. For example, input the date '3/14/2011.'4. Select the cell C1, type '=' and click the date in cell B1. Then type '-', click the first date and press 'Enter.' Cell C1 now shows 438, the number of days between the two dates you inp...
Read more ►

How to Create an Application in Word or Excel

Create an Application in Word1. Start Microsoft Word. In Word 2003, go to the 'File' menu and click 'New.' In Word 2007, click the 'Office Button' and click 'New.'2. Type 'Employment Application' in the 'Templates on Office Online' box and click the 'Search' button. Select 'Employment Application 2-pp Online Form' in the 'Search Results' list. Click the 'Download' button, and an application will open as a new Word document.3. Enter your company logo by selecting 'Your Logo Here.' Go to the 'Insert' menu in Word 2003, point to 'Picture' and click 'From File.' In Word 2007, go to the 'Insert'...
Read more ►

How to Change Macro Security Settings on Windows Vista

Changing Macro Security in Word or Excel 20071. Click the circular Office logo in the upper-left corner of the Word or Excel window, then click the 'Word Options' or 'Excel Options' button at the bottom of the menu.2. Click the 'Trust Center' link on the left side of the screen, then click the 'Trust Center Settings' button.3. Click the 'Macro Settings' link on the left side of the window to access the macro settings for the Office 2007 program you are using. The menus for Word 2007 and Excel 2007 are the same. The default selection is 'Disable all macros with notification.' To run your...
Read more ►

How to Keep Track of Changes in an Excel Document

Tracking Changes1. Start Microsoft Excel and open the file you want to change.2. Open the Tools menu and select Track Changes, then Highlight Changes.3. In the Highlight Changes dialog box, select 'Track changes while editing.'4. Select 'Highlight changes on screen.'5. Open the When menu and select All.6. Open the Who menu and select Everyone.7. Click OK.8. Click OK. This will save your changes and your file/workbook.9. Enter your new changes.Accepting or Rejecting Changes10. Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.11. In the...
Read more ►

Tuesday, April 17, 2012

How to Unfreeze a Window Pane in Excel 2007

1. Select the 'View' tab from the top menu in Microsoft Excel 2007.2. Go to the 'Window' menu ribbon. Select 'Freeze Panes.'3. Choose 'Unfreeze Panes' from the pop-up menu to unfreeze your Excel spreadshe...
Read more ►

Monday, April 16, 2012

How to Install Office 2000 on Excel 2007

Installing Office 2000 without Excel 20001. Insert your Office 2000 installation CD. A dialog box should open.2. Provide details about your name and organization as well as the 25-digit CD key to continue the installation process, then select the 'Next' button. You will be redirected to another dialog box containing the Office 2000 End-User License Agreement; read it. If you agree, select the 'I accept' option, then click 'Next' to continue with the installation process.3. Select 'Customize' as your installation type, then select all Office 2000 component programs except Excel 2000.4. ...
Read more ►

How to Make a Cell Required in Excel 2007

Making Cells Required to Print Spreadsheet1. Open Excel 2007. Check for the 'Developer' tab in the ribbon across the top of the screen. If you do not have the 'Developer' tab activated, click the round blue 'Microsoft Office' button in the top left corner. Click 'Excel Options' followed by 'Popular.' Check the box for 'Show Developer Tab in the Ribbon,' and then click 'OK.'2. Click the 'Developer' tab, and then click the 'View Code' button under the 'Developer' menu. This will open Microsoft Visual Basic.3. Copy and paste the following code into the blank window:[vba]Private Sub Workbook_BeforePrint(Cancel...
Read more ►

How to Build Pivot Tables in Excel 2007

1. Open Excel and open a spreadsheet on your computer that has data in at least 5 columns and 10 rows. Make sure this data has column headers.2. Press 'Control' and 'A' to select all of the data in your spreadsheet. Click on the 'Insert' tab on the ribbon and select 'PivotTable.' Select 'PivotTable' again. Excel will open the Create PivotTable dialog box. In the section titled 'Choose the data that you want to analyze,' choose 'Select a Table or Range.' In the section titled 'Choose were you want the PivotTable report to be placed,' choose 'New Worksheet.' Click 'OK.' A new worksheet...
Read more ►

Sunday, April 15, 2012

How to Use Page Orientation on Excel 2007

Selecting Page Orientation1. Open Microsoft Excel 2007.2. Click the 'Page layout tab.'3. Click 'Page setup.'4. Click 'Orientation' and click either 'Landscape' or 'Portrai...
Read more ►

How to Merge Cells in a Shared Workbook

1. Navigate to the location of the shared workbook on your computer.2. Double-click on the workbook to open it.3. Click the top left cell that is going to be part of your cell merge, then drag the mouse pointer until all of the desired cells have been selected.4. Right-click anywhere in the highlighted area of cells, then select the 'Format Cells' option.5. Click the 'Alignment' tab, then check the box next to 'Merge cells.'6. Click the gray 'OK' button to close the wind...
Read more ►

How to Write Macros in Excel 2007

1. Make the 'Developer' tab of the ribbon visible. Click the 'Office Button' and select 'Excel Options.' Select 'Show Developer Tab in the Ribbon' in the 'Popular' category. Click 'OK.'2. Enable macros. Go to the 'Developer' tab. Click 'Macro Security' in the 'Code' group. Select 'Enable All Macros' and click 'OK.'3. Click 'Visual Basic' in the 'Code' group. The 'Microsoft Visual Basic for Applications' window opens. Go to the 'Insert' menu and select 'Module' to open a new module.4. Type or paste the macro that you want to use in Excel 2007. Press the 'F5' key to run the macro and ensure...
Read more ►

Blogger news