Learn LibreOffice now, start using the FREE suite: Calc

Name: Learn LibreOffice now, start using the FREE suite: Calc
Rating: 4.5 (129 reviews)

All you need to know about LibreOffice Calc, from the basics to taking advantage of all the major benefits it offers.

Created byPaolo Pelloni

Last updated 2/2022

English

What you'll learn

Learn how to use Calc to produce great looking documents: budgets, collections, complex spreadsheets
Learn how to use Calc to arrange and manipulate data and feed it to other programs
Use styles to be efficient and produce professional looking document
Calc formulas, how to make your work better
How to visualize data

Course content

5 sections • 37 lectures • 5h 29m total length

Promotional Video (watch me first)!3:02
Why this course is great for you? Why LibreOffice and what will you learn?
What Is This Course About And How To Get Most Out of It (batteries not included)3:40
An introduction to the course and the interaction. Watch this first if you want to get the best learning experience out of it.
Nice To Meet You, I Am Paolo!1:49
Who I am and what I do.
How to ask questions2:59
Introduce yourself (new)1:39
Please introduce yourself now, it will yield you more from this course!
Versions of LibreOffice11:38
Introduction To The World of LibreOffice13:48
Learn the different components of the LibreOffice suite and the overall picture.
Get More!1:00
More resources for you
Contact the instructor0:31

Hello, This Is Calc!16:24
An introduction to Calc: the main window components, the gui and the basic operations.
ABC, A Basic Calc20:21
Basic use of calc, learn how to move around, enter data and produce a simple budget.
Syntax, No Grammar8:07
On overview of some "syntax" rules and operators in Calc
Referencing (All The Way)17:51
Referencing correctly is so important, let's dig deeper!
Enter Calc (for merging)10:57
More on entering data in Calc. How to create a simple database to be used in mail-merge or e-mail merge (look in Writer course how to finish the mail-merge)
Functions (power of Calc)20:43
How and why using functions. How to enter them and benefit from the wizard.
Functions (for text)22:53
Use functions to manipulate text effectively.
Calc has style17:12
Use styles and formatting to make your spreasheet looking good and easier to read.
Bake a Pie10:01
How to create an effective pie chart using the wizard
Have a minute? Please leave a review!1:00
How are you enjoying this course?
I hope it is everything you expected and you are learning useful information.
If not, please let me know at paolo@paolopelloni.com or send me a message through Udemy.
If you are happy, please leave a positive review with a comment and a rating. You can do it whenever you are prompted to do so. It takes less than a minute and its a huge help to other students.
On top of that it will help the course rank higher in Udemy Search, which will make also me happy. :)
Don't forget you can edit your Review at any time.
Thank you very much for your help with this and enjoy the rest of the course!
Paolo
Manipulate (your data)12:10
Manipulate your data easily and prepare it for further processing.
Validate your data (avoid errors)15:09
How to validate user data.
Conditional Formatting19:15
Learn how to use conditional formatting to help your data express its message.
Pivot (no confusion!)21:39
Take manipulation further with powerful pivot tables.
Handy Tips: Split & Freeze5:52
Split & Freeze can be great to deal with large spreadsheet. What they are? When to use one or the other?
Handy Tips: Play With Sheets8:25
Sheets are an excellent way of organising your data. Here is how to manipulate them at best.

Speed up LibreOffice!4:24
Quickly make it faster in opening and handling documents.
Migrating from Microsoft Office (FAQ)1:31
Some frequently asked questions about switching from Microsoft Office to LibreOffice.
The Notebook Bar (enable it)6:11
What is the Notebook Bar and how to enable it.
Command and conquer8:33
LibreOffice 7.0: What's New?13:57
LibreOffice 7.1: What's New?5:50
Ask is lawful...16:02
..to Ask LibreOffice!

Requirements

A computer with LibreOffice installed (completely free for download)

Description

COURSE LAST REVIEW: JUNE 2025

JOIN OVER 5250 STUDENTS IN MY COURSES!

LibreOffice is a powerful free suite, learn how to use it at best to make your documents look good and support modern open document formats.

Learn all you need to know to use LibreOffice to full advantage!You are going to see the different components of LibreOffice and a series of how-to guides.

Calc, the spreadsheet.

From writing a simple budget to organise a collection to all you need to know to create complex spreadsheets. Learn fast input, formulas and tools that will make you more productive and achieve better results in lesser time. Customize LibreOffice to your liking and learn tools and extensions available that will make your life easier.

You will get:

Full, free lifetime access
All future extra lectures and upgrades are always included for free
Unconditional Udemy 30 day money-back guarantee - that's my personal promise of your success!

What do they say about Libreoffice courses?

"Great course! I really liked the course outline and content. Paolo's explanations are detailed yet easy to follow and he actually makes the course very enjoyable."

Customer review of the course (check the reviews for more information)

Buy now the course and start immediately to use LibreOffice, the free suite that supports open formats (and also Microsoft Office).

Who this course is for:

Anyone who is interested in taking a full advantage of a professional free suite

Learn LibreOffice now, start using the FREE suite: Calc

What you'll learn

Explore related topics

Course content

Welcome to LibreOffice9 lectures • 40min

Calc, the spreadsheet16 lectures • 3hr 48min

Exercises3 lectures • 1min

Extra7 lectures • 56min

This is the end (my friend)2 lectures • 6min

Requirements

Description

Who this course is for: