Sunday, July 15, 2012

How To Use the List Feature In Excel


Excel 2003
1. Open Excel 2003. Create a new spreadsheet or open an existing spreadsheet.
2. Enter data headers in the first row. Enter the data below them.
3. Click and drag to select your data including the headers.
4. Open the 'Data' menu. Point to the 'List' menu and click 'Create List.'
5. Check the 'My list has headers' check box. Click 'OK.'
6. Click a header to sort the data based on that column.
7. Type in the bottom row containing an asterisk to add a row to your list.
8. Click and drag the handle at the bottom right corner of your list to expand the range.
9. Click outside the list cells to deselect the list.
Excel 2007 and 2010
10. Open Excel 2007 or 2010. Create a new spreadsheet or open an existing spreadsheet.
11. Enter data headers in the first row. Enter the data below them.
12. Click and drag to select your data including the headers.
13. Click the 'Home' ribbon and click 'Format as Table.' Select a table style from the drop-down menu.
14. Check the 'My table has headers' check box. Click 'OK.'
15. Click a header to sort the data based on that column.
16. Select the bottom right corner and press 'Tab' to insert a new row.
17. Click and drag the handle at the bottom right corner of your list to expand the range.
18. Click outside the list cells to deselect the list.
Read more ►

Saturday, July 14, 2012

How to Make a Time Sheet


Microsoft Excel 2010
1. Select a Microsoft Excel 2010 template. Open Excel 2010 and select the 'File' tab. Click 'New.' Select the 'Time Sheets' category. Review the available time sheets. Preview the time sheet by clicking the image. A small preview and description appears in the right task pane. Download the template by clicking the 'Download' icon beneath the image and preview.
2. Customize the template by adding personal details. These details include the time worked, your company name, address, manager name and the current date.
3. Save the changes to the time sheet by clicking the 'Save' icon on the Quick Access Toolbar.
OpenOffice
4. Select an OpenOffice template. Access the OpenOffice website. Type 'Time Sheets' in the search box. Review the available time sheets that appear. Click 'Use This' to download the template to your computer.
5. Open the downloaded file in OpenOffice Calc. Customize the template by adding personal details. These details include the time worked, your company name, address, manager name and the current date.
6. Save the changes to the time sheet by clicking the 'Save' icon.
Google Documents
7. Select a Google Documents template. Access the Google Documents website. Type 'Time Sheets' in the search box. Click 'Search Templates.' Review the available time sheets that appear. Click 'Use This Template' to download the template to your computer.
8. Open the downloaded file in Google Documents. Customize the template by adding personal details. These details include the time worked, your company name, address, manager name and the current date.
9. Save the changes to the time sheet by clicking the 'Save' icon.
Read more ►

How to Open a Wb3 File in Excel 2003


1. Open Excel 2003, and select 'Open' from the 'File' menu.
2. Locate the WB3 file that you wish to open in the 'Look in' list.
3. Click the name of the file, and click 'Open.'
Read more ►

How to Send Email Using Excel 2007 VBA


1. Start Microsoft Office 2007 and select the 'Developer' tab. Click on 'Visual Basic' and select 'Tools.' Click on 'References' check 'Microsoft Outlook 12.0 Object Library' and select 'OK.'
2. Type the following to create a new sub:Sub sendEmail()Press 'Enter.'
3. Type the following to create your variables:Dim oLookApp As Outlook.ApplicationDim oLookMail As Outlook.MailItem
4. Type the following to assign the outlook object and create a new email:Set oLookApp = New Outlook.ApplicationSet oLookMail = oLookApp.CreateItem(0)
5. Type the following to define the variables for your email:With oLookMail.To = 'john.doe@yahoo.com'.Subject = 'My Workbook'.Body = 'I'm e-mailing this workbook..'.Attachments.Add ActiveWorkbook.FullName.sendEnd With
6. Execute your sub to email the current Excel workbook.
Read more ►

How to Insert Hatching in Microsoft Excel Shapes


1. Right-click on the Excel 2010 spreadsheet shape in which you want to insert hatching.
2. Click 'Format Shape' to display an options box.
3. Click 'Fill' to display fill options.
4. Click 'Pattern Fill' from the list to display available fill patterns.
5. Click the hatching pattern you want to insert in the shape and then click 'Close.'
Read more ►

Friday, July 13, 2012

How to Create Rounded Borders in Excel


1. Open the Excel worksheet.
2. Click the “Insert” tab on the command ribbon.
3. Click the arrow under the “Shapes” button in the “Illustrations” group.
4. Click the preferred shape, such as “Rounded Rectangle.” The cursor will convert to a “ ” sign.
5. Click and drag the cursor on the worksheet where you wish to insert the rounded border. For example, click and drag inside a cell to create a row or column header.
6. Click the sizing handles on the shape to resize the rectangle.
Read more ►

How to Remove Protection From Cells in Excel 2003


1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'
2. Click 'File,' then 'Open.' Locate, select and open your workbook that has the cells you wish to unprotect.
3. Locate the protected cell.
4. Click the cell, then click 'Format,' followed by 'Cells.'
5. Click 'Protection.' Click the checkbox next to 'Locked' to remove the cell protection. Click 'OK' to close the Format Cells dialog. You have now removed protection from the cell.
Read more ►

Thursday, July 12, 2012

How to Insert and Size Diagrams in Microsoft Excel 2003


1. Access the diagram menu. Scroll to the “Insert” tab on the command bar and select “Diagram.”
2. A diagram selection box will open where you can select six different types of diagrams: organization chart, cycle diagram, radial diagram, pyramid diagram, Venn diagram and target diagram. Choose the desired diagram by left-clicking on it and then click the “OK” button to insert the diagram.
3. Place the diagram. To move the diagram around, left-click on the gray border and hold as you drag the diagram where desired on the spreadsheet.
4. Set diagram attributes. You can add levels to your diagram and size it by clicking on the “Insert Shape” button on the diagram properties box. You can easily label each level and shape by left-clicking on “Click to Add Text” field and entering the desired text. Finally, you can even change the type of the diagram by clicking on the “Change To” drop-down menu and selecting a different diagram shape.
5. Insert the diagram. To insert the diagram, left-click on the “X” in the right corner of the diagram properties box to close it; the diagram will be inserted into your spreadsheet when you do this.
Read more ►

How to Merge Data From Several Excel Workbooks


1. Click the Microsoft Office button on the screen's top-left corner, and select 'Excel options.'
2. Under 'Customize,' click 'All Commands' in the 'Choose commands from' list.
3. Check the box next to 'Compare and Merge Workbooks.' Click 'Add,' and then click 'OK.' The 'Compare and Merge Workbooks' icon will now appear in the quick access bar at the top of the window,
4. Move all workbooks to a single folder. If they share a name, rename them as necessary.
5. Open one workbook. Click the 'Compare and Merge Workbooks' icon.
6. Select the other workbooks whose date you want to merge. To select multiple workbooks, press the 'control' or 'shift' keys as you select them.
7. Click 'OK.'
Read more ►

How to Calculate Negative Times in Excel


1. Open your Excel 2010 worksheet. Click on an empty cell anywhere on the worksheet.
2. Type '-'1:30'' into the cell. The number '-.0625' should appear. Right-click the cell and choose 'Format Cells.' Choose 'Time' from the list on the left and click 'OK.' The number changes to '#####.'
3. Click on the 'File' tab at the top of the screen. Choose 'Options' from the list that appears.
4. Click 'Advanced' on the list on the left side of the Options window. Scroll down to the bottom of the 'Advanced' screen and look for the 'When calculating this workbook' heading. Click the box next to 'Use 1904 date system.'
5. Click 'OK' to close the Options window. The time that you entered now reads '-1:30.' You can perform normal mathematical operations on the number and it will behave exactly like a negative number would.
Read more ►

How to Make an Exponent on Excel


Insert Exponent into Formula
1. Open the Microsoft Excel spreadsheet that contains the formula where you want to add an exponent.
2. Click on the cell that contains your formula. The formula will appear in the bar above the Excel spreadsheet. Click on this bar and place your cursor where you want to add the exponential number.
3. Enter the following into the formula bar, without quotes: 'power(x,y)' where 'x' is the desired number and 'y' is the exponent. If needed, you can wrap the entire 'power' function in parentheses. Additionally, you can write this in shorthand as 'x^y', without quotes.
Have Numbers Display as Exponents
4. Open your Microsoft Excel 2010 spreadsheet where you want to make your numbers display as exponents.
5. Click the top-left cell of the area that you want to change, then hold shift and select the bottom-right cell of that area. If you want to change the entire spreadsheet, you can just click the small box that sits above the '1' and to the left of the 'A' in the top-left corner of the spreadsheet.
6. Right-click anywhere on the selected cells. Choose 'Format Cells' from the pop-up menu.
7. Click on 'Scientific' from the list on the left side of the Format Cells window. On the right side of the window, click the up and down arrows to determine how many decimal places you want to display, then click 'OK.' Excel will now display numbers in those cells like '1.25E 02,' which is the same as '1.25^2' or '125.'
Read more ►

Wednesday, July 11, 2012

How to Open a Password Protected Microsoft Office Excel Sheet


1. Browse to the location where the password-protected Excel document is saved using Windows Explorer.
2. Double-click the document you wish to open. Excel will launch and display a dialog box explaining that the document is protected and requires a password.
3. Enter the password in the space provided, and hit 'OK.' This will open the document and allow you to view and edit the contents.
Read more ►

How to Do an Excel Chart With Multiple Legends


1. Open your Microsoft Excel spreadsheet that already has your data entered into the cells.
2. Click on cell A1, followed by 'Control' and 'A.' This is a shortcut that highlights your complete set of data.
3. Click 'Insert' on your toolbar, followed by 'Bar,' 'Pie' or another form of chart that you like. The chart will appear in your spreadsheet.
4. Click on the chart. Click 'Layout' and then the Legend icon. Click the button that specifies the your legend's orientation such as 'Show Legend at Right.' The legend will appear in your chart.
5. Click on the legend table. Click 'Control' and 'C,' followed by 'Control' and 'V.' A second legend will appear in your graph.
Read more ►

How to Make a Graph From CSV


1. Launch Excel 2010, click 'File' in the top menu and select 'Open.' Click on the file types drop-down menu at the bottom right of the File Open dialog box. You will need to select either 'All files (*.*)' or 'Text files (*.prn, *.txt, *.csv)' because by default, Excel filters your file choices to show only its native file types. Navigate to your file and click 'Open.'
2. Find an empty spot in your spreadsheet and click a cell. The exact location is not important, as you are selecting a place to put your chart while you work on it.
3. Click 'Insert' in the top menu and select any one of the chart types you feel will best represent your data. For instance, click 'Line' then select '2D line.' A blank chart area appears in your spreadsheet.
4. Right click in the blank chart area and click 'Select data.' When the 'Select Data Source' window appears, use you mouse to click and drag over the cells that contain the data you want in the graph. When you release the mouse, you will see the chart automatically updated with your data.
5. Modify the data as required for your purposes. You can modify the text around the X and Y axes by double-clicking on them and modifying the text in the dialog boxes.
6. Save your file when your modifications are complete. If you wish to use this chart in a presentation, or include it in a document, you can copy it to that document: clicking on your chart and press 'Ctrl' plus the letter 'C' to copy it, then switch to the other document and press 'Ctrl' plus the letter 'V' to paste it into the document. You will need to make sure that the other application is capable of displaying the graph or chart, but Microsoft's other major applications, such as Microsoft Word and PowerPoint, can do this.
Read more ►

How to Make a Watermark in Excel


1. Open the Excel workbook in which you want to create a watermark.
2. Click View on the Excel toolbar, or use the keyboard shortcut 'Alt' plus 'V.'
3. Click the View menu and select Header and Footer.
4. Choose Custom Header in the Page Setup dialog box that appears. Click the 'Center Section' so your cursor is active in the corresponding field.
5. Click the 'Insert Picture' button on the right; this button has a picture of mountains and the sun. Navigate to the picture that you wish to use as a watermark and double-click the graphic to insert it.
6. Click the 'Format Picture' button on the far right of the Header dialog box. Resize the picture to fit your page using the options on the Size tab.
7. Click the Picture tab. Under Image Control in the drop-down menu next to 'Color' choose Washout. This will give your graphic a watermark appearance.
8. Click 'OK' on the Format Picture dialog, and again on the Header and Page Setup dialogs.
Read more ►

Blogger news