de-mystifying microsoft word and excel 2007
DESCRIPTION
Hospital Staff explore fundamental features of Microsoft Word & Excel 2007.TRANSCRIPT
![Page 1: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/1.jpg)
1
De-mystifying Microsoft Word and Excel 2007
Raritan Bay Medical CenterResearch and Education Committee
Yvonne Wesley RN PhD FAANSeptember 21, 2010
9/21/2010
![Page 2: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/2.jpg)
2
ObjectivesUpon completion of this 90-minute session, participants will be able to:• Format paragraphs, create a page
layout, create tables , & collaborate on a document in Word© 2007
• Enter & edit data, create formulas & functions in Excel© 2007
9/21/2010
![Page 3: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/3.jpg)
3
Paragraph FormatAlignment
9/21/2010
![Page 4: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/4.jpg)
4
Paragraph FormatIndentations
9/21/2010
![Page 5: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/5.jpg)
5
Page LayoutSection Break
As 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/2010
![Page 6: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/6.jpg)
6
Page LayoutSection Break
The 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/2010
![Page 7: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/7.jpg)
7Page Layout
Page BreakWhen you want a page
break, place the curser where you want the page break and click here
ColumnsTo create columns,
highlight the text you want to be in columns format and click here.
Or use the column button
9/21/2010
![Page 8: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/8.jpg)
8Creating Tables
•Click on INSERT tab•Click on TABLE button•Drag the mouse over the squares until you have the right sized table.
9/21/2010
![Page 9: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/9.jpg)
9Creating TablesConverting Text to Table
1. Highlight the area your want to convert to a table
2. Click on INSERT3. Click on TABLE4. Click on
CONVERT TEXT TO TABLE
5. Define the number of column and rows9/21/2010
![Page 10: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/10.jpg)
10Creating TablesConverting Tables to Text
1. Place the curser is in the table2. New tab will appear on the ribbon3. While in LAYOUT tab, data group will appear4. Click on Convert to Text5. Choose the way you want to separate the text
9/21/2010
![Page 11: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/11.jpg)
11
Collaborating DocumentsTracking Changes
1. While in the REVIEW tab on the ribbon
2. Click on the TRACK CHANGES button in the comments group
9/21/2010
![Page 12: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/12.jpg)
12
Collaborating DocumentsTracking Changes
1. While you are still in the REVIEW Tab, you get the option to ACCEPT or REJECT the proposed changes
9/21/2010
![Page 13: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/13.jpg)
13
Collaborating DocumentsInserting Comments
1. Place the curser where you want the comment
2. Click on the NEW COMMENT button while in the REVIEW tab mode
9/21/2010
![Page 14: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/14.jpg)
14
Collaborating DocumentsDeleting Comments
1. To delete the comments,
point to the comment and
right click on the comment
2. A mini window will a
ppear
and you will see the option
to delete the comment
9/21/2010
![Page 15: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/15.jpg)
15
Excel 2007Entering &
Editing Data
9/21/2010
![Page 16: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/16.jpg)
16
Excel 2007Entering &
Editing Data
The Formula Bar
9/21/2010
![Page 17: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/17.jpg)
17
Excel 2007 FORMULA
9/21/2010
![Page 18: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/18.jpg)
18
Excel 2007 FORMULA
9/21/2010
![Page 19: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/19.jpg)
19
Excel 2007 FORMULA
9/21/2010
![Page 20: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/20.jpg)
20
Excel 2007 Function
9/21/2010
![Page 21: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/21.jpg)
21
Excel 2007 Function
9/21/2010
![Page 22: De-mystifying Microsoft Word and Excel 2007](https://reader033.vdocuments.us/reader033/viewer/2022061207/54838590b4af9f8a068b45bc/html5/thumbnails/22.jpg)
22
SUMMARY
Word© 2007
Format paragraphs
Create a page layout
Create
tables
Collaborate on a docume
nt
Excel© 2007Enter & edit
data
Create formulas & functions
9/21/2010