Tuesday, January 22, 2013

How to Remove the Date From a Cell on an Excel Spreadsheet


1. Right-click on the cell.
2. Choose 'Format Cells'.
3. Click on the 'Number' tab. Click on a number format that you would like. For example, choose 'decimal'.
4. Press 'OK'.
Read more ►

Monday, January 21, 2013

How to Create an Excel Formula


1. Start Microsoft Excel and open the file you want to change.
2. Double-click on the cell where you want the total to appear.
3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
4. Enter the formula, then press Enter. Follow the steps below for an example.
5. Enter an opening parenthesis character: (.
6. Enter a cell name. For example: =(E2.
7. Press the key.
8. Enter another cell name and a closing parenthesis character: ). For example: =(E2 E3).
9. Enter a minus sign and a third cell name. For example: =(E2 E3)-E4.
10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.
Read more ►

How to Float a Row on Excel 2007


1. Click the 'View' tab in the Ribbon.
2. Click the 'Freeze Panes' button in the Window group. This opens a drop-down menu. Click 'Freeze Top Row' to freeze the first row at the top of the spreadsheet. All other rows will disappear when you scroll through the spreadsheet, but the first row will stay in place.
3. Select an entire row in your spreadsheet by clicking its number in the left-most column, then click the 'Freeze Panes' button in the Window group. Select 'Freeze Panes' in the drop-down menu. All rows above the selected row will be frozen in place; all others, including the one selected, can be scrolled.
Read more ►

Sunday, January 20, 2013

How to Use Excel for Birthdays


Arrange Your Spreadsheet
1. Create a series of columns in Excel for the information you need to track. Potential column headings include First Name, Last Name, Address and Birthday. Make these headings bold to set them apart from the rest of the spreadsheet.
2. Enter the names, birthdays and other information into the spreadsheet under the corresponding columns. Enter the dates in a format that Excel understands. You can access the format options by right-clicking the cell that contains a date. Once that cell is formatted correctly, you can copy and paste it into the rest of the column. This will eliminate the need for you to format the dates again.
3. Use the 'Sort' function in the 'Data' menu of Excel to sort the data by date. This will rearrange the data on the spreadsheet so that birthdays are listed in chronological order. You can choose to sort data in ascending or descending order. For data listed from January through December, select ascending order.
Apply Conditional Formats
4. Create a conditional format so that only birthdays occurring in the next week or month are highlighted on the spreadsheet. To access the conditional formatting tool in Excel 2010, go to the 'Style' menu located under the 'Home' tab of Excel.
5. Click 'Highlight Cells Rules' and 'Manage Rules' from the Conditional Formatting menu. Choose the option to create a new rule.
6. Apply the rule to the entire Excel spreadsheet by checking the cell range selected in the 'Manage Rules' section.
7. Click 'Format only cells that contain' as the rule type and select the option to format by date.
8. Click to select the 'Dates Occurring' option and then select the formatting rule you want to implement, such as highlighting dates occurring next week or this month.
9. Click the 'OK' button to save your changes and apply the conditional format to the spreadsheet.
Read more ►

Saturday, January 19, 2013

How do I Create a CSV File in Excel 2003?


1. Open the Microsoft Excel 2003 file. Click 'File' on the top menu.
2. Choose 'Save As' from the list of options.
3. Name your CSV file. Choose a location on your computer in which to save the file.
4. Choose 'Comma Separated Value' from your list of 'Save as type.'
5. Click the 'Save' button.
Read more ►

Friday, January 18, 2013

How to Make My Spreadsheet Look Like an Excel 2003 Spreadsheet


1. Complete your spreadsheet as normal and save it. This copy will be for your future use and is still in 2007 format.
2. Click on the 'Office' button in the upper left corner. This is a stylized version of the Windows logo. Many people mistake it for just a graphic, but several useful functions are hidden beneath it.
3. Click on 'Save as' and then select the option that says 'Excel 92-2003 Workbook.' Give your file a new name. The file extension of this file will be '.xls' instead of '.xlsx,' but you should give it a meaningful name to easily differentiate it from your 2007 files.
Read more ►

How to Insert an Excel Spreadsheet Into Word


1. Open the Word document into which you want to insert an Excel spreadsheet. Open the worksheet in Excel that you want to insert into Word.
2. Use your mouse to select the data on the Excel worksheet that you want to insert into the Word document. Copy the selected data using the keyboard shortcut 'Ctrl C' or by clicking the 'Copy' button on the standard toolbar in Excel 2003 or on the 'Home' tab in Excel 2007 or 2010.
3. Place your cursor in the Word document where you want to insert the Excel worksheet.
4. Click 'Paste' on the formatting toolbar in Word 2003 and then click the Paste Options button next to the pasted data. In Word 2007 or 2010, click the 'Paste' drop-down arrow on the 'Home' tab.
5. Click on 'Match Destination Table Style and Link to Excel' if you want the formatting to match the Word document, or click on 'Keep Source Formatting and Link to Excel' to retain the spreadsheet formatting.
Read more ►

Thursday, January 17, 2013

How to Create a Project Plan Template


Excel 2010
1. Open Excel 2010 and select the 'File' tab on the ribbon. Type 'project plan' in the search box. Excel will display the available project plan templates.
2. Click the templates to see a preview of them. Download the template by clicking the 'Download' icon in the right task pane. The template downloads to your computer.
3. Type your project details in the action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar.
Google Documents
4. Access the Google Documents website. Click 'Create New' and 'From Template.' Type 'project plan' in the search box. Google displays a list of available project plans.
5. Download the template by clicking the 'Use This Template' button.
6. Type your project details in the action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon.
OpenOffice
7. Access the OpenOffice website. Type 'project plan' in the search box. OpenOffice displays a list of available project plans.
8. Download the project plan template by clicking the 'Use This' link.
9. Type your project details in the OpenOffice Calc action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon.
Read more ►

How to Convert CSV File to Excel


Save CSV File as Excel Spreadsheet
1. Open Excel and click 'File' and then click 'Open.'
2. Click the down arrow next to 'Look in' to locate the folder containing the CSV file.
3. Use the down arrow next to 'Files of type' and select 'Text Files (*.prn; *.txt; *.csv).'
4. Double-click the CSV file to open it.
5. Click 'File' and then select 'Save As.'
6. Use the down arrow next to 'Save as type' and select your desired Excel version format; click 'Save.'
Import CSV File to Excel
7. Open Excel and click 'Data' and then point to 'Import External Data.'
8. Click 'Import Data.'
9. Use the down arrow next to 'Files of type' and select 'Text Files (*.txt; *.prn; *.csv; *.tab; *.asc).'
10. Click the down arrow next to 'Look in' to locate the folder containing the CSV file and then click 'Open.'
11. Click 'Next' three times, using the wizard default settings. Next, click 'Finish' and then click 'OK.'
Read more ►

How to Copy a Worksheet in Excel 2003


1. Open your Excel worksheet.
2. Highlight the entire worksheet or those cells with text in them. To highlight the entire worksheet quickly, press 'Ctrl A.' For individual cells, hold down the Ctrl key and click on each cell or drag the mouse across a group of cells.
3. To copy the selection, press 'Ctrl C.' Or you can click on the 'Edit' button in the top toolbar and select 'Copy' from the list of options.
4. Paste into a new worksheet.
Read more ►

How to Place a Tick in an Excel Spreadsheet


Symbol
1. Open your Excel workbook and navigate to the specific spreadsheet that needs to have a tick. The spreadsheets in the workbook are listed at the bottom of the window. Click the specific cell where you want the tick to be placed.
2. Navigate to the 'Insert' tab at the top of the screen, which is positioned to the left of the 'Page Layout' tab and to the right of the 'Home' tab. Click the 'Symbol' button in the 'Text' heading at the top-right side of the window.
3. Click the 'Font' drop-down menu and select the 'Wingdings' option. Scroll down to the bottom row of the available Wingdings symbols. Click the specific tick option you want to use and click 'Insert' to place the tick in your selected spreadsheet cell.
Check Box
4. Open the workbook you want to use and navigate to the appropriate sheet. Click the 'Developer' tab in the ribbon at the top of the screen. The 'Developer' tab is at the far right side, to the immediate right of the 'View' tab.
5. Click the 'Insert' button in the 'Controls' heading, which is located to the right of the 'Code' heading. Click the 'Check Box' option underneath the 'Form Control' sub-heading.
6. Click the location on your spreadsheet where you want the tick box to be placed. Click the edge of the box and drag it if you need to move it to a different location. Highlight the text in the box and press 'Backspace.' Type whatever text you need to appear next to the tick box.
7. Press 'Enter' to save the tick box. Click the box to add the tick, or click it again to remove the tick.
Read more ►

How to Create a Pie Chart in Excel 2007


1. Enter the data series in an Excel 2007 worksheet. Type the labels for the data series into the cells in one column. Type the numbers for the data series into the corresponding cells in the next column. For example, you might enter the name of each sales team into the cells in column 'A' and their corresponding sales figures into the cells in column 'B.'
2. Select the cells containing the data series by clicking on the first cell in the series, holding the mouse button down and dragging the pointer over the rest of the cells in the series.
3. Go to the 'Insert' tab of the ribbon. Click 'Pie' in the 'Charts' group.
4. Choose the subtype of pie chart you want to use, such as 'Exploded Pie' or '3-D Pie.' The pie chart appears on the current worksheet.
5. Click on the pie chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different chart style. Go to the 'Layout' tab to add effects such as '3-D Rotation.' Save the worksheet by clicking the 'Save' button on the 'Quick Access Toolbar.'
Read more ►

How to Drag Chart Markers to Change Data in Excel 2007


1. Enter any additional data you wish to add to the chart in cells that are adjacent to your existing worksheet data.
2. Use your mouse to select the chart by left-clicking in the chart area. Notice that a blue rectangle appears around the existing worksheet data used to generate the chart.
3. Move your mouse over one of the corners of the blue rectangle that is adjacent to the new data you just entered. A 2-sided arrow will appear. Drag the blue sizing handle to include the new data and labels in the rectangle.
4. Left-click and hold on the 2-sided arrow, then drag it to increase the size of the rectangle to include all the new data you have just entered. When you release the mouse button, the chart will automatically update to show the new data.
5. Add new data series only, as well as new categories and data points, by dragging the green and purple sizing handles respectively. Green and purple rectangles will also appear when you select the chart, if applicable, just as the blue rectangle did in Step 2.
Read more ►

How to Create Stacked Bar Chart


1. Open your spreadsheet program. If you do not have a spreadsheet program, check out the link below for a free trial of Microsoft Excel, which has the appropriate functionality to create stacked bar charts.
2. Populate the spreadsheet with the data for which you want to create a stacked bar chart. Note that you will need to have at least two values for one category in order create a stacked bar chart.
3. Click the 'Insert' drop down menu and select the 'Chart' option. This action will launch the 'Chart Wizard' in a separate window.
4. Click once on the 'Bar' option under the 'Chart type' listings.
Click once on the 'Stacked bar' option under the 'Chart sub-type' listings.
Click once on the 'Next' button.
5. Choose the 'Rows' option on Step 2 of the 'Chart Wizard' window.
Adjust the data range, if necessary, by clicking in the first cell of the range and dragging to the last while holding down the mouse button.
Click the 'Next' button.
6.
Click the 'Next' button on step 3 of the 'Chart Wizard' window.
Choose whether you want the stacked bar chart to appear in the same sheet as the source data or on a new sheet.
Click the 'Finish' button to view your stacked bar chart.
Read more ►

Wednesday, January 16, 2013

How to Build a Waterfall Chart in Excel


1. Open a new spreadsheet in Excel.
2. Place your data in column C, starting at cell C5. For example, you might have a list of children’s heights.
3. Write the word “Total” in cell B5.
4. Fill in column B with item numbers. Each piece of data in column C should have an item number in the cell to the left. Run the numbers sequentially, starting at “Item 1.” For example, in cell 6 write “Item 1” and in cell 7 write “item 2.” Continue writing item numbers until each piece of data in column C has a corresponding item number.
5. In column D, Sum the numbers below the current row for each item listed in column C. For example, in cell C6, click on the cell and add the formula “=sum(c7:C$11)” into cell D6.
6. Place a zero in the total and last item fields in column D.
7. Highlight all of the data in your spreadsheet by left-clicking at the top left corner of your data and dragging the cursor down to the bottom right.
8. Insert a column chart into the spreadsheet. In Excel 2003, run the chart wizard and choose “column.” In Excel 2007, click the “Insert” tab and then choose “Column-2D Column.”
9. Hide the set of columns that you do not want to appear on your chart. Left-click on the set of bars and choose “Format Data Series.” In Excel 2003, click the series order tab and then move series 2 over series 1. Then click on the “Patterns” tab and click the radio tab next to “none” for area and border. In Excel 2003, select “Fill” and then click the 'no fill' radio button. Set the Gap Width to 'no gap' by moving the slider.
Read more ►

Blogger news