Libre Office Calc Spreadsheet Beginners Tutorial

Поділитися
Вставка
  • Опубліковано 14 гру 2024

КОМЕНТАРІ • 131

  • @CheapSushi
    @CheapSushi 9 років тому +15

    Seriously thanks for this. It was very clear.

  • @debprather4214
    @debprather4214 4 роки тому +6

    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
      @dcpwebdesigners  4 роки тому

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  4 роки тому

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

  • @geoffwhiles8223
    @geoffwhiles8223 6 років тому +2

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

  • @nanosdoodles
    @nanosdoodles Рік тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  Рік тому

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

  • @op561
    @op561 7 років тому +15

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

  • @FeileCase
    @FeileCase 8 років тому +2

    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
      @dcpwebdesigners  8 років тому

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

  • @Vector_Ze
    @Vector_Ze 7 років тому +3

    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.

  • @hickorydock501
    @hickorydock501 3 роки тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

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

  • @artistic_cuber_md4444
    @artistic_cuber_md4444 3 роки тому +2

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

  • @LincolnakaOnion
    @LincolnakaOnion 6 років тому +2

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

  • @enquery
    @enquery 8 років тому +1

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

  • @lucksontembo6080
    @lucksontembo6080 6 років тому +1

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

  • @clairepharoah969
    @clairepharoah969 2 роки тому +1

    very easy instructions to follow thank you

  • @DavidCollinsRivera
    @DavidCollinsRivera 4 роки тому +1

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

  • @adhamkarimov3558
    @adhamkarimov3558 2 роки тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  2 роки тому

      Great 👍 thanks ☺️

    • @dcpwebdesigners
      @dcpwebdesigners  2 роки тому

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

    • @dcpwebdesigners
      @dcpwebdesigners  2 роки тому

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

  • @Krypterium
    @Krypterium 5 років тому +3

    a helpful basic tutorial ,thank u

  • @artistic_cuber_md4444
    @artistic_cuber_md4444 3 роки тому +2

    THIS IS AMIZING
    BRO YOU ARE PRO

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому +1

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

  • @Bankside1997
    @Bankside1997 3 роки тому +1

    Thanks mate, very helpful.

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому +1

      Thanks 😊

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому +1

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

  • @tcr333
    @tcr333 3 роки тому +1

    Excellent tutorial. thank you

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому +1

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

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

  • @Skylinesandsunsets
    @Skylinesandsunsets 9 років тому +7

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

    • @dcpwebdesigners
      @dcpwebdesigners  9 років тому +2

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

  • @maxoct7331
    @maxoct7331 8 років тому +3

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

  • @blankdotblank9482
    @blankdotblank9482 7 років тому +1

    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!

  • @mr.curious4368
    @mr.curious4368 6 років тому +1

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

  • @trglenn2421
    @trglenn2421 5 років тому +3

    Very Helpful! Thank you!

  • @Doowi92
    @Doowi92 4 роки тому +1

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

  • @63kavon
    @63kavon 7 років тому +1

    Thank you. Very instructive.

  • @robertmcmorrow911
    @robertmcmorrow911 4 роки тому +1

    Thanks. The Video was helpful.

  • @zackdiarra4805
    @zackdiarra4805 4 роки тому +1

    I am learning something useful.. Thanks, indeed!

    • @dcpwebdesigners
      @dcpwebdesigners  4 роки тому

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

  • @jgunther3398
    @jgunther3398 6 років тому

    What you're looking for starts at 2:45

  • @isegarden1904
    @isegarden1904 5 років тому +1

    Thanks! Very Helpful!

  • @sergeymarochkanich2283
    @sergeymarochkanich2283 6 років тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  6 років тому

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

    • @dcpwebdesigners
      @dcpwebdesigners  6 років тому

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

    • @dcpwebdesigners
      @dcpwebdesigners  6 років тому

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

    • @sergeymarochkanich2283
      @sergeymarochkanich2283 6 років тому +1

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

  • @chrispennington2808
    @chrispennington2808 8 років тому +1

    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
      @dcpwebdesigners  8 років тому

      +Chris Pennington no this is not possible :(

  • @eirikmurito
    @eirikmurito 3 роки тому +1

    Thanks man..

  • @NeonPossum
    @NeonPossum 7 років тому +1

    Super helpful!! Thank you so much!!

  • @gm8378
    @gm8378 3 роки тому

    This is great.

  • @romey4you
    @romey4you 3 роки тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

      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
      @romey4you 3 роки тому +1

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

  • @elusive.firstname.lastname
    @elusive.firstname.lastname 6 років тому +1

    best evar thanks man

  • @siddharthupponi8410
    @siddharthupponi8410 3 роки тому +1

    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
      @dcpwebdesigners  3 роки тому

      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

  • @丸チュンフン
    @丸チュンフン 6 років тому +1

    nice tutorial btw what is that keyboard i like its sound

    • @dcpwebdesigners
      @dcpwebdesigners  6 років тому +1

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

  • @johnpalma7265
    @johnpalma7265 7 років тому +1

    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
      @dcpwebdesigners  7 років тому

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

  • @teresadaubsyoutube7283
    @teresadaubsyoutube7283 7 років тому +1

    very helpful!!!!

  • @chicku975
    @chicku975 7 років тому +1

    Thanks very much !

  • @bigon42
    @bigon42 7 років тому

    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.

  • @uttamprakash4309
    @uttamprakash4309 6 років тому +1

    I already knew the all. But I watched.

  • @MrDavePed
    @MrDavePed 5 років тому

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

  • @taraknathsam4572
    @taraknathsam4572 5 років тому +1

    How yo creat calculate filed in pivot tabel in libre calc

  • @coppercat8383
    @coppercat8383 7 років тому +2

    good

    • @dcpwebdesigners
      @dcpwebdesigners  7 років тому

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

  • @garrygibbons2989
    @garrygibbons2989 3 роки тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 роки тому

      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

  • @shortdakwah15
    @shortdakwah15 7 років тому

    hi admin, I want to download your video, thanks

    • @navjotsingh2251
      @navjotsingh2251 6 років тому +1

      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 “UA-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
    @FM-ex1ei 5 років тому +1

    Mashallah, you help me

  • @NERVE-DAMAGE
    @NERVE-DAMAGE 7 років тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  7 років тому

      +MetroplexC70 you can not permanently delete a column.

    • @dcpwebdesigners
      @dcpwebdesigners  7 років тому

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

  • @ovcal4069
    @ovcal4069 7 років тому +1

    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
      @dcpwebdesigners  7 років тому

      +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
      @ovcal4069 7 років тому +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  7 років тому

      +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
      @ovcal4069 7 років тому +1

      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
      @dcpwebdesigners  7 років тому

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

  • @KECOG
    @KECOG 3 роки тому

    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
    @dcpwebdesigners  9 років тому +1

    Libre Office Calc Beginners Tutorial: ua-cam.com/video/HcpaIuOLCqo/v-deo.html

  • @ballybunion9
    @ballybunion9 5 років тому +1

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

  • @osvaldoayala955
    @osvaldoayala955 3 роки тому

    Que pena que sea en inglés este tutorial.

  • @klikitzsmith8416
    @klikitzsmith8416 4 роки тому

    Not a very good tutorial

  • @dcpwebdesigners
    @dcpwebdesigners  9 років тому +1

    Libre Office Calc Beginners Tutorial: ua-cam.com/video/HcpaIuOLCqo/v-deo.html