Libre Office Calc Spreadsheet Beginners Tutorial

[@CheapSushi]

Seriously thanks for this. It was very clear.

[@dcpwebdesigners]

Cool :)

[@nanosdoodles]

Wow, it's still relevant 8 years later. Great video :-)

[@dcpwebdesigners]

Cool 😎 more Libre Office Tutorials - Free Desktop Publishing Software: th-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

[@debprather4214]

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!!!

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@dcpwebdesigners]

More Libre Office Tutorials: th-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

[@geoffwhiles8223]

A great smooth and easy to understand tutorial. No faffing about, not drooling around, but clear concise and well paced. More please!!!!

[@dcpwebdesigners]

Many thanks :)

[@Vector_Ze]

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.

[@dcpwebdesigners]

+smart451cab cool :)

[@op561]

Man its people like you that make youtube great thanks alot for the information dude.

[@dcpwebdesigners]

cool :)

[@FeileCase]

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'

[@dcpwebdesigners]

+Feile Case many thanks, I also have a full bookkeeping tutorial on my TH-cam page, check it out...

[@artistic_cuber_md4444]

THIS HELPED ME ALOT IN MY
PROJECT 👌👌👌👌👍👍👍

[@dcpwebdesigners]

Great 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@enquery]

Excellent information. Never used spreadsheets, and now I know what I'm doing for starters. TY

[@dcpwebdesigners]

+enquery thanks!

[@lucksontembo6080]

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...

[@dcpwebdesigners]

Cool thanks 😊

[@hickorydock501]

What a great tutorial. So easy to follow. Thank you so much. All you need and no fluff.

[@dcpwebdesigners]

Thanks 👍

[@dcpwebdesigners]

More Libre Office Tutorials - Free Desktop Publishing Software: th-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@LincolnakaOnion]

Thanks.
The playlists on your channel makes it all easier. Thanks!

[@dcpwebdesigners]

Cool :)

[@DavidCollinsRivera]

Thanks so much for the simple, straight-forward tutorial!

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@adhamkarimov3558]

Thank you so much. This was so useful for me and it was so fun to learn with you

[@dcpwebdesigners]

Great 👍 thanks ☺️

[@dcpwebdesigners]

More Libre Office Tutorials - Free Desktop Publishing Software: th-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@clairepharoah969]

very easy instructions to follow thank you

[@dcpwebdesigners]

Thanks 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@artistic_cuber_md4444]

THIS IS AMIZING
BRO YOU ARE PRO

[@dcpwebdesigners]

Thanks 👍 more Libre Office Tutorials - Free Desktop Publishing Software: th-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

[@blankdotblank9482]

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!

[@dcpwebdesigners]

+Lrca Haag cool :) well done !

[@maxoct7331]

thank you very much for the filtering tools, that was very helpful

[@dcpwebdesigners]

+max habeeb thanks :)

[@Skylinesandsunsets]

Great tutorial. Easy to understand, helped me out a lot. Thank you, keep 'em coming!

[@dcpwebdesigners]

thanks. libre office writer tutorial next, check out my TH-cam page for loads of open office tutorials.

[@Bankside1997]

Thanks mate, very helpful.

[@dcpwebdesigners]

Thanks 😊

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@Krypterium]

a helpful basic tutorial ,thank u

[@dcpwebdesigners]

Thanks 😎

[@mr.curious4368]

Very nice job. One of the best tutorials I've ever seen.

[@dcpwebdesigners]

Many thanks 😎

[@tcr333]

Excellent tutorial. thank you

[@dcpwebdesigners]

Thanks 👍

[@dcpwebdesigners]

Would be awesome if you can give me a Google review 👍
g.page/dcpweb/review?gm

[@Doowi92]

very clear and nice tutorial thank you dude you helped me a lot

[@dcpwebdesigners]

Cool thanks 😎

[@zackdiarra4805]

I am learning something useful.. Thanks, indeed!

[@dcpwebdesigners]

Thanks 👍 have fun 👍
Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm

[@trglenn2421]

Very Helpful! Thank you!

[@dcpwebdesigners]

Cool 😎

[@63kavon]

Thank you. Very instructive.

[@dcpwebdesigners]

+Kevin Dunn thanks :)

[@robertmcmorrow911]

Thanks. The Video was helpful.

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@chrispennington2808]

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

[@dcpwebdesigners]

+Chris Pennington no this is not possible :(

[@sergeymarochkanich2283]

Great lesson! Have you any tutorials for advanced users of LibreOffice?

[@dcpwebdesigners]

Thanks 😎 all libre office tutorials I have created : th-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

[@dcpwebdesigners]

Open office : th-cam.com/play/PLRpn_0jbcinvBC_9_E1XUjpYwFVAnEKuH.html

[@dcpwebdesigners]

Bookkeeping : th-cam.com/play/PLRpn_0jbcinsDmrvlXrCLr4oNAa7NEyBm.html

[@sergeymarochkanich2283]

@@dcpwebdesigners Very nice! I've added your videos to my playlist.

[@isegarden1904]

Thanks! Very Helpful!

[@dcpwebdesigners]

Thanks 😎

[@johnpalma7265]

Is there a way to give the document a name?Is there more than 1 way?
Thanks for the jolly fine vid ole chap.

[@dcpwebdesigners]

+john palma you can use the file name and the tab in bottom left corner

[@eirikmurito]

Thanks man..

[@dcpwebdesigners]

Cool 😎 thanks 👍

[@NeonPossum]

Super helpful!! Thank you so much!!

[@dcpwebdesigners]

+Neon Possum thanks :)

[@gm8378]

This is great.

[@dcpwebdesigners]

Thanks 👍 have fun 😊

[@bigon42]

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.

[@丸チュンフン]

nice tutorial btw what is that keyboard i like its sound

[@dcpwebdesigners]

Thanks, was a cheap keyboard I got from Amazon years ago, look for slim windows keyboard on Amazon, cost was about £7 or £8

[@romey4you]

Can you please tell how to do filter by using color ?

[@dcpwebdesigners]

Not sure you can do that in Libreoffice, I know it's possible in excel, I will research more

[@dcpwebdesigners]

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

[@romey4you]

@@dcpwebdesigners Thank you for the research you did. I really appreciate it.

[@elusive.firstname.lastname]

best evar thanks man

[@dcpwebdesigners]

Many thanks 😊

[@MrDavePed]

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 :)
..

[@teresadaubsyoutube7283]

very helpful!!!!

[@dcpwebdesigners]

+teresa Daub thanks :)

[@jgunther3398]

What you're looking for starts at 2:45

[@chicku975]

Thanks very much !

[@dcpwebdesigners]

+SHACHINDRA TRIPATHI thanks :)

[@siddharthupponi8410]

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

[@dcpwebdesigners]

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

[@uttamprakash4309]

I already knew the all. But I watched.

[@garrygibbons2989]

i just want to put a tick in checkbox and sign a docx file how hard can that be? impossible for me lol

[@dcpwebdesigners]

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

[@coppercat8383]

good

[@dcpwebdesigners]

+mary hatley thanks :) check out my new blog www.dcpweb.co.uk

[@shortdakwah15]

hi admin, I want to download your video, thanks

[@navjotsingh2251]

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 “TH-cam 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

[@FM-ex1ei]

Mashallah, you help me

[@dcpwebdesigners]

Thanks 😎 have fun 👍

[@taraknathsam4572]

How yo creat calculate filed in pivot tabel in libre calc

[@dcpwebdesigners]

th-cam.com/video/0uQfxGNWvic/w-d-xo.html

[@NERVE-DAMAGE]

How do you DELETE columns ? Lets say.. From G and get rid of the infinity lettering

[@dcpwebdesigners]

+MetroplexC70 you can not permanently delete a column.

[@dcpwebdesigners]

+DCP Web Designers you can right click on the column delete and delete but this will only remove the content from the cells below...

[@KECOG]

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.

[@dcpwebdesigners]

Correct, much better 👍

[@ovcal4069]

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?

[@dcpwebdesigners]

+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...

[@ovcal4069]

thanks, how about imputing the same percentage in the whole column,how do I do that?

[@dcpwebdesigners]

+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

[@ovcal4069]

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?

[@dcpwebdesigners]

+Ov Cal cool well done, sorry I do not use wooecommerce platform, try a Google search?

[@dcpwebdesigners]

Libre Office Calc Beginners Tutorial: th-cam.com/video/HcpaIuOLCqo/w-d-xo.html

[@ballybunion9]

Lots of useful info on how to work Calc (thank you), but ... your thumping on the keys is very distracting and annoying.

[@dcpwebdesigners]

Opppsss

[@osvaldoayala955]

Que pena que sea en inglés este tutorial.

[@dcpwebdesigners]

Sorry it is the only language i know :)

[@klikitzsmith8416]

Not a very good tutorial

[@dcpwebdesigners]

So make one better ?

[@dcpwebdesigners]

Libre Office Calc Beginners Tutorial: th-cam.com/video/HcpaIuOLCqo/w-d-xo.html