Tuesday, May 28, 2013

How to Insert Hyperlinks in Microsoft Excel


1. Select the cell where you want your hyperlink to be placed. You can either insert a hyperlink into a blank cell or into a cell already filled with information. If the cell is blank, the hyperlink is displayed by its file or Internet location unless you specify different text later. If the cell is already filled, the text will be the link.
2. Choose 'Hyperlink' from the 'Insert' menu. A hyperlink wizard pops up.
3. Note the 4 icons on the left side of the wizard. These icons represent the 4 types of hyperlinks you may insert into Excel. The 'Existing File or Web Page' option is probably the one you used most often. Click it and insert the file location of a file on your hard drive or website address. Change the linked text with the form field at the top if you wish.
4. Pick 'E-mail Address' to create a link to an email address. Enter the email address and the subject any email sent via the link should have. When users click on this link, an email to the linked email address opens in their default mail program.
5. Click 'Place in Document' to link to another sheet in the document.
6. Use the 'Create New Document' option to allow the Excel user to open a new Microsoft Office document with a link. The document can be from any Microsoft Office software you've installed.
7. Hit the 'OK' button to insert your hyperlink into your Excel document.
Read more ►

Monday, May 27, 2013

How to Sort Information in Excel 2007


1. Access a worksheet with data that can be sorted. Open Excel 2007 and either open an existing worksheet or add information into an empty worksheet. Data should be in a table, preferably with assigned column headers to make selecting the sorting criteria easier. Make sure that all of the data in a given column is of the same format so that it is sorted consistently.
2. Choose the data to be sorted. Left-click and drag to select the data. Ensure that both the data and the headers are included.
3. Open the sort dialog. Select 'Data' on the Excel 2007 ribbon, and then click on the 'Sort' icon.
4. Configure the sort options and apply the sort. If you have created column headers, make sure 'My data has headers' is selected. Select the column to sort by in the 'Sort by' drop-down list. Select how to sort the data by selecting from the drop down list, typically by the cell values. You can also sort by cell color, font color or cell icon. Select whether to sort in ascending or descending order by selecting from the 'Order' drop down list. To sort on more than one column, choose 'Add Level' and repeat these selections. To make the sort case sensitive or to sort from bottom to top instead of top to bottom, select 'Options' and choose accordingly. Click 'OK.'
Read more ►

How to Set up a PivotTable


1. Open the Excel worksheet that contains the data you want to make a PivotTable out of.
2. Look through your data and make sure the top cell in every column is the column title. If any of the top cells are empty, add a title that will tell you what the data in that mean. If none of your columns has a titles, right-click on the '1' on the left side of your screen and choose 'Insert.' A new row will appear at the top of the page. Enter column titles into this row.
3. Click on the top-left cell in the range of data you want to use for the PivotTable. Scroll to the bottom-right cell in the field, then hold 'Shift' and click on the cell. The entire data field will now be highlighted.
4. Click on the 'Insert' tab at the top of the screen, and the click the 'PivotTable' button. Click 'OK' on the window that opens up, and a new worksheet will be created for your PivotTable. You will see a blank table on the left side of the screen and a field list on the right.
5. Place check marks next to the fields you want to compare in the PivotTable. Excel will automatically place the fields into one of the four PivotTable categories located to the right of the field list.
6. Drag and drop your chosen fields into the categories where you want them. Each category corresponds to a different area of the PivotTable where the data will show up. You can choose to make the field into a column on the table, a row on the table, the data that makes up the meat of the table or a top-level filter above the table.
Read more ►

Sunday, May 26, 2013

How to Import Delimited ASCII127 in Excel


1. Run the Excel 2010 application.
2. Click the 'File' tab and click 'Open' to open a file browser window. Click the 'Files' drop-down list, and choose 'Text Files.'
3. Navigate the file browser to the delimited ASCII TXT file that you wish to import, then click 'Open.' Excel will initiate the Import Text Wizard.
4. Click the radio button next to 'Delimited,' and click the 'Next' button.
5. Click the radio button next to the character that the ASCII file uses for delimiting fields. If your delimiting character is not in the list, then click 'Other,' and type the character into the adjacent field.
6. Click 'Next' and 'OK' to complete the Text Import Wizard. Excel will import data from your delimited ASCII text file and will automatically assign cell formatting that it deems appropriate for the type of value that is contained in each field.
Read more ►

How to Remove an Unknown Password From a Protected Excel Spreadsheet


1. Download an Excel password recovery software, such as Free Word/Excel Password Recovery Software, Excel Password Remover 2008, or Password Recovery Engine for Excel (see resources). Save the file, then click 'Install' at the prompt.
2. Open the application. Click 'Open,' followed by 'Browse.' Select your protected Excel spreadsheet from the menu. Click 'Recover' and wait for the program to recover your password.
3. Open the Excel spreadsheet using the password. From the 'File' menu, select 'Save As.' Under 'Tools,' select 'General Options.'
4. Double-click the asterisks in both the 'Password to Open' and 'Password to Modify' boxes, then press the 'Delete' key. Click 'OK,' then 'Save.'
Read more ►

How to Convert Microsoft Project to Microsoft Excel


1. Double-click on your Microsoft Project file.
2. Click 'File' at the top of the screen (Project 2003 or earlier) or the Windows button in the top-left corner (Project 2007).
3. Choose the 'Save As' option (Project 2003 or earlier) or 'Save As,' and then 'Other file formats' (Project 2007).
4. Click the arrow for the drop-down menu next to 'Save file type as' and select the 'Microsoft Excel (.xls)' option.
5. Select the location for your saved file and change the name, if necessary.
Click the 'Save' button.
Read more ►

How to Create a Personal Budget Using Excel 2007


1. Open Excel 2007 and select the 'Office' button. Select 'New.' Excel displays the templates available. Click on the word 'Budgets' in the left task pane. Review the available templates and download one of the personal budgets by clicking the 'Download' button.
2. Update your personal budget by adding your income. Locate the income section of the template and add your income. Locate the expense section of the template and add your expenses. If necessary, right click on the row and select 'Insert Row' to add additional rows to the template.
3. Save your changes to the budget by clicking the 'Save' icon in the Quick Access Toolbar.
Read more ►

Saturday, May 25, 2013

How to Have Different Footers on a Word Document


Insert Different Footers in a Word 2003 Document
1. Place your cursor on the page before the one in which you want to create a different footer.
2. Go to the Insert menu and select Break. In the Insert Break dialog box that appears, select Next Page under Section Breaks.
3. Go to the View menu and select Header and Footer. Place the cursor inside the footer section of the first page in which you want to make a different footer.
4. Click the Link to Previous button on the Header and Footer toolbar. This will disconnect the footer from the previous section.
5. Enter the information you desire into the footer and save your document.
Insert Different Footers in a Word 2007 or 2010 Document
6. Place your cursor on the page before the one in which you want to create a different footer.
7. Go to the Page Layout tab and select Breaks from the Page Setup group. Select Next Page under Section Breaks in the Breaks drop-down menu.
8. Click on the page in which you want to start the different footer. Go to the Insert tab and click Footer. Click Edit Footer near the bottom of the Footer drop-down menu.
9. Click the Link to Previous button in the Navigation group on the Design tab of the Header and Footer Tools tab. This will disconnect the footer from the previous section.
10. Enter the information you desire into the footer and save your document.
Read more ►

How to Open a Specific Spreadsheet Each Time Excel Starts


1. Right-click the Windows desktop. Mouse over 'New' and select 'Shortcut.' The 'Create Shortcut' window will open.
2. Click the 'Browse' icon.
3. Locate and select the 'Excel.exe' file. This is the executable file that opens the Excel program. If you installed the program in the default location, the path to the file for the different versions is as follows:Excel 2003 - C:\Program Files\Microsoft Office\Office11\XlstartExcel 2007 - C:\Program Files\Microsoft Office\Office12\XlstartExcel 2010 - C:\Program Files\Microsoft Office\Office14\XlstartIf you can't find the 'Excel.exe' file in the default location, use the search feature on the Windows Start menu to search for it. Click 'OK.'
4. Add the command line to the end of the file path, outside the closed parentheses. The file command to open a specific spreadsheet is as follows:'c:\My Folder\book1.xlsx'The path inside the parentheses is the location of the spreadsheet file you want to open when Excel starts.
5. Click 'Next.' Type a name for the new shortcut. This should be something that you can associate with the spreadsheet that will open. Click 'Finish.' The new shortcut will appear on the desktop represented by the Excel icon.
6. Click the new shortcut to open Excel directly to the desired spreadsheet.
Read more ►

How to Activate Macros in Excel


1. Open Microsoft Excel.
2. Find and click the 'Office' button. It's not labeled, but it's the large round button with the Microsoft logo in the upper left corner of your Excel window.
3. Click on the 'Excel Options' button at the bottom of the resulting menu.
4. Click on the 'Trust Center' option in the list at left, and then click on the 'Trust Center Settings' button.
5. Click on 'Macro Settings' in the list at left, and then click the radio button next to 'Disable all macros with notification.' Using this setting, Excel will notify you when a macro opens and ask you to choose whether or not to run it.
6. Click the 'OK' button to return to your document and exit Excel completely. When you re-open, your settings will be changed.
Read more ►

How to Open XLS Files in a Microsoft Spreadsheet


Using Excel
1. 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 'All Excel files.' This will ensure that you can open the Excel file even if it was created with a different version of Microsoft Excel than the version that you have on your computer. Double-click the folder that the Excel file is located in within the main window. Click the 'Open' button in the bottom right corner.
Without Excel
4. Visit Microsoft's Excel Viewer web page (see Resources).
5. Scroll down the page until you see a blue box with a 'Download' button at the top. Click the button. A dialog box will pop up. Click 'Save File.' The download may take anywhere from a few seconds to a minute, depending on your connection speed.
6. Double-click on the file in your downloads box (ExcelViewer.exe) when it has finished downloading. Click on the 'Yes' button if the computer prompts you for permission to install the file. The installation wizard will launch.
7. Click the check box at the bottom of the wizard to agree to the agreement terms, and click the 'Next' button in the bottom right corner. Click the 'Install' button in the bottom right corner. The program may take several minutes to install. Click 'OK' when the installation has finished. You can now double-click on any Microsoft Excel file to view it.
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 worksheet.
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 chart tab most appropriate for your project.
5. Type in the sample size, 'n', and the 'k' value control limit into the top of the worksheet in the labeled areas.
6. Paste or type the X-bar and standard deviation or range values for your data set into the worksheet's table located below the control chart display. Do not alter the grayed-out columns or the 'Sample' column.
7. View the control chart for your data and parameters. The chart in the main worksheet window automatically updates based on your criteria.
Read more ►

How to Link an Excel 2007 Chart to a PowerPoint 2007


Prepare Your Chart in Excel 2007
1. 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 2007
6. Open your presentation in PowerPoint 2007 and then navigate to the slide where you want the chart inserted. If you want to insert the chart within a text box, select the box by clicking it.
7. Select the 'Insert' tab and then click the 'Object' button.
8. Select the 'Create from file' option on the left side of the window.
9. Click the 'Browse' button, locate your Excel 2007 spreadsheet in the resulting window and select it by double clicking its icon.
10. Check the 'Link' box and then click 'OK.'
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 used to filter the data to remove the filter and return the list to its original state.
Read more ►

Blogger news