Use of LibreOffice for an office automation environment

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
• VLOOKUP Function Page
• VLOOKUP sample File
• VLOOKUP Exercise Assignment
• Pivot Tables Page
• Pivot Table sample File
• Create a Pivot Table Assignment
• Goal Seek Page
• Goal Seek Sample File
• Goal Seek exercise Assignment
• ---

• Mail Merge Page
• Mail Merge Sample Document File
• Mail Merge sample data File
• Create multiple certificates Assignment
• U15 Self-evaluation Checklist