Excel 20101. 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 Documents4. Access the Google Documents website. Click 'Create New'...
Browse » Home » All posts
Thursday, January 17, 2013
How to Convert CSV File to Excel
Save CSV File as Excel Spreadsheet1. 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 Excel7. Open Excel and click 'Data' and then point to 'Import External Data.'8. Click 'Import Data.'9. Use the...
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 workshe...
How to Place a Tick in an Excel Spreadsheet
Symbol1. 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...
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'...
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...
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'...
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...
How to Determine Quarter in Excel 2003
1. Open Microsoft Excel.2. Type a date in cell A1. For example, type '4/11/2010' in cell A1.3. Type the following formula in cell A2, '=CHOOSE(MONTH(A1),'Q1','Q1','Q1','Q2','Q2','Q2','Q3','Q3','Q3','Q4','Q4','Q4') '-' RIGHT(YEAR(A1),2).' Cell A2 now displays 'Q2-1...
How to Footnote in Excel
1. Select the 'Page Layout' tab.2. Click on the dialog box launcher on the 'Page Setup' group. The dialog box launcher is the little arrow in the bottom right corner of the box. The 'Page Setup' window will pop up.3. Click on the 'Sheets' tab.4. Locate the 'Comments' drop down menu. Select 'At end of sheet.' This will make sure all of your footnotes appear at the bottom of the document.5. Click 'Print.' All comments that are hyperlinked to a cell will be included below the spreadshe...
Tuesday, January 15, 2013
How to Print a Chart in Microsoft Excel With Lines
1. Open the Microsoft Excel document that you want to print with gridlines.2. Click on the worksheet tab that you want to print, in the bottom left of the document.3. Highlight all of the cells and gridlines that you want to print.4. Click on the 'Page Layout' tab and find the 'Print Area' group. Click 'Set Print Area' to select the highlighted cells as the printable area of the document. This is an optional step. Note that if you do not set the print area, Excel will only print the data and its accompanying cells.5. Locate the 'Sheet Options' group in the 'Page Layout' tab. Place a...
How to Create Graphs in Excel with Multiple Columns
1. Enter the data for the desired chart into an Excel spreadsheet. Title any columns or rows as required.2. Highlight all data you wish to include in the chart. To highlight cells, click your mouse, and while holding down, drag it to include all desired information.3. Click the 'Insert' tab, and in the charts group, click 'Column.' Select the 2-D stacked column chart and it will be generated automatically.4. Edit the layout and style of the chart, label the various components and edit the size of the chart by clicking on the chart to generate a chart tools tab with three sub-tabs of design,...
How to Merge a Last Name and First Name in Excel 2007
1. Launch Microsoft Excel. Locate the spreadsheet that contains your name information and open the file.2. Click in the first cell of an empty column beyond the spreadsheet area that contains your data. Click 'Insert Function' from the 'Function Library' group of the 'Formulas' command tab and choose 'Text' from the list in the dialog box.3. Select 'Concatenate' from the 'Select a function' list and click on the 'OK' button. Click in the 'Text1' box in the dialog box and enter the ID of the cell that contains the part of the name--last or first--that you want to be the first part of your...
Sunday, January 13, 2013
How to Reduce Padding in Excel 2007 Cells
1. Start Excel 2007 and open the spreadsheet from which you want to remove padding.2. Highlight the columns from which you want to remove the padding. Place the cursor between any two highlighted column headers. The cursor changes to a double arrow. Double click and the width reduces to the minimum needed to display the contents of the column or columns.3. Highlight the rows from which you want to remove padding and double click between rows to remove ...
How to Use a Cell as a Checkbox in Excel 2007
1. Open the Microsoft Excel 2007 file to which you want to add checkboxes, then click on the “Microsoft Office” button. Click on “Excel Options” at the bottom of the window.2. Click to select the box next to the “Show Developer tab in the Ribbon” field, then click “OK.”3. Click on the “Developer” tab, then click “Insert” in the “Controls” group. Select the “Check box” option from the “Form Controls” section.4. Use your mouse to select the cell in your worksheet in which you want the checkboxes to appear.5. Click the “Developer” tab again and select “Properties.” Click the box next to...
Subscribe to:
Posts (Atom)