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.
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. 💛💛💛😊😊😊
Great presentation of the basics. Straight forward info, and you are a good speaker. Everything I needed to create a simple sheet with sums all in one video. Many thanks.
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
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)
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
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.
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.
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?
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
I'd like to learn how to make one column add or subtract automatically. It seems impossible to find out how to do this as its so basic nobody seems to talk about it!. Calc has got to be about the most unintuitive program I've ever used in my life. You'd think you could just Right click the column and program it. But no. That would be logical. That would be conventional. Instead lets bury the function somewhere. Then maybe we can sell Help tutorials so people can actually locate it. All they need is a ? at the upper right of each window where you could drag to the area you are trying to find out about. Microsoft used to have this in their OS. One of the few good things they ever did. But of course that was abolished because it made too much sense.
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.
This thing calculates wrong, usually 20 or 40 short.. don't trust math it does for you... you literally have to check it's math... which makes it next to useless
The double-clicking between the columns is EXACTLY what I was looking for on my sheet. Thanks a lot!
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.
Thank you for this very informative and straightforward video! You are a blessing!
more tutorials on libre office please.
T.Hanks
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. 💛💛💛😊😊😊
You did a good job dude.
Before: Libre office I shit I need ms office back
After: I am shit, Libreoffice is as powerful as ms-excel.
hi i'm from Brazil,
Great presentation of the basics. Straight forward info, and you are a good speaker. Everything I needed to create a simple sheet with sums all in one video. Many thanks.
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
A great introductory video. Really addresses the basics of using Calc. Bravo!
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)
Thanks! very good tutorial
Wonderful job.....too much for newbies like me> All's I want to know is HOW to print my spread sheet page!!!!! HELP!!!
thanks man! great
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
just to ensure.....i got it...can you add a pdf file and attach it in one of the cells? ty
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.
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.
=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.
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?
Hi. It's because Libreoffice can't find the fonts you typed on. You'll have to install fonts manually from the internet.
Very helpful. Thank you!
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
Pretty amazing that all of this stuff is given away for free..
Thanks for the help.
aun sirve para el 2020?
Thanks
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
Same problem. Couldn't move or delete the chart, lost the file. Next time save the file first before going into chart.
I'd like to learn how to make one column add or subtract automatically. It seems impossible to find out how to do this as its so basic nobody seems to talk about it!. Calc has got to be about the most unintuitive program I've ever used in my life. You'd think you could just Right click the column and program it. But no. That would be logical. That would be conventional. Instead lets bury the function somewhere. Then maybe we can sell Help tutorials so people can actually locate it. All they need is a ? at the upper right of each window where you could drag to the area you are trying to find out about. Microsoft used to have this in their OS. One of the few good things they ever did. But of course that was abolished because it made too much sense.
its the same as excel so you can check from excel tutorials.
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.
This thing calculates wrong, usually 20 or 40 short.. don't trust math it does for you... you literally have to check it's math... which makes it next to useless