Download - De-mystifying Microsoft Word and Excel 2007
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
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
3
Paragraph FormatAlignment
9/21/2010
4
Paragraph FormatIndentations
9/21/2010
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
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
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
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
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
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
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
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
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
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
15
Excel 2007Entering &
Editing Data
9/21/2010
16
Excel 2007Entering &
Editing Data
The Formula Bar
9/21/2010
17
Excel 2007 FORMULA
9/21/2010
18
Excel 2007 FORMULA
9/21/2010
19
Excel 2007 FORMULA
9/21/2010
20
Excel 2007 Function
9/21/2010
21
Excel 2007 Function
9/21/2010
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