Saturday, May 25, 2013

How to Open XLS Files in a Microsoft Spreadsheet

Using Excel1. Click the 'Start' button or orb in the lower left corner of your screen, and point your cursor to 'All Programs.' Scroll down, click the 'Microsoft Office' folder, and click 'Microsoft Office Excel.' A blank Excel spreadsheet will open.2. Click the circular Microsoft Office orb on the top left of the spreadsheet. Click the second option, 'Open.' Click the location of your Microsoft Excel spreadsheet on the left side. People usually store documents on their desktop or in the 'My Documents' folder.3. Click the drop-down box on the lower right corner of the dialog box, and click...
Read more ►

How to Not Show MS Excel 2007 Page Breaks

1. Open the Excel 2007 program by double-clicking on the Excel document icon.2. Click on the circular Microsoft Office Button at the top-left corner of the Excel 2007 window.3. Choose 'Excel Options' from the very bottom of the drop-down box that appears. A new window will open up.4. Click on 'Advanced' on the left side of the window.5. Scroll down until you find the 'Display Options for this Worksheet,' which is about half-way down the page.6. Click on the check mark next to 'Show page breaks' to remove it. Page break lines will no longer show up on your workshe...
Read more ►

Friday, May 24, 2013

How to Create a Control Chart in Excel

1. Download a control chart template for Microsoft Excel. A good free template is available from www.vertex42.com/ExcelTemplates/control-chart.html.2. Double-click the downloaded Excel template. The file will open in a Microsoft Excel window.3. Choose the desired control chart format for your project. The two common control chart designs are listed as separate tabs at the bottom of the Excel window. The 'XbarR' worksheet tab creates a control chart for mean and range calculations. The 'XbarS' spreadsheet works with a control chart for mean and standard deviation.4. Click on the control...
Read more ►

How to Link an Excel 2007 Chart to a PowerPoint 2007

Prepare Your Chart in Excel 20071. Open the spreadsheet containing your chart in Excel 2007.2. Click the chart to select it and then press the 'Ctrl' and 'C' keys simultaneously to copy the chart to the clipboard.3. Select a blank sheet using the tabs near the bottom of the Excel 2007 window.4. Press the 'Ctrl' and 'V' keys simultaneously to paste the copied chart into the selected sheet.5. Save the spreadsheet to confirm the changes.Link Excel 2007 Chart in PowerPoint 20076. Open your presentation in PowerPoint 2007 and then navigate to the slide where you want the chart inserted....
Read more ►

How to Filter Data in Microsoft Excel 2007

1. Select the Home Tab on the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.2. Locate the Editing Group on the far right side of the Home Tab. Click on the 'Sort and Filter' button to reveal a drop-down menu of options. Click on 'Filter'.3. Click on the drop-down arrow that Excel added next to the field you would like the data filtered by. Select the choice you would like to see filtered.4. Click on another drop-down menu if you would like to filter the remaining data by an additional criteria.5. Click on the filter icon next to the field header...
Read more ►

How to Remove Certain Colors in Excel 2007

1. Open the Microsoft Excel 2007 document.2. Highlight the cells that you want to remove color from.3. Scroll to the top of the screen and click the 'home' tab.4. Scroll to the right where there are six boxes stacked on top of one another. Click on the box that says 'normal.' This will remove all color and restore the cells back to normal.5. Scroll to the paint-bucket icon.6. Click on it to reveal a drop-down menu.7. Scroll down to where its labeled 'no fill' and click on it. This removes background color.8. Scroll to the icon that is a letter 'A' with a color pallet beneath it.9....
Read more ►

Thursday, May 23, 2013

How to Create a Pivot Table in Excel

Create a Basic Pivot Table From an Excel List1. Ensure your data source contains all data elements you want to include in your report. All data ranges need to have labeled rows, columns and associated data values.2. Select the 'PivotTable and Pivot Report' option from the Data menu. This option launches a wizard to aid you in creating a report.3. Choose the 'Microsoft Office Excel List or database' data source option from the wizard. This option specifies that your data resides in an internal spreadsheet.4. Specify PivotTable as your desired report. This triggers the data range prompt...
Read more ►

How to Create Bins in Excel 2007

Creating Bins in Excel 20071. Click the Microsoft Office link in your start box and click on Microsoft Excel 2007. Microsoft Excel 2007 is the green icon, located among the choices of Microsoft programs.2. Click 'Data Analysis,' located in the analysis group on the data tab. In the dialog box after clicking data analysis, click 'Histogram' and then click OK.3. Type your desired input range in the 'Input Range' box.4. Type your desired range to create a new bin in the 'Bin Range' box.5. Click 'New Workbook' which is located under 'Output Options.' Check the 'Chart Output' check box then...
Read more ►

Wednesday, May 22, 2013

How to Use the Selection Pane in Excel

1. Start Microsoft Excel 2007, and open an existing workbook from your files that contains multiple images that you would like to view with the selection pane.2. Click to select any one of your images so you can gain access to the Format ribbon. You can tell an image is selected, because it will be surrounded by white sizing handles and the 'Format' tab will appear at the top of the Excel screen.3. Select the 'Format' tab to display the Format ribbon. This ribbon displays all the settings you can use to format images in Excel.4. Choose the 'Selection Pane' button in the 'Arrange' section...
Read more ►

How to Write Macros in Excel 2010

1. Open Excel on your computer. Click the 'View' tab on the ribbon and then click the 'Macros' icon.2. Enter a descriptive name for the new macro. Do use spaces in the macro name. Create a sample macro to use during the process of learning to write a macro in VBA. Therefore, enter the macro name 'Change_Worksheet_Names' in the macro name field and then click 'Create.' The Microsoft Visual Basic for Application window opens and displays a 'Module (Code)' window with the blank 'Sub Change_Worksheet_Names()' code document.3. Continue creating the sample macro, which changes all of the generic...
Read more ►

Tuesday, May 21, 2013

How to Insert Error Bars in Excel 2007

1. Open the Microsoft Excel 2007 application that contains the chart that you want to add error bars to.2. Click on the area of the chart where you want to add the error bars. Click on the “Format” tab and then click on the arrow next to the “Chart Elements” box.3. Click on the chart element from the list that you want to add the error bars to. Click on the “Layout” tab and then click on the “Error Bars” option from the “Analysis” group.4. Select the “Error Bars with Standard Error”, “Error Bars with Percentage” or “Error Bars with Standard Deviation” option.5. Click on the “More Error...
Read more ►

How to Paste a Function in Excel 2003

1. Click to select the cell that you want to copy. To select multiple cells, click and drag your mouse to highlight the range or hold down the Ctrl key and click each cell you wish to copy.2. Press Ctrl C on your keyboard to copy the cells, or click 'Edit' and then 'Copy' on the main toolbar.3. Click in the blank cell where you want to paste the formula.4. Right-click, then choose 'Paste Special,' or click 'Edit' and then 'Paste Special' to display the 'Paste Special' dialog box.5. Select the 'Formulas' radio button, then click 'OK.' The formulas or functions are pasted into your ...
Read more ►

How to Add the Microsoft Date Time Picker in Excel 2007

1. Download Microsoft Windows Common Controls-2 6.0 from the Microsoft website.2. Extract the .cab file's contents. Newer Windows versions open .cab files directly. Older versions need extraction software such as WinZip or WinRAR.3. Run the 'mscomct2.bat' file. This installs the Microsoft Date Time Picker.4. In Excel, click the Office button on the screen's top left corner. Select 'Excel Options.' The 'Excel Options' window will open.5. Click 'Popular' from the top of the left column.6. Check the box next to 'Show Developer tab in the Ribbon.' Close the window. Excel's ribbon now...
Read more ►

Monday, May 20, 2013

How to Create Multiple Directories From an Excel Spread Sheet

1. Click on the 'Office' button.2. Mouse over 'Save As.' This displays an options list. Click on the type of file you want to save. For example, 'Excel workbook.'3. Click on the directory you want to save the file in, or click on the 'New Folder' icon to create a new directory. For example, click on 'My Documents' or create a new folder called 'My business tax documents.'4. Enter the name of your file in the 'File name' box.5. Click on 'Save.'6. Repeat steps 1 to 5 to save the file to as many directories as you wi...
Read more ►

How to Record an Excel Macro

1. Open the Tools menu and select Macro, then select Record a Macro.2. Fill in the blanks - the macro name, description, shortcut-key combination and worksheet where the macro will be available - in the Record Macro box that appears. The macro can be available from only one worksheet or from any worksheet.3. Click on OK.4. Notice that the word 'recording' appears in the lower left of the Excel screen while recording is in progress.5. Perform a series of keystrokes or mouse actions. The macro will record them. You can record any normal Excel action.6. Open the Tools menu and choose...
Read more ►

Blogger news