Monday, July 16, 2012

How to Change Interval of Category Axis in an Excel Chart


1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you want to change the interval of the category axis.
2. Click in the white area of the chart so the whole chart is selected. You can tell the entire chart is selected because a light blue outline will surround the entire chart.
3. Select the 'Format' tab at the top of the Excel screen to display the 'Format' ribbon. Locate the 'Current Selection' group-it is the first group in the 'Format' ribbon.
4. Click the 'Chart Elements' arrow to display the drop-down list. This is the top option in the 'Current Selection' section of the 'Format' ribbon. Choose '(Category) Axis' from the drop-down list.
5. Press the 'Format Selection' button right underneath the 'Chart Elements' drop-down list. The 'Format Axis' dialog box will appear on the screen. Click 'Axis Options' if necessary to display the options for changing the interval of the category axis.
6. Type the number of units you have to use in the 'Interval between tick marks' text box at the top of the 'Format Axis' dialog box.
7. Click the 'Close' button to close the 'Format Axis' dialog box and return to your Excel chart. You will now see that the interval for the category axis has changed.
Read more ►

How to Create a Bar Chart in Microsoft Excel 2003


1. Make a table that contains all of the data you want represented in your bar chart. Be sure to include column and row labels and numerical quantities when making your table.
2. Highlight all of the data in your table--including the column and row labels--and click the “Chart Wizard” button on the toolbar. The “Chart Wizard” button looks like a tiny column chart.
3. When the Chart Wizard appears, select “Bar” from the “Chart Type” menu, then select the subcategory of bar chart you would like to create. Click the “Next” button.
4. Use the “Data Range” box if you need to modify the data set. Select “Rows” from the “Series In” option to sort your data by row or “Columns” to sort your data by column. Click “Next.”
5. Enter titles and labels for your chart to make it easy to read. Excel will offer you a preview of how the chart will appear while you work.
6. Use the “Axes,” “Gridlines,” “Legend,” “Data Labels,” and “Data Table” tabs as additional tools for modifying the appearance of your bar chart. Each tab modifies a specific part of your bar chart. Click “Next” when you are finished modifying the appearance of your chart.
7. Select “As New Sheet” to place your bar chart in a new Excel spreadsheet or select “As Object In” to place the bar chart in the same spreadsheet that you built your data table. Click “Finish” to complete the creation of your chart and place it on a spreadsheet.
Read more ►

How to Synchronize Spreadsheets in Excel


Linking Separate Excel Workbooks Together
1. Open the workbook with the data you expect to be shared in Excel. This is the source workbook.
2. Open the workbook you want the data to be replicated in. This is the destination workbook.
3. Select the cell in the source workbook you want the data to come from, and enter 'Ctrl C' to copy it.
4. Switch to the target workbook, and select the cell you want the data to appear in.
5. Enter 'Ctrl V' to paste the reference in. If you examine the formula, you'll see that prior to the row and column entry, there will be a reference to the drive location (or network location) and the file name of the source workbook. An example would look like this: [C:\Book1.xlsx]Sheet1!A1. This means that Excel will pull the value from the linked file.
Synchronizing Worksheets In The Same Workbook
6. Open your workbook in Excel.
7. Hold down the 'Ctrl' key while clicking on multiple worksheet tabs. Be sure to leave one tab unselected when you do this. This will ensure that any edits you make on one tab will be replicated across all selected tabs, with data entered in the corresponding cells.
8. Click the tab that's not part of the group to undo the tab group selection. This will get Excel to revert to 'normal mode,' where changes in one tab only affect that tab.
Read more ►

How to Add an Analysis Toolpack in Excel 2003 GPO


1. Launch Excel 2003. To install the Analysis Toolpak on a version of Excel that was installed through a GPO (Group Policy Organization), you need a privileged account, or you must talk to your network administrator to unlock the procedure.
2. Click on the 'Tools' menu item. Navigate through the drop-down menu and select 'Add-Ins'. A dialog box will appear; this will show all the add-ons currently available.
3. Check the check box that says 'Analysis Toolpak.' You may need to click on the 'Browse' button to load it; it will be listed as Analysis.xla in the Add Ons folder for Excel. If you do not see it, you may need to reinstall Excel 2003 from your installation media. If prompted 'Do you want to install the Analysis Toolpak?', click 'Yes' to install it.
4. Click the 'Tools' menu item; there will now be a 'Data Analysis' entry added to the drop-down menu.
Read more ►

How to Insert a Dynamic Date in Excel


1. Start Microsoft Excel 2007, and open a spreadsheet from your files into which you want to insert a dynamic date. Or, you can start a new, blank spreadsheet.
2. Select the cell you want to insert the dynamic date into by clicking on it. The cell will be surrounded by a thick, black outline once it is selected.
3. Type the formula '=today()' (without the quotation marks) into the selected cell. This formula will instruct Excel to insert the current date into the cell where the formula is entered.
4. Press the 'Enter' key on your keyboard or the green check mark on the formula bar to input the formula into Excel. Excel will then accept the formula and display the current date into the cell where you typed the formula. The date will be updated every time the 'Enter' key is pressed when you are working in the workbook where the formula has been inserted.
5. Use the procedure above to insert the dynamic date into any other cells in the open spreadsheet that you would like to display the current date.
Read more ►

Sunday, July 15, 2012

How to Adjust the Color of Excel Bars in a Bar Chart


1. Open the formatted workbook and double-click the specific bar element you wish to change.
2. On the 'Patterns' tab in the 'Area' section of the 'Format Data Series' dialogue box, click your preferred color. You can preview it in the 'Sample' box in the lower left corner.
3. Click the 'OK' button. The chart will show the new color choice.
4. Save the changes to the chart and workbook.
Read more ►

How to Import a Word Doc Into an Excel Spreadsheet


1. Open Excel and click the 'Insert' tab in the toolbar at the top of the page. You can import a picture, chart or file here.
2. Click the 'Object' button and then click the 'Create from File' tab.
3. Click 'Browse.' A list of your folders and files will open. Select the Word document you want to import and click 'Insert.'
4. Click 'OK.' The Word document will now appear in your Excel spreadsheet. Click on the newly created object to move it to the desired position in the spreadsheet.
Read more ►

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 ►

Blogger news