Course: Use of LibreOffice for an office automation environment , Topic: U15 - Calc Advanced & Mail Merge

Topic outline

General
- Forum
  
  Announcements Forum
- File
  
  Intro to the Course File
- Feedback
  
  Prior knowledge survey Feedback
- Glossary
  
  Glossary
- Forum
  
  Forum
- Resources
- URL
  
  LibreOffice Getting Started Guide URL
- URL
  
  LibreOffice.org main website URL
- URL
  
  LibreOffice Documentation URL

U15 - Calc Advanced & Mail Merge
- Learning outcomes
  
  After the completion of the unit the students will be able to:
  
  Employ the VLOOKUP function to lookup and retrieve data from a range of cells
  
  Summarize data in a spreadsheet using Pivot Tables
  
  Perform basic "what if" analysis with the Goal Seek tool
  
  Merge data to a document with the Mail Merge tool to generate multiple documents
- Page
  
  VLOOKUP Function Page
  
  View
- File
  
  VLOOKUP sample File
- Assignment
  
  VLOOKUP Exercise Assignment
  
  View Make a submission Receive a grade
- Page
  
  Pivot Tables Page
  
  View
- File
  
  Pivot Table sample File
- Assignment
  
  Create a Pivot Table Assignment
  
  View Make a submission Receive a grade
- Page
  
  Goal Seek Page
  
  View
- File
  
  Goal Seek Sample File
- Assignment
  
  Goal Seek exercise Assignment
  
  View Make a submission Receive a grade
- Page
  
  Mail Merge Page
  
  View
- File
  
  Mail Merge Sample Document File
- File
  
  Mail Merge sample data File
- Assignment
  
  Create multiple certificates Assignment
  
  View Make a submission Receive a grade
- Checklist
  
  U15 Self-evaluation Checklist