Transitions- Is an effect that is used to play from one slide to another when you are in slide show view over a period of time.
Wednesday, May 26, 2010
Slide Sorter View
Slide Show View
Slide Master
Slide Layout
Slide Finder
Slide Design
Placeholders
Normal View
Exit Effect
Clip Organizer
Tuesday, May 25, 2010
Gantt Chart
Wednesday, May 19, 2010
Statistical Function
Relative Cell References
Order Of Evaluation
Operator
Operand
Mixed Cell Reference
Mathematical Functions
Function Formula
Formulas
Chart
Argument
Absolute Cell Reference
Wednesday, May 12, 2010
Steps For Mail Merge
1. Click on Mailing on the ribbon.
2. Click start Mail Merge.
3. Select Normal Word Document.
4. Do steps 1-2 and this time select Step By Step Mail Merge Wizard.
5. It would then appear a Mail Merge task pane on your right you then select the document type in this case we select Letters.
6. Click Next.
7. Select Starting Document in our case we select the first one which is Use The Current Document.
8. Click Next.
9. Select Recipient, in our case we select Use An Existing List.
10. Click Browse.
11. You go and find the Excel page with the Names and Action in our case or which ever document you want to use.
12. Make sure to select sheet 1.
13. Make sure that at the bottom of this window on the left corner that the little box is check.
14. Click OK.
15. Select the entire Names and Actions on this sheet.
16. Click OK.
17. Click Next.
18. Select the area where your going to change the recipient in our case we select whatever is after Dear.
19. Once you select it click on More Items.
20. Then replace it with Names.
21. Then you go to the next line and whatever you put for the actions you select it.
22. Click on More Items once again.
23. Then replace it with Actions.
24. Click Next.
25. Preview your Letter to test it out with all the different recipients that you inserted.
26. Click Next.
26. You can now Print or Edit Indiviual Letters.
We can use this in many other ways one way is so that in the future if your company were to write a letter to many people but then you don't want to change the name for every letter this way it would save time. So you can change all the names with the Mail Merge and you can print very easily from the pages that you want to another.
2. Click start Mail Merge.
3. Select Normal Word Document.
4. Do steps 1-2 and this time select Step By Step Mail Merge Wizard.
5. It would then appear a Mail Merge task pane on your right you then select the document type in this case we select Letters.
6. Click Next.
7. Select Starting Document in our case we select the first one which is Use The Current Document.
8. Click Next.
9. Select Recipient, in our case we select Use An Existing List.
10. Click Browse.
11. You go and find the Excel page with the Names and Action in our case or which ever document you want to use.
12. Make sure to select sheet 1.
13. Make sure that at the bottom of this window on the left corner that the little box is check.
14. Click OK.
15. Select the entire Names and Actions on this sheet.
16. Click OK.
17. Click Next.
18. Select the area where your going to change the recipient in our case we select whatever is after Dear.
19. Once you select it click on More Items.
20. Then replace it with Names.
21. Then you go to the next line and whatever you put for the actions you select it.
22. Click on More Items once again.
23. Then replace it with Actions.
24. Click Next.
25. Preview your Letter to test it out with all the different recipients that you inserted.
26. Click Next.
26. You can now Print or Edit Indiviual Letters.
We can use this in many other ways one way is so that in the future if your company were to write a letter to many people but then you don't want to change the name for every letter this way it would save time. So you can change all the names with the Mail Merge and you can print very easily from the pages that you want to another.
Monday, May 10, 2010
Worksheet
Range
Merge
Thursday, May 6, 2010
Header Row
Gridlines
Filling
Wednesday, May 5, 2010
Fill Handle
Cell Reference
Active Cell
Monday, April 26, 2010
Thumbnails
Thesaurus
Template
Superscript
Footer
Endnotes
Style
Sizing Handles
Header
Subscribe to:
Posts (Atom)