Microsoft Office

Word

  • Basic processing
  • Inserting pictures, tables, links, text boxes, charts
  • Adding watermarks
  • Using Footnotes, endnotes, and table of contents
  • Adding comments, review notes, and tracking changes
  • Linking to external documents, sites, or images
  • Linking to other aspects in the document

Excel

  • Formulas
    • Including: If statements, Count statements, Drop-Down Lists
  • Pivot table
  • Filters
  • Sorting
  • Inserting pictures, tables, charts, links
  • Linking to external spreadsheets
  • Linking to other aspects in the spreadsheet
  • Linking to other tabs
  • Freezing panes
  • Comments
  • Password locking: Spreadsheet, Worksheet, and/or individual cells
  • Hiding/Unhiding: Worksheets, columns, rows

Example

PowerPoint

  • Backgrounds
  • Transitions: individual and slide
  • Inserting pictures, tables, charts, links