How to Perform Factor Analysis

Performing a Factor Analysis
1.
Generate a correlation matrix on the data set. A correlation matrix is a table of correlation coefficients. A correlation coefficient is the quantifying unit of correlation. This number expresses the direction and strength of a linear relationship measured between two random variables.
2. Establish baselines for desired factors (compiled variables). For example, if the data collection instrument is a survey and responses are measured from 1 -- Least Desirable Outcome to 10 -- Most Desirable Outcome, values of 8, 9 and 10 may be examined and the corresponding variables grouped according to similarities to create factors.
3.
Rotate factors to maximize the linear relationships between factors and variables. For this function, the statistical application demonstrates its value. The number of manual calculations required would be massive on a large data set.
4.
Generate and print the Output report. The Output report will include the following sections: Descriptive Statistics, the Correlation Matrix, Kaiser-Meyer-Olkin and Bartlett's Test, Communalities, a Scree Plot, a Factor Matrix and a Rotated Factor Matrix.
5.
Interpret the output from the statistical application based on intuitive knowledge of the data and empirical questions to be answered.

Read more ►

How to Change an Excel Spreadsheet Into an Interactive PDF

1. Open Adobe Acrobat on your computer. In the 'Getting Started' window, click 'Convert an Existing Document' to launch the 'Create New Forms' wizard. Alternately, you can select 'Create New Form' from the 'File' menu or the 'Forms' menu. In Acrobat 9, click 'Forms' and select 'Start Form Wizard.'
2. Select 'An Existing Electronic Document.'
3. Follow the on-screen instruction to upload the data from your spreadsheet file. The wizard will be slightly different depending on the version of Acrobat you are using. Make sure your spreadsheet is saved in a place where you can access it.
4. Proceed through the instructions to create Acrobat form fields. If the wizard doesn't prompt you, click the 'Forms' menu and select 'Edit Form in Acrobat.'
5. Select a forms tool such as the 'Select' tool in the Forms toolbar. Drag the cursor to create rectangular form field. A 'Properties' dialog box will open for the form field, in which you can set up the form field behavior. Repeat this for each form field you need to create.
6. Save the interactive form under the 'File' menu.

Read more ►

How to Create an Organization Chart From Excel

1. Open a new document in Microsoft Excel 2007 and click on the 'Insert' tab.
2. Click on 'SmartArt'. In the 'Choose a SmartArt Graphic' window, click on 'Hierarchy'.
3. Select the first chart, which is the Organization Chart. Click OK.
4. Begin typing the name of the first person at the highest level in the organization such as the CEO in the 'Type your text here' window. Click on the indented text areas to add names for the rest of the employees. You can add additional boxes by pressing Enter in the 'Type your text here' window at the desired position.

Read more ►

How to Include Indian Currency as Part of the Currency Symbols in Excel

1. Open a Web browser, and navigate to the download page for the Windows Rupee symbol update (support.microsoft.com). Click the download link next to the version of Windows that you have installed.
2. Click the 'Continue' button on the next page. Click 'Continue' again, and save the file 'GenuineCheck.exe' to the desktop. Run the tool, and copy the code displayed into the field under 'Enter your validation code' on the Microsoft Genuine Windows Validation page. Click 'Validate.'
3. Click the 'Download' button, and save the Rupee symbol update to the desktop. Double-click the update file -- depending on the version you downloaded, one possible file name is 'Windows6.0-KB2496898-.msu' -- and wait for the update to complete. Click the 'Restart Now' button to restart your computer.
4. Launch Excel 2010, and click the 'Home' tab in the upper-left corner of the main window.
5. Click the drop-down menu next to the Dollar sign in the 'Number' section of the top toolbar, and then click 'More Accounting Formats.' A new window titled 'Format Cells' appears. Alternatively, select the row or column containing Rupee values, right-click the highlighted cells and select 'Format Cells' to reach this window.
6. Click the drop-down menu next to 'Symbol' and select the Rupee symbol, which should now appear near the top of the list.
7. Click 'OK.' Excel now displays the Rupee symbol next to currency values.

Read more ►

How to Make Everything Uppercase in Excel

1. Open the Excel worksheet.
2. Press Alt and F11 to bring up the Excel 2010 VBA console. Once the console opens, find the name of your workbook on the list on the left side of the screen. Right-click the workbook name, move your mouse over 'Insert' and select 'Module.' Double-click the module that appears.
3. Click anywhere in the blank white space on the right side of the VBA console. Type in the following: 'Sub UpperCaseConvert()' and press Enter. VBA will automatically insert the 'End sub' command at the bottom of the code.
4. Type 'Dim x As Range' into the line directly beneath the 'Sub' line. This will create a variable, 'x,' that you will need later in the VBA code. Press Enter to access the next line.
5. Enter the following code into the VBA console:For Each x In Cells.SpecialCells(xlConstants, xlTextValues)x.Formula = UCase(x.Formula)NextThis will go one-by-one through every cell that contains text on your worksheet and convert it to uppercase. Click the 'X' in the top-right corner of the VBA console to close it.
6. Click the 'Developer' tab at the top of the Excel screen. Click the 'Macro' button, which is located in the 'Code' area of the ribbon. Select 'UpperCaseConvert' from the list of macros and click 'Run.'

Read more ►

How to Make a Checklist in Microsoft Word 2003

1. Create your list entries. Create the desired entries of the list and click the “Return” key after making each individual entry.
2. Highlight the entries. Left-click and hold the mouse button in as you drag the cursor over all of the entries that you just created. Then release the mouse button and the entries will remain highlighted.
3. Create the checklist. On the font formatting toolbar, found on the command bar, you will see several icons that allow for font formatting, billet points and list creation. The list creation icon appears as the numbers 1 through 3 and each number has a line next to it, sequentially from top to bottom of the icon. Click on this icon to create the checklist.
4. Remove the checklist number formatting. To remove the checklist that you just created, follow Step 2 to highlight the list and then simply click on the list icon, as demonstrated in Step 3, and the list will be removed.

Read more ►

How to Turn off Gridlines in Excel

1. Launch Excel by clicking on the 'Excel' shortcut in your Windows Start Menu.
2. Open the worksheet for which you want to disable gridlines by clicking on the 'Excel' icon and selecting the 'Open' command.
3. Click on the 'View' tab and de-select the 'Gridlines' check box under the 'Show/Hide' category.

Read more ►

How to Go to Precedent Worksheets in Excel

Enable the Display Options
1. Open the saved Excel worksheet.
2. Click the 'File' tab on the command ribbon. A list of commands will appear.
3. Click 'Options.' The 'Excel Options' dialog box will open.
4. Click the 'Advanced' button on the left pane. The 'Advanced' pane will appear.
5. Scroll down the right pane to the 'Display' section.
6. Select the named workbook in the 'Display Options for This Workbook' text box.
7. Select the radio button for 'All' in the 'For Objects, Show' option.
8. Open another workbook if it contains the formula's reference cells. An open workbook makes the cells accessible for the 'Trace Precedents' option.
9. Click 'OK.' The 'Excel Options' dialog box will close.
Apply the Trace Precedents Command
10. Click and drag on the cell that contains the formula. The selected cell will appear highlighted. The formula will appear in the Formula Bar.
11. Click the 'Formulas' tab.
12. Click the 'Trace Precedents' button in the 'Formula Auditing' group. Tracer arrows will appear superimposed on the cells. Blue arrows indicate no errors. Red arrows indicate cells that cause errors. A black arrow points to a worksheet icon if the selected data cell is referenced by another worksheet's cell.

Read more ►

How to Use VBA to Import Data From Excel Into Access

1. Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.
2. Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel
Object Library.'
3. Start by typing the following VBA code to create new sub procedure:Private Sub importExcelData()
4. Type the following to create variables you will use to read Excel:Dim xlApp As Excel.ApplicationDim xlBk As Excel.WorkbookDim xlSht As Excel.Worksheet
5. Type the following to create variables you will use in Access:Dim dbRst As RecordsetDim dbs As DatabaseDim SQLStr As String
6. Type the following to define database objects and also define the Excel workbook to use:Set dbs = CurrentDbSet xlApp = Excel.ApplicationSet xlBk = xlApp.Workbooks.Open('C:\Temp\dataToImport.xlsx')Set xlSht = xlBk.Sheets(1)
7. Create a new table with two columns in Access to import data from Excel. Type the following VBA code to create the table using the 'DoCmd' object:SQLStr = 'CREATE TABLE excelData(columnOne TEXT, columnTwo TEXT)'DoCmd.SetWarnings FalseDoCmd.RunSQL (SQLStr)
8. Open the table you just created by using a the Recordset object. Type the following to open the table and add a new row:Set dbRst = dbs.OpenRecordset('excelData')dbRst.AddNew
9. Type the following to get values from the Excel workbook, save them to your table and update the record:xlSht.Range('A2').SelectdbRst.Fields(0).Value = xlSht.Range('A2').ValuexlSht.Range('B2').SelectdbRst.Fields(1).Value = xlSht.Range('B2').ValuedbRst.Update
10. End your procedure by typing the following VBA code:dbRst.Closedbs.ClosexlBk.CloseEnd Sub
11. Press 'F5' to run the procedure. The data in your Excel workbook has just been imported into your Access table.

Read more ►

How to Open Excel 2007 Without a Blank Document

1. Click on the 'Microsoft Office' button.
2. Click on 'Excel Options.' The Excel Options dialog box will open.
3. Click on the 'Advance' tab, then scroll down to 'General.'
4. Type the name of your file location in the 'At startup, open all files in:' text box. For example, type 'C://MyDocuments/myfile.xls.'
5. Click on the 'OK' button. The next time you open Excel, the selected files will open automatically.

Read more ►

How to Use Calendar Control in VBA Excel

1. Start Microsoft Office Excel, select the 'Developer' tab then click 'Visual Basic.' Click the 'Insert' menu and select 'UserForm.'
2. Right-click the 'Toolbox' menu and select 'Additional Controls...'. Check the box next to 'Calendar Control 12.0' then click 'OK.'
3. Click the calendar control and add it to 'UserForm1.' Click the 'CommandButton' control and add one to your 'UserForm1.' Double-click the 'CommandButton1' to open Microsoft Visual Basic.
4. Copy and paste the code below inside the 'CommandButton1_Click()' subroutine.Dim dataString As StringdataString = Calendar1.ValueActiveCell = dataStringActiveCell.NumberFormat = 'mm/dd/yy'
5. Press 'F5' to run the program then click 'CommandButton1.' The program will get the calendar date chosen by user and will add it to the active cell in the Excel spreadsheet.

Read more ►

How to Find Hidden Columns in Excel 2007

1. Inspect the column headers at the top of the Excel 2007 spreadsheet. The headers are gray and are labeled with letters in consecutive alphabetical order. Note which letters are missing from the headers. These missing letters indicate which columns are hidden.
2. Reveal single or consecutively hidden columns by clicking on the two columns that would be on either side of the hidden columns. For example, if column 'B' is missing (hidden), you will click on columns 'A' and 'C' to select them. To continue that example, if columns 'B' through 'F' are hidden, you will click on columns 'A' and 'G' to select them. Be sure to click on the actual gray column header to select the complete column rather than a specific cell within the column.
3. Click the 'Home' tab if you are not already on that tab. Then click the 'Cells' group to show the drop-down menu. Click the 'Format' button, which will reveal another drop-down menu. On this new menu, scroll down to the 'Hide Unhide' option (under Visibility). This will reveal one more menu that contains the options to 'Unhide Rows' and 'Unhide Columns.' Select 'Unhide Columns.' Your missing columns will be revealed.
4. Alternatively, you can follow Step 2 to select the two columns adjacent to your hidden columns and then right-click to reveal a shortcut menu. Click 'Unhide' on that menu to reveal the hidden columns.

Read more ►

How to Highlight Changes in Microsoft Excel 2003

1. Access the highlight menu. To access this menu, scroll to the “Tools” tab and select “Track Changes.”
2. Open the Highlight Changes Options menu. Under the submenu that opens scroll to “Highlight Changes” and left-click to access the 'Highlight Changes' menu. Make sure to check the box labeled “Track Changes While Editing.”
3. Set up the “When” attributes. By checking this box, you can access a dropdown menu where you can choose from the following: All (which will track changes by everybody), Since I Last Saved (which will track changes from your last save), Not Yet Reviewed (which will track all changes that have yet to be reviewed by you) and Since Date (which will track changes since a certain date you enter.)
4. Set up the “Who” attributes. Under this box you can choose to track changes by Everyone or by Everyone But Me (which will track all other user changes but yours) by selecting the desired attribute from the dropdown menu.
5. Set up the “Where” attributes. Under this selection, you can enter a span of cells, rows, columns, or all three, by entering their corresponding data into the field provide, which will track all changes made to the specified cells, rows or columns.
6. Set the screen options. If you wish to see the changes tracked on-screen and highlighted, check the box labeled “Highlight Changes on Screen.”
7. Implement the changes. To implement your changes click on the “Okay” button.

Read more ►

How to Find the Author of an Excel Document in 2007

1. Open the Excel document in Microsoft Excel 2007.
2. Click the top left 'Office' button, select 'Prepare' and click 'Properties.'
3. Look at the top left 'Author' field of the 'Document Properties' panel that appears just above your spreadsheet. This field lists the author of the Excel document.

Read more ►

How to Insert a Cell Drop

Microsoft Excel 2003
1. Open the Microsoft Excel 2003 application on your computer. Enter the data you want for your drop-down box into a single column of your spreadsheet.
2. Click on the cell where you want the drop-down list to begin so that it’s selected. Click on the “Data” option from the top toolbar menu.
3. Click on the “Validation” option and then click on the “Settings” tab. Click on the “List” option from the “Allow” box.
4. Enter the reference for all of the cells to be used in the drop-down list into the “Source” box. Click on the box next to the “In-cell drop-down” field so that it’s selected.
5. Change any other drop-down settings to meet your preferences and then click on the “OK” button. Your drop-down cell box will then be created.
Microsoft Excel 2007
6. Open the Microsoft Excel 2007 application on your computer. Enter a list of data that you want for your drop-down list into a single column of your spreadsheet.
7. Click on the cell where you want your drop-down list to begin so that it’s selected. Click on the “Data” tab and then click on the “Data Validation” option from the “Data Tools” group.
8. Click on the “List” option from the “Allow” box. Click on the “Source” box and then select the column of cells you want for your drop-down list.
9. Click on the box next to the “In-cell dropdown” field so that it’s selected. Make any other changes to the drop-down list settings and your drop-down box will be created in your spreadsheet.

Read more ►