Skip to main content
Side panel
Home
More
English (en)
English (en)
Ελληνικά (el)
You are currently using guest access
Log in
Home
Open course index
Open Courses in English
LibreOffice
U15 - Calc Advanced & Mail Merge
VLOOKUP sample
File
VLOOKUP sample
VLOOKUP sample
Click
calc-vlookup-sample.ods
link to view the file.
◄ VLOOKUP Function
Jump to...
Jump to...
Announcements
Intro to the Course
Prior knowledge survey
Glossary
Forum
LibreOffice Getting Started Guide
LibreOffice.org main website
LibreOffice Documentation
Introduction to LibreOffice
Introduction to LibreOffice
Intro to LibreOffice Quiz 1
Get and install LibreOffice
LibreOffice Start Center
Setting Up LibreOffice
Change user data and locale
Getting Help
Intro to LibreOffice Quiz 2
Find software alternatives
Software suggestions
U01 Self-evaluation
LibreOffice downlad page
LibreOffice installation instructions
Ask LibreOffice
Writer a first look
Writer a first look demo file
Writer a first look Quiz
Open, Create and Save Documents
Create and save documents
Entering text with the keyboard
Basic Keyboard exersise
Selecting and moving text
Select, move and copy exercise
Find and Replace
Find and Replace demo file
Find and Replace
Intro to Writer Quiz
Plato's Bio
U02 Self-evaluation
Online typing lessons
LibreOffice Writer Documentation
Character formatting
Writer Quiz - Character formatting
Character formatting Exercise 1
Character formatting Exercise 2
Paragraph formatting
Writer Quiz - Paragraph formating
Paragraph formatting Exercise 1
Paragraph formatting Exercise 2
Bulleted and Numbered Lists
Writer Quiz - Bulleted and Numbered Lists
Bullets Numbering Exercise 1
Bullets Numbering Exercise 2
U03 Self-evaluation
Inserting images
Sample images
Insert image exercise
Positioning images
Positioning Image exercise 1
Positioning Image - Εxercise 2
Modify images
Modify image - Exercise 1
Modify Image Exercise 2
Working with Graphics Quiz
Creating Tables
Tables exercise 1
Table layout formatting
Sample table
Tables exercise 2
Table cell formatting
Tables exercise 3
U04 Self-evaluation
Random Data Generator
Page size, margins and orientation
Background and Borders
Page formatting Exersice 1
Headers and Footers
Header and Footer demo file
Numbering Pages
Page Formatting - Esxercise 2
Line and Page Breaks
Line and Page Break Demo
Tables for page layout
Tables for Layout Demo
Tables for layout exercise
Column Layout
Columns Layout exercice
Page Formatting Quiz
U05 Self-evaluation
Calendar
Printing
Print Preview sample file
Print Exercise
Hyperlinks
Footnotes and Endnotes
Footnotes and Endotes practice file
Links and Footnotes Exercise
Drawing Objects
Drawing Objects - Exercise
Fields and special characters
Language tools
Language Tools practice file
Check Spelling Exercise
Writer other Tools Quiz
U06 Self-evaluation
Intro to styles
Intro to Styles sample file
Working with styles
Working with Styles sample file
Modify and Create Styles
Resume - Exercise
Page Styles
Page Styles Demo
Page Styles Exercise
Character Styles
Character Styles Demo
Table of Contents
Table of Contents Exercise
Styles Quiz
Group assignment - Songs collection
U07 Self-evaluation
Templates
Creating a template
Letter template
Create a business letter template
Managing templates
Templates Quiz
Writer Final Project - Create a Student Report
Writer Final Quiz
Math formula editor
Math Exercise
U08 Self-evaluation
Introduction to Impress
Sample Presentation
Workspace Views
Slide basics
Working with Slides
Arrange Slides
Working with Text
Inserting and Modifying Objects
Formating Slides
Create a presentation
Presentation notes
Printing and exporting
Running a Slideshow
Impress Quiz 1 (Basics)
U09 Self-evaluation
Transitions and animations
Inserting Media
Photo album
Create a photo album
Master Slides
Create Master Slides
Impress Quiz 2
Group assignment - Present yourself
U10 Self-evaluation
Introduction to Draw
Drawing Basic Shapes
Draw Quiz 1
Editing drawing objects
Glue points, connectors and flow charts
Create a Flow Chart
Create an Organisational Chart
Create a Floor Plan
Grouping and Combining Multiple Objects
Create Vector Art
U11 Self-evaluation
Draw clouds
Introduction to Calc
Calc Basics Quiz 1
Navigating and Selecting within spreadsheets
Calc Basics Quiz 2
Working with columns, rows and sheets
Working with rows, columns and sheets sample file
Formatting Data
Formatting Cells
Calc Basics Quiz 3
Calc basics exercise
Create a weekly schedule
Format data table
U12 Self-evaluation
Formulas
Functions
Formulas and Functions sample file
Basic Functions
Monthly budget calculator
Business Invoice
IF Function
Relative and Absolute Reference
Teacher's Gradebook
Formulas and Functions Quiz
U13 Self-evaluation
Online Calc Functions Reference
Freezing and Spliting
Freeze and Split sample file
Sorting and Filtering
Sort and Fitler sample data
Conditional Formatting
Sort, Filter and Format data
Groups and Subtotals
Groups and Subtotals sample file
Charts
Chart Sample file
Create a Chart
Charts in Writer and Impress
Working with Data Quiz
U14 Self-evaluation
VLOOKUP Function
VLOOKUP Exercise
Pivot Tables
Pivot Table sample
Create a Pivot Table
Goal Seek
Goal Seek Sample
Goal Seek exercise
Mail Merge
Mail Merge Sample Document
Mail Merge sample data
Create multiple certificates
U15 Self-evaluation
Introduction to Databases
Introduction to Base
Books Database Sample
Tables
Queries
Forms
Reports
Base Quiz
Customers DataBase
U16 Self-evaluation
VLOOKUP Exercise ►