Learn LibreOffice Calc 6 in Under 30 MInutes | Complete Tutorial for Beginners

This tutorial includes explaining spreadsheets (rows, columns, cells), adding data, using functions on the data, customizing column format settings, and creating charts from datasets.

See My Full Software Courses

➣ Also Follow Me On

➣ If you like my videos, you can support the channel directly
Bitcoin: 17Pn5PifFmRkHRAqCZQAom1ZjCiSf7qJjJ
Ethereum: 0x6f2781F382952c8caCDbE99C46F07c265ab59627
Steem: @christutorials

[heatheralaynehome]

You're freekin' awesome! Thank you so much! I'm a lady of a certain age (code for old) and have still been using paper ledgers up to this point, but desperate to move to something simple that I already have on my computer. Your tutorial is exactly the speed and clarity I need to understand how to do my bookkeeping using a digital spreadsheet. I appreciate the simple step-by-step. I feel such relief. Thank you a thousand times over! Happy camper. 💛💛💛😊😊😊

[Tundra.]

The double-clicking between the columns is EXACTLY what I was looking for on my sheet. Thanks a lot!

[brainwithatwist]

Thank you this was so easily explained, i just switched to linux and never had to use spreadsheet before but now I'm in a med school and it's kinda make your daily life easy.

[daverage]

A great introductory video. Really addresses the basics of using Calc. Bravo!

[milo_thatch_incarnate]

Thank you for this very informative and straightforward video! You are a blessing!

[iran]

more tutorials on libre office please.
T.Hanks

[eirikmurito]

Pretty amazing that all of this stuff is given away for free..

[jasonhiggins.]

Hi great video, have you any idea how to edit incorrect names, company info in office libre CSV file. I have CSV files with email addresses etc but not all contacts have written their correct names. Instead there are random numbers or incomplete names. Can anyone tell me how to sort out my file into clean lists with correct names? Thanks Jason.

[ronnieocarter]

Great tutorial. I have a question, the red square that shows a cell contains a comment is stopping me reading the cell content. Is it possible to reduce the red square size or move it to the top left hand side of the cell. Or have you a better solution? regards Ron

[cliffsalisbury]

I made a check registrar and many times when I go to write in the cell and push shift for a capital letter the cursor jumps above to other cells in the column. This erases what is already in the cell. Is there a way to stop this. Everything else works fine. Thanks for your great videos.
editor

[joandow]

Hey, I am very new to Excel and found your video very useful however I am having a problem. I created a document but when I choose format changes, such as ascending date or capitalize each word the changes are not staying. The next time I enter a new date it is not being sorted, just staying the next row. Any advice?

[julyohidalgo]

and i like your videos cause i wanna to learn the libreoffice cause i change of operating system now i'm using linux before i was using windows but it is a pirated

[JR-kcrc]

just to got it...can you add a pdf file and attach it in one of the cells? ty

[reneelauderback]

Wonderful much for newbies like me> All's I want to know is HOW to print my spread sheet HELP!!!

[johnnyrosenberg]

=SUM(C1:C7) won't throw an error even if cells with text only are involved (C1 in your case). The value of C1 in this case is 0.

[teamcantgetright]

when I'm trying to insert the chart and going to enter the data my chart doesn't automatically move out the way so i can select my cells

[nikirose]

I want to make a very simple database with only, say, columns A to G. Is that even possible? I can't seem to find anything in Libre's menus or the online help.

Nvm. Sussed it.

[NicoTineman]

How can I do this? Let's say that I have the values 8 in cell A1, 888 in cell B8 and 999 in cell B9. I want to know the value in cell B(A1) aka B8 which would return 888. Then, if A1 were to have a value of 9, I want to know the value in cell B(A1) aka B9 which would return 999. In other words, I want to know the value of B(value of A1)

[rajeshnayak]

Before: Libre office I shit I need ms office back
After: I am shit, Libreoffice is as powerful as ms-excel.

[ronsmith]

Too fast, too fast do it slower a lot slower. I am a beginner not an expert!!!! At 11:40 on a border / line, so far it does not work. I have tried several times and I cannot make a line of any type.