Due to the cost factor of updating my office suite, I've been using the now 14-year-old MS Office 2003. Tonight I'm installing LibreOffice, so your tutorials are going to be very helpful in bringing me up to current standards! But, I've gotta say I was glad you got into Calc and away from your OS, that hurt my eyes. Thanks for posting this and your other tutorials.
Thank you DCP Web... I found this video VERY helpful. I'm an Independent Artist and work in Denver, Colorado, USA. I've been using Libre Office for several years now for my WORD Documents and now need to learn to use Spreadsheets too to keep track of my sales. I also do some other work so this is very helpful. Your tutorial will help me a great deal and I look forward to watching and learning even MORE from your Other Libre Office Tutorials. 'thumbs up'
thanks a lot. was used to the MS office way of things. now want to change to libre office and I fortunately bumped into this video. i will watch all the videos you have done on libre and open office.Thanks a lot once more...
Thank you so much! I needed to do just some basic spreadsheets with a lot of different sum data for my home buisness and i had downloaded the software but had no idea how to do so! got it first try thanks to this great tutorial!
great information but my question is can you add a column on the left side where the numbers are for if your keeping track of inventory an you acquire a new item to add it in
Hi, Can you help me with LibreOffice Calc - I have multiple links on different rows and I want to open them all on browser (multiple tabs). Similar to using the Hyperlink function in Excel. I don't know how to do it in LibreOffice Calc
I did some check and I don't think that is possible in libre office, you would need to create another column to identify rows by colour using a text label, the use that as the filter
Hi what function do I use to determine the monthly payment on an amortization? I'd like to input the number of months and the interest rate and the amount of the loan. I'd like to generate the monthly payment amount. Thanks much :) ..
As of 2021, Openoffice has basically been orphaned; no updates for years. LibreOffice is much more modern, as of now, version 7.x.x. is what is being used.
pieter cloete no it’s not impossible, there is a truckload of applications that can download this video or even websites just go to your browser and search for “CZcams video downloader”and I am 100% sure you will find something that works. I personally use Tubidy on my IPad so I can download videos and watch them whenever and wherever offline
Seriously thanks for this. It was very clear.
Cool :)
I'm a senior learning computer skills on my own and was trying to figure this out for years. Extremely easy to follow and apply. Thank you so much!!!
Cool 😎 thanks 👍
More Libre Office Tutorials: czcams.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html
Wow, it's still relevant 8 years later. Great video :-)
Cool 😎 more Libre Office Tutorials - Free Desktop Publishing Software: czcams.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html
Man its people like you that make youtube great thanks alot for the information dude.
cool :)
THIS HELPED ME ALOT IN MY
PROJECT 👌👌👌👌👍👍👍
Great 👍
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
A great smooth and easy to understand tutorial. No faffing about, not drooling around, but clear concise and well paced. More please!!!!
Many thanks :)
Due to the cost factor of updating my office suite, I've been using the now 14-year-old MS Office 2003.
Tonight I'm installing LibreOffice, so your tutorials are going to be very helpful in bringing me up to current standards! But, I've gotta say I was glad you got into Calc and away from your OS, that hurt my eyes. Thanks for posting this and your other tutorials.
+smart451cab cool :)
THIS IS AMIZING
BRO YOU ARE PRO
Thanks 👍 more Libre Office Tutorials - Free Desktop Publishing Software: czcams.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html
Thank you DCP Web... I found this video VERY helpful. I'm an Independent Artist and work in Denver, Colorado, USA. I've been using Libre Office for several years now for my WORD Documents and now need to learn to use Spreadsheets too to keep track of my sales. I also do some other work so this is very helpful. Your tutorial will help me a great deal and I look forward to watching and learning even MORE from your Other Libre Office Tutorials. 'thumbs up'
+Feile Case many thanks, I also have a full bookkeeping tutorial on my CZcams page, check it out...
very easy instructions to follow thank you
Thanks 👍
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
Excellent information. Never used spreadsheets, and now I know what I'm doing for starters. TY
+enquery thanks!
thanks a lot. was used to the MS office way of things. now want to change to libre office and I fortunately bumped into this video. i will watch all the videos you have done on libre and open office.Thanks a lot once more...
Cool thanks 😊
a helpful basic tutorial ,thank u
Thanks 😎
Excellent tutorial. thank you
Thanks 👍
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
What a great tutorial. So easy to follow. Thank you so much. All you need and no fluff.
Thanks 👍
More Libre Office Tutorials - Free Desktop Publishing Software: czcams.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
Thanks.
The playlists on your channel makes it all easier. Thanks!
Cool :)
Thanks mate, very helpful.
Thanks 😊
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
Thank you so much! I needed to do just some basic spreadsheets with a lot of different sum data for my home buisness and i had downloaded the software but had no idea how to do so! got it first try thanks to this great tutorial!
+Lrca Haag cool :) well done !
Thanks so much for the simple, straight-forward tutorial!
Cool 😎 thanks 👍
thank you very much for the filtering tools, that was very helpful
+max habeeb thanks :)
Great tutorial. Easy to understand, helped me out a lot. Thank you, keep 'em coming!
thanks. libre office writer tutorial next, check out my CZcams page for loads of open office tutorials.
Thanks man..
Cool 😎 thanks 👍
I am learning something useful.. Thanks, indeed!
Thanks 👍 have fun 👍
Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm
Thank you so much. This was so useful for me and it was so fun to learn with you
Great 👍 thanks ☺️
More Libre Office Tutorials - Free Desktop Publishing Software: czcams.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html
Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm
very clear and nice tutorial thank you dude you helped me a lot
Cool thanks 😎
Very Helpful! Thank you!
Cool 😎
Thank you. Very instructive.
+Kevin Dunn thanks :)
Thanks. The Video was helpful.
Cool 😎 thanks 👍
Very nice job. One of the best tutorials I've ever seen.
Many thanks 😎
This is great.
Thanks 👍 have fun 😊
Thanks! Very Helpful!
Thanks 😎
best evar thanks man
Many thanks 😊
Super helpful!! Thank you so much!!
+Neon Possum thanks :)
Thanks very much !
+SHACHINDRA TRIPATHI thanks :)
very helpful!!!!
+teresa Daub thanks :)
I already knew the all. But I watched.
great information but my question is can you add a column on the left side where the numbers are for if your keeping track of inventory an you acquire a new item to add it in
+Chris Pennington no this is not possible :(
very nice but what I want to do is write a macro so than by putting in yes invoice paid it will put on the date gen an invoice number.
good
+mary hatley thanks :) check out my new blog www.dcpweb.co.uk
Great lesson! Have you any tutorials for advanced users of LibreOffice?
Thanks 😎 all libre office tutorials I have created : czcams.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html
Open office : czcams.com/play/PLRpn_0jbcinvBC_9_E1XUjpYwFVAnEKuH.html
Bookkeeping : czcams.com/play/PLRpn_0jbcinsDmrvlXrCLr4oNAa7NEyBm.html
@@dcpwebdesigners Very nice! I've added your videos to my playlist.
Hi, Can you help me with LibreOffice Calc - I have multiple links on different rows and I want to open them all on browser (multiple tabs). Similar to using the Hyperlink function in Excel. I don't know how to do it in LibreOffice Calc
Sorry, not sure if that's possible as you can only open a single link at a time when you click on them in Libre office
Is there a way to give the document a name?Is there more than 1 way?
Thanks for the jolly fine vid ole chap.
+john palma you can use the file name and the tab in bottom left corner
Can you please tell how to do filter by using color ?
Not sure you can do that in Libreoffice, I know it's possible in excel, I will research more
I did some check and I don't think that is possible in libre office, you would need to create another column to identify rows by colour using a text label, the use that as the filter
@@dcpwebdesigners Thank you for the research you did. I really appreciate it.
Mashallah, you help me
Thanks 😎 have fun 👍
nice tutorial btw what is that keyboard i like its sound
Thanks, was a cheap keyboard I got from Amazon years ago, look for slim windows keyboard on Amazon, cost was about £7 or £8
Hi what function do I use to determine the monthly payment on an amortization? I'd like to input the number of months and the interest rate and the amount of the loan.
I'd like to generate the monthly payment amount.
Thanks much :)
..
How yo creat calculate filed in pivot tabel in libre calc
czcams.com/video/0uQfxGNWvic/video.html
i just want to put a tick in checkbox and sign a docx file how hard can that be? impossible for me lol
I'll try and make a tutorial but I've never done that before. To be honest, there must be a way to create signable documents
Libre Office Calc Beginners Tutorial: czcams.com/video/HcpaIuOLCqo/video.html
What you're looking for starts at 2:45
How do you DELETE columns ? Lets say.. From G and get rid of the infinity lettering
+MetroplexC70 you can not permanently delete a column.
+DCP Web Designers you can right click on the column delete and delete but this will only remove the content from the cells below...
As of 2021, Openoffice has basically been orphaned; no updates for years. LibreOffice is much more modern, as of now, version 7.x.x. is what is being used.
Correct, much better 👍
if you input from 1 to 20000 in a column, how do you do it easier?...do you keep dragging with the mouse down? or can I do it easier?
+Ov Cal sorry not sure of any easy way to do this... If I find a way I will post a video and send you link...
thanks, how about imputing the same percentage in the whole column,how do I do that?
+Ov Cal you can click on the letter column to highlight all and then paste data, remember to set field as percentage type if required
thanks,I solved it by pressing CTRL while dragging the mouse, I have
another question,do you know of any way to bulk upload listings on
woocomerce?
+Ov Cal cool well done, sorry I do not use wooecommerce platform, try a Google search?
hi admin, I want to download your video, thanks
pieter cloete no it’s not impossible, there is a truckload of applications that can download this video or even websites just go to your browser and search for “CZcams video downloader”and I am 100% sure you will find something that works. I personally use Tubidy on my IPad so I can download videos and watch them whenever and wherever offline
Lots of useful info on how to work Calc (thank you), but ... your thumping on the keys is very distracting and annoying.
Opppsss
Que pena que sea en inglés este tutorial.
Sorry it is the only language i know :)
Not a very good tutorial
So make one better ?
Libre Office Calc Beginners Tutorial: czcams.com/video/HcpaIuOLCqo/video.html