De-mystifying Microsoft Word and Excel 2007
•Download as PPTX, PDF•
1 like•554 views
This document provides instructions for formatting and collaborating on documents in Microsoft Word and Excel 2007. It discusses how to insert section breaks, page breaks, columns, tables, and track changes. It also covers entering and editing data, formulas, and functions in Excel 2007. The objectives are to demystify the features and functions of Word and Excel 2007 for formatting documents, collaborating on documents, and working with tables, formulas, and functions in Excel.
De-mystifying Microsoft Word and Excel 2007
- 1. De-mystifying Microsoft Word and Excel 2007Raritan Bay Medical CenterResearch and Education CommitteeYvonne Wesley RN PhD FAANSeptember 21, 20109/21/20101
- 5. Page LayoutSection BreakAs you format a document, you may find that specific areas of the document require formats that are different from the rest of the document. 9/21/20105
- 6. Page LayoutSection BreakThe PAGE LAYOUT groups look different than the HOME groups.To start a new section move the insertion point to the beginning of the new section and then insert a section break. 9/21/20106
- 7. Page BreakWhen you want a page break, place the curser where you want the page break and click hereColumnsTo create columns, highlight the text you want to be in columns format and click here.Or use the column buttonPage Layout9/21/20107
- 8. Click on INSERT tab
- 9. Click on TABLE button
- 10. Drag the mouse over the squares until you have the right sized table.Creating Tables9/21/20108
- 11. Highlight the area your want to convert to a tableClick on INSERTClick on TABLEClick on CONVERT TEXT TO TABLEDefine the number of column and rowsCreating TablesConverting Text to Table9/21/20109
- 12. Place the curser is in the tableNew tab will appear on the ribbonWhile in LAYOUT tab, data group will appearClick on Convert to TextChoose the way you want to separate the textCreating TablesConverting Tables to Text9/21/201010
- 13. Collaborating DocumentsTracking ChangesWhile in the REVIEW tab on the ribbonClick on the TRACK CHANGES button in the comments group9/21/201011
- 14. Collaborating DocumentsTracking ChangesWhile you are still in the REVIEW Tab, you get the option to ACCEPT or REJECT the proposed changes9/21/201012
- 15. Collaborating DocumentsInserting CommentsPlace the curser where you want the commentClick on the NEW COMMENT button while in the REVIEW tab mode 9/21/201013
- 16. Collaborating DocumentsDeleting CommentsTo delete the comments, point to the comment and right click on the commentA mini window will appear and you will see the option to delete the comment9/21/201014
- 17. Excel 2007Entering & Editing Data9/21/201015
- 18. Excel 2007Entering & Editing DataThe Formula Bar9/21/201016
Editor's Notes
- To apply most paragraph formats you don’t need to select the entire paragraph. Instead just position the insertion point somewhere in the paragraph. Word will apply the format you select to the entire paragraph.
- A specific type of alignment is an indentation.
- For example, one area might require different page margins. Word enables you to formant specific areas of a document by creating sections. A section is created by inserting a section break at the beginning of the area you want to designate.
- The breaks list offers a number of options for dividing the document. The lower section offers four ways to insert a section break. A continuous section break starts a new section but does not start a new page.
- Text consist of words and phrases which are generally used for labeling areas of a spreadsheet or list.Numbers in a cell can serve to display information and they can also be manipulated by Excel. For example, if cells C3 and C4 contain numbers, Excel can add up the values and display the results in another cell.Dates are a special type of number that can also be used as value and manipulated by Excel. For ex: Excel can subtract one date from another to display the number of days between the two dates.A formula is a mathematical statement that performs calculations on numeric data. A function is a predefined formula
- When you place the curser in cell A1, and click on the HOME tab you will notice, within the NUMBER group, the ability to define the type of data that will appear within that cell/cells. You can also define the font from the FONT group You can type in your text, numbers, dates or formulas within the FORMULA BAR or with cell A1.
- Remember, formulas are a mathematical statement that performs calculations on numeric data.
- The formula =B4+B5 adds up the numbers contained in cells B4 and B5 of the worksheet
- Operators such as * 4 multiply, and /4 divide
- A function is a built in formula. The name of the function is placed after the = sign. The cell to be contained in the function are placed in parentheses.