Calc Crash Course (2025)

Gain confidence in using LibreOffice Calc with this companion video course!

What's in the Course?

If you're fairly new to spreadsheets, or have used other spreadsheet programs such as Microsoft Excel or Google Sheets, this course will be resourceful for you.

Over 30 video tutorials and tips, based on the wonderful Getting Started Guide by LibreOffice.
3 extra video modules covering topics such as keyboard shortcuts, using AI, and student Q&A.
Access to the Office Nifty membership community portal to receive further resources, make posts and ask questions, and to interact with other students.

As a Special Promotion to the first 30 students, you will be able to join the premium package for free!

Make sure to select the premium package during the checkout process.

The Premium Package includes:

Schedule direct 30-minute tutoring or coaching sessions to resolve Calc issues, and consult about using Calc for your personal or professional needs.
Attend weekly livestream Drop-Ins for Question and Answer sessions along with other students.
Receive video responses to questions submitted directly by you.
Download extra resources such as PDF cheat sheets, templates, or macro libraries.

Bonus Packages (free during beta)

I'm pre-enrolling students starting in September. If you sign up for the course today, you will secure these bonuses before the Launch Price is set!

Import your Data Fast

Copy and paste multiple rows and columns to save time
Get table data from a webpage, CSV file, Excel file, or Google Sheets.

Transform your Data

Applying the correct number format or type for each column
Combine or split text in cells
Remove duplicated or empty rows
Prepare your table for formulas and accurate analysis

Organize Data for Analysis

Sorting rows and columns
Using functions to accurately analyze your data XLOOKUP,
Use charts and graphs to learn the data

Create Spreadsheet Templates

Save time by reusing a weekly calendar, monthly budget planner
Create forms for coworkers or customers to use

Present, Export, or Share Your Sheets

Present your sheet or analysis to impress your boss
Export into Excel or Google Sheets to keep working on other computers.
Best ways to share your Calc Sheet, and backup sheets properly

Fix and Troubleshoot your Sheet

Formatting, formulas, and sheets sometimes act up. Find out how to fix problems
Error codes and alerts glossary

Use Macros to Save Time

Figure out which repetitive tasks could be done by a macro instead of you.
Try to record or create your own macros
A friend sent you his macro? Learn how to enable and use it.

Print Sheets Perfectly

How to make sure the content fills the whole page and doesn't split into a second page

Choose a pricing plan

Founding Members Plan

This course is free. Yep, you read that right! 💸

I'm creating new lessons every few weeks in Summer 2025. I'd be happy to have you learn with others using this course. 😀

Happy spreadsheeting! 📊

Course curriculum

The outline below is just the start. More lessons will be published in the coming weeks based on the Getting Started Guide, such as:

Working with columns, rows, and cells
Entering, editing, and formatting data
Analyzing data, pivot tables and pivot charts
Sheet layout and Page Printing
and other lessons based on your feedback!

1

Welcome to the Calc Crash Course!
- Why and how to use this video course for your learning
- What is Calc?
- Compatibility with other spreadsheet applications
- Spreadsheets, sheets, and cells
2

Calc main window
- Title bar, menu bar, and toolbars
- Formula bar
- Status bar
3

Opening and importing a CSV file
- Opening a CSV file
- Text import dialog
4

Saving spreadsheets
- Saving files in different formats
- Exporting values and formulas as a CSV file
5

Importing external data – Web Query
- External Data dialog
6

Navigating within spreadsheets
- Cell, sheet, and keyboard navigation
7

Selecting items in a spreadsheet
- Selecting cells, columns, rows, and sheets
8

Working with columns and rows
- Inserting, hiding, and deleting columns and rows
9

Working with sheets
- Inserting, moving, copying, hiding, and renaming sheets
10

Viewing a spreadsheet
- Changing views, freezing rows, and splitting the screen
11

Entering data using the keyboard
- Entering Numbers, Text, Date and Time
12

Speeding up data entry
- AutoInput tool and filling cells with selection lists
13

Sharing content between sheets
- Enter data simultaneously into multiple sheets
14

Validating cell contents
- Add data validation to cells
15

Editing data
- Replacing, changing, and deleting data
16

Formatting data
- Wrapping, merging and splitting cells
17

Using AutoFormat on cells
- Using default templates to apply table colors and formats
- Get creative and save your own table formatting
18

Using themes
- Spreadsheet and document themes
19

Using conditional formatting
- Enable AutoCalculate
20

Filtering data
- Using AutoFilter, standard and advanced filters
21

Cell protection
- Password protection to prevent changes
22

Sorting records
- Sort your table on multiple columns and criteria
23

Cell comments
- Add small notes or tooltips
24

Using formulas and functions
- Select from built-in functions: Date & Time, FInancial, Information, Logical, Mathematical, Array, Statistical, Spreadsheet, Text, and Add-in
25

Analyzing data
- Using the Tools and Data menus
26

Pivot tables and pivot charts
- Create your first pivot table and pivot chart
27

Printing
- Print ranges, options, page breaks, headers and footers
28

BONUS: Keyboard Shortcuts
- Keyboard shortcuts for Menu bar and toolbars
- Setting custom keyboard shortcuts
29

BONUS: Different ways AI can help in using Calc
- Ask AI to generate a populated table to use in your sheet
- Ask AI to suggest which functions to use
- Let AI analyze table data and suggest useful information
30

BONUS: Q&A Videos and Extra Lessons
- Student asks: How can I get rid of empty rows quickly?