Job & Career Upgrades

---

---

---

1. Microsoft Word - Basics

• Save & create basic documents
• Headers & footers, page numbering
• Text enhancements (centering, bold, italics, size)
• Using old documents to make new ones
• Envelopes & labels
• Correct business formats and page sizes

 see detailed MS Word skills list

2. Excel Spreadsheets - Basics

• Use =sum, =average, =min, =max formulas 
• Calculate percent of total
• Freeze headings, hide columns in large docs
• Add/remove columns & rows 
• Change column widths. 
• Multi-sheet workbooks 
• Full year workbooks 

see detailed Excel skills list

3. PowerPoint Basics

• Make basic 10-slide presentation
• Apply slide transition effects
• Use PowerPoint picture & text box templates
• Insert pictures & text without PowerPoint templates
• Make pictures dissolve, swell, spin, etc.
• Make text boxes dissolve, swell, spin, etc.
• Add sounds, music, recorded voice 
• Add video, film footage 
• Reposition slides
• Create PowerPoint show from outline
• Print handout outlines, notes, etc. from presentation

4. Outlook

• Set up mail using Outlook
• Maintain schedule/calendar
• Create and maintain task lists

5.  Microsoft Word  - Intermediate

• Create detailed reports, legal & business docs
• Create newspaper columns, newsletter layouts
• Advanced use of tables
• Use graphic lines, shadings
• Add pictures, clipart
• Set tabs 
• Use automatic paragraph numbering
• Create databases, handle mail merge
• Sort databases & lists 

see detailed MS Word skills list 

6.  Microsoft Word  - Legal

• Proper legal formats for pleadings, appeals, etc.
• Caption boxes
• Numbered pleading paper
• Court-required footers
• Table of contents, table of authority
• Footnotes, endnotes
• Auto paragraph numbering
• Appeal briefs

see detailed MS Word skills list 

7.  Excel Spreadsheets - Intermediate

• Keep & sort client/company data
• Powerful--but easy--formulas
• More interesting page layouts
• Charts I - pie / line / column, etc
• Charts II - Escape from The Dull
• Import to Word, PowerPoint 
• Word tables into spreadsheets
• Using named ranges
• Macros

see detailed Excel skills list 

8.  Maintaining Folders/Directories

• Email basics--easiest steps
• Send pictures by email
• Send more pictures
• Block email you don't want
• Save email forever
• Copy emails into letters, documents, etc.
• Send it on: forward jokes, pictures, articles
• Faxes: send & receive from your computer