Libre Office 7 Calc Spreadsheets Beginners Tutorial

preview_player
Показать описание
In this video tutorial, I will show you how to use Libre Office 7 Calc Spreadsheet for various data entry and manipulation tasks.

Here are the key concepts you will learn in this video Libre Office 7 Calc Spreadsheets Beginners tutorial:

00:00 Introduction
00:30 Chapter 1 - Open Libre Office Calc
01:00 Chapter 2 - Update Libre Office Calc Interface
02:13 Chapter 3 - Spreadsheet Columns and Rows
04:09 Chapter 4 - Additions Formula
07:39 Chapter 5 - Save Spreadsheet / File Formats
09:08 Chapter 6 - Copying Formulas
10:23 Chapter 7 - Subtraction Formula
11:38 Chapter 8 - Division Formula
12:20 Chapter 9 - Renaming Sheets
13:30 Chapter 10 - Creating a New Sheet
14:35 Chapter 11 - Personal Finance Spreadsheet
18:38 Chapter 12 - Changing Cell Format
19:36 Chapter 13 - Data Entry / Change Text Colour
23:43 Chapter 14 - Auto Sum Function
26:53 Chapter 15 - Copy Paste Spreadsheet Data
32:56 Chapter 16 - Create Column Charts
39:50 Chapter 16 - Changing Cell Background Colour
40:57 Chapter 17 - Printing Spreadsheet
41:26 Chapter 18 - Add Cell Borders
42:09 Chapter 19 - Change Spreadsheet to Landscape
43:24 Chapter 20 - Layout Content for Printing
46:58 Chapter 21 - Save Spreadsheet as PDF file
53:17 Chapter 22 - Create a Line Chart
53:56 Chapter 23 - Create a Pie Chart
1:00:28 Chapter 24 - Business Cost Spreadsheet
1:02:02 Chapter 25 - Text Style Formatting
1:02:30 Chapter 26 - Cell Type Formatting
1:03:52 Chapter 27 - Data Entry
1:10:08 Chapter 28 - Auto Filters
1:15:13 Chapter 29 - Cell Background Colour
1:18:21 Chapter 30 - Merging Cells
1:19:18 Chapter 31 - Inserting Rows and Columns
1:20:43 Chapter 32 - Final Overview

***********************************************************************************************

Booking Keeping Tutorials:

***********************************************************************************************

***********************************************************************************************

Contact me on:

#LibreOfficeCalc #Tutorial #dcpweb

libre office 7 calc spreadsheets beginners tutorial, libre office calc spreadsheets beginners tutorial, libre office calc spreadsheets tutorial, calc spreadsheets tutorial, calc spreadsheets beginners tutorial, libre spreadsheets beginners tutorial, spreadsheets beginners tutorial, spreadsheets tutorial, spreadsheet beginners tutorial, spreadsheet tutorial for beginners, libre spreadsheet tutorial for beginners, libre office spreadsheet tutorial for beginners, calc spreadsheet
Рекомендации по теме
Комментарии
Автор

Excellent tutorial . Just what I needed to start using Libre Calc. Why would anybody give a thumbs down for the tutorial I never know. I appreciate your effort and time presenting this video.Thank you

andyheatherbridge
Автор

What world are you living where prices keep going down?
:0
Great vid.
Extremely valuable for learning how to make my first spreadsheet at 47.
I wast just going to learn it for Necromunda but, this may have just changed my life.

relativeparadox
Автор

I'm showing this to a friend who knows NOTHING about spreadsheets. This is excellent!!!!

harrytornow
Автор

Thank you for the video. I am glad to have found a tutorial on LibreOffice Calc as well. I recently decided to learn spreadsheets and as usual there are more stuff on Excel which I have been using to learn Calc. This was refreshing. Thanks, once again.

ekeretteekpo
Автор

This video is the only decent one covering Libreoffice Calc that I've been able to find, I daresay more than decent, it's phenomenal with how hands on it is! Learning the concepts by actually creating some useful spreadsheets makes it stick so much better, and gives me ideas for what I might be able to do and make. Thank you so much for the tutorial!

TowelGamingHammer
Автор

Wonderful! I've been looking for something like this forever. Excellent tutorial. I'm very grateful.

davidspinelli
Автор

the explaination was really good thanks man. In less than 1 and a half hours you cleared so many concepts of mine thanks again. Needless to say, you are a great teacher.

Dev-refp
Автор

Perfect! I learned everything I needed to just by watching this tutorial. By the end of this video, I had my company’s spreadsheet ready for next years accounting. Thank you!

kcpstudio
Автор

That's very good explanation you're doing mate. Appreciate your work from my heart 💓

hirokjkonwar
Автор

I so appreciate this information. I knew nothing about calculation sheets using a computerized spreadsheet. This was wonderful. He covered a tremendous amount of information in a short video. I subscribed for more as well. Many, many thanks from a "happy beginner."

sykqhyl
Автор

This video was extremely helpful to me. I rarely dabble with Calc because I didn't understand it. This video started from ground zero and gradually gets to the more complicated features, which was easier to understand because you built on the basics. I will definitely be looking at your other videos.

timfisher
Автор

Humanity needs more videos like this one! Easy, straight to the point and very useful practical examples, very appreciated afforded

ryanmubarak
Автор

Incredible!!!! Loved it!!! So much information. 🙌🏻

mauricioflores
Автор

Love your tutorial, I am learning a lot with your help.
thank you

alstubblefield
Автор

Thank you for this tutorial! I needed a refresher since I have not used any spreadsheet software in around a decade. Thank you! Perfect video!

ninjamcstrange
Автор

Thank you so much for teaching me something I always wanted to learn! I truly appreciate you. I've been trying to improve as a person! So this guide was truly helpful!

SavingIndigo
Автор

You're a great teacher!
Thanks for this video tutorial.
Double dumbs up 👍👍

jayeff
Автор

Hi, I have been having a look at the export pdf to see if there is a simpler solution to selecting sheets to export. After a bit of testing I think I have found a solution. If you put your cursor over the sheet tab at the bottom of the sheets you can "hide" a sheet. You can make it reappear by selecting show sheets and making them reappear. I have tested this and the pdf export only exports sheets which are shown. I am really enjoying watching this tutorial, hope I found something that helps others.

wonderingworld
Автор

Thank you so much for this amazing videos. All your videos are actually so good and really helpful for those who want to learn how to use Libre office cal/writer. I have learnt so much things watching your videos. Please keep making such amazing and useful videos about Libre office cal/writer.

adhamkarimov
Автор

Great and simple.
Thanks a million ♥️

ikarimameen