Thursday, May 16, 2013

How to Format Data Labels in Excel

1. Launch 'Microsoft Excel' by double clicking the program's shortcut on the desktop, or by selecting 'Microsoft Excel' from the 'Programs' or 'All Programs' menu.2. Click 'File' or the 'Office Button' in the upper left corner of the program window and select 'Open.' Click on the downward pointing arrow to the right of the 'Look in' text box, and navigate to your Excel file. Select the file and click 'Open' or double click the file to open it.3. Go to step 4 if you have Excel 2007; otherwise select the chart with the data labels you want to format. Click 'Chart' on the menu bar and select...
Read more ►

How to Graph a Normal Distribution Curve in Excel 2007

1. Enter the number -4 into cell A2.2. Select the cell with your mouse. Click on the down arrow under 'Fill' in the Editing group to the far right on the ribbon (the toolbar). Choose 'Series.' A pop-up will appear.3. Click on the radio buttons to choose 'Columns and Linear.' Type .25 into the 'Step Value' box and 4 into the 'Stop' box. Press 'OK.' This should fill column A with the x-values for the normal distribution.4. Type =NORMDIST(A2,AVERAGE($A$2:$A$34),STDEV($A$2:$A$34),FALSE) into cell B2. This calculates the mean and standard deviation from your x-values and also creates your first...
Read more ►

How to Compare Data in Excel with VLOOKUP

1. Open the Excel 2010 spreadsheet that contains that data you want to compare. Click on the top cell of the first empty column in your spreadsheet.2. Enter the following formula into the cell:=vlookup(A1,B:B,1,False)Change 'A1' to the top cell in the first column of data. Change the 'B's in 'B:B' to the letter of the column where the second set of data is located. Keep the '1,' as this tells VLOOKUP that you want to check the first column in the 'B:B' range. 'False' specifies that you want to search for an exact match, instead of an approximate one.3. Press 'Enter' to complete the formula...
Read more ►

Wednesday, May 15, 2013

How to Create and Name an Excel 2007 File

Create New File Instructions1. Open the 'Start' menu and type 'Excel' into the search box.2. Click the 'Windows Office' icon in the top left corner of the Excel 2007 menu bar.3. Click the 'Blank Workbook' in the 'New Workbook' window, then click the 'Create' button.4. Click on the 'Microsoft Office' icon and select 'Save.' Create a name for your spreadsheet and ensure that the 'Save as type:' menu is set as 'Excel Workbook (*.xlsx).'5. Click 'Save' in the 'Save As' window to save the new Excel 2007 file.Existing Data Instructions6. Open the 'Start' menu and type 'Excel' into the search...
Read more ►

How to Calculate Pearson's R (Pearson Correlations) in Microsoft Excel

1. Put the values of the two variables you wish to correlate into two columns of the same length. For example, say you have data about the heights and weights of 50 people, and want to calculate the Pearson correlation between the two. Put the data into two columns: the heights in cells 1 to 50 of column A, and the widths in cells 1 to 50 of column B.2. Select an unused cell and type '=CORREL(' (without the quotes). After typing the first open parentheses, select all of the cells in your first column, type a comma, select all of the cells in your second column, and type the closing parentheses...
Read more ►

How to Remove Hidden Macros in an Excel Spreadsheet

1. Double-click the Microsoft Excel document you want to edit. This opens the document and loads the Excel application.2. Click the 'View' menu option and select 'Unhide.' In the section labeled 'Personal,' select 'Unhide workbooks' from the list of options.3. Click the 'Developer' tab at the top of the Excel window. If you don't have the Developer tab, click the Office button and select 'Excel Options.' Click the 'Popular' tab and select 'Show Developer tab in the Ribbon.' Press the 'OK' button.4. Click the 'Macros' button in the 'Developer' tab. A pop-up window opens with a list of macros...
Read more ►

How to Create Sequences in Excel

1. Click the first cell in the row or column that you want to contain the sequence and type the first item. For example, to create the sequence of 'Red,' 'Green' and 'Blue,' type the word 'Red.' Press 'Enter' to move to the next row or press the right arrow key to move to the next column.2. Type the next item in the sequence, such as 'Green.' Press 'Enter' or the right arrow key.3. Type the next item in the sequence, such as 'Blue.' Repeat this process until you have typed every item in the sequence.4. Click and drag with the mouse pointer to highlight the cells containing the complete...
Read more ►

How to Open Large Files in Excel 2003

1. Launch Excel, and navigate to the 'tools' menu.2. Choose the 'macro' submenu, and select the Visual Basic editor.3. Choose 'module' from the insert menu.4. Copy and paste the following text:Sub LargeFileImport()'Dimension VariablesDim ResultStr As StringDim FileName As StringDim FileNum As IntegerDim Counter As Double'Ask User for File's NameFileName = InputBox('Please enter the Text File's name, e.g. test.txt')'Check for no entryIf FileName = '' Then End'Get Next Available File Handle NumberFileNum = FreeFile()'Open Text File For InputOpen FileName For Input As #FileNum'Turn Screen...
Read more ►

How to Use the Conditional Sum Wizard in Excel

1. Open the file that contains that data that you need to run the conditional sum wizard on.2. Add a header row to your data, if it lacks one, by right-clicking on the number next to the first row and choosing 'Insert.' Type in names for the columns in the cells directly above the data.3. Click on the top-left cell of the data range. Move to the bottom-right cell in the data range. Press and hold the 'Shift' button and click on the cell to select the entire data range.4. Click the 'Formulas' tab at the top of the screen, then click on the 'Conditional Sum' button located on the far right...
Read more ►

Tuesday, May 14, 2013

How to Create a Macro to Run an Access Query Paste the Result Into Excel

1. In Access, create a table of sample data: enter the following data in a new table:the accidental tourist,12/1/2009,$6.01the accidental tourist,12/3/2009,$7.98iron john,12/5/2009,$4.98iron john,12/6/2009,$5.982. Double-click the column headers (e.g. 'Field1') and replace each with these headers, in this order:book,datesold,netsaleSave the table ('control-s') with the name 'books.'3. Create a query from the table, and press the 'Esc' key in the 'show table' dialog box. Right-click on the query's tab and select 'SQL view.' Enter the following in the code window:SELECT books.* INTO queryresultsFROM...
Read more ►

How to Create a Newsletter in Microsoft Office

1. Open Microsoft Word, and select a newsletter template by clicking the drop-down menu File > New Works Template > Tasks. Additional templates may be downloaded from the Microsoft Office Online website.2. Create a nameplate for your newsletter. Using Word's 'header' is the simplest way to do this. Select View > Header and Footer from the drop-down menu to edit text boxes within the header and footer. Center your newsletter's title and add clip art, if desired, selecting Insert > Picture > Clip Art from the drop-down menu. If the software is available, you may use Copy and...
Read more ►

How to Use VLookup in Excel 2003

1. Open the Excel 2003 file that contains the data table that you want to work with.2. Select the top-left cell of the data table and hold down the mouse button. Move the mouse to the bottom-right cell and select it. Click the 'Data' menu at the top of the screen and select 'Sort.' Select 'Ascending' to sort the information from smallest to largest. The first column has to be sequential in order for VLookup to work.3. Select any cell outside of the data table. Press the '=' key to start your formula. Type 'vlookup('. The open parenthesis is required to begin entering arguments.4. Type...
Read more ►

How to Remove Checkboxes in Excel 2007

1. Open Microsoft Excel 2007.2. Click the 'File' tab, click 'Open' and browse to the spreadsheet with the check boxes to delete. Double-click the name of the file to open it.3. Click once on the first check box to remove. Press the 'Delete' key to remove it. Scroll throughout the spreadsheet or page tabs at the bottom of the work area and continue clicking and pressing the 'Delete' key to remove the check box...
Read more ►

Monday, May 13, 2013

How to Make a Pivot Table in Excel 2007

1. Open the Microsoft Excel spreadsheet program. Click 'Start' on the main operating system menu. Then choose 'Programs' and from the program menu select 'Microsoft Excel.'2. Choose a cell in a Microsoft Excel spreadsheet. Make certain the call range has a column heading. From the main tab menu, select the 'Insert' tab, then in the table menu click on 'Pivot Table.'3. Select the data range to be analyzed. A user can either select a range of data in the current spreadsheet or choose data from an external source. Also, determine if the pivot will appear in the current worksheet or in a new...
Read more ►

Sunday, May 12, 2013

How to extend the Microsoft Office 2010 trial

1. Install the Office 2010 trial of your choice. Wait until the end of the initial 30 days to complete the rest of the steps. Office will have a pop-up reminder when the trial is about to expire.2. Run the command prompt as an administrator. To do this in Windows 7, go to the Windows orb logo (formerly the 'Start' menu). In the search field, type 'cmd' and then press the 'Ctrl' 'Shift' 'Enter' keys together. Click 'Yes' if prompted by the User Account Control.3. Enter 'C:\Program Files\Common Files\Microsoft shared\OfficeSoftwareProtectionPlatform\ OSPPREARM.exe' into the command prompt...
Read more ►

Blogger news