Skip to main content
Side panel
elearn.ellak.gr
English (en)
English (en)
Ελληνικά (el)
You are currently using guest access (
Log in
)
LibreOffice
U01 - Intro to LibreOffice
U02 - Writer - Introduction
U03 - Writer - Text Formatting
U04 - Writer - Graphics and Tables
U05 - Writer - Page formatting
U06 - Writer - Some Other Tools
U07 - Writer - Working with Styles
U08 - Writer - Templates - Math
U09 - Impress 1 (Basics)
U10 - Impress 2 (Advanced)
U11 - Draw
U12 - Calc - Basics
U13 - Calc - Formulas and Functions
U14 - Calc - Working with Data
U15 - Calc Advanced & Mail Merge
U16 - Base
Home
Calendar
Use of LibreOffice for an office automation environment
Home
Courses
Open Courses in English
Digital Skills Courses
LibreOffice
U15 - Calc Advanced & Mail Merge
General
Announcements
Forum
Intro to the Course
File
Prior knowledge survey
Feedback
Glossary
Forum
Resources
LibreOffice Getting Started Guide
URL
LibreOffice.org main website
URL
LibreOffice Documentation
URL
◄
U14 - Calc - Working with Data
U16 - Base
►
U15 - Calc Advanced & Mail Merge
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
◄
U14 - Calc - Working with Data
U16 - Base
►
Jump to...
Main course page
U01 - Intro to LibreOffice
U02 - Writer - Introduction
U03 - Writer - Text Formatting
U04 - Writer - Graphics and Tables
U05 - Writer - Page formatting
U06 - Writer - Some Other Tools
U07 - Writer - Working with Styles
U08 - Writer - Templates - Math
U09 - Impress 1 (Basics)
U10 - Impress 2 (Advanced)
U11 - Draw
U12 - Calc - Basics
U13 - Calc - Formulas and Functions
U14 - Calc - Working with Data
U16 - Base