Libre Office 7 Calc Spreadsheets Beginners Tutorial

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 พ.ย. 2024

ความคิดเห็น • 262

  • @andyheatherbridge5739
    @andyheatherbridge5739 3 ปีที่แล้ว +38

    Excellent tutorial . Just what I needed to start using Libre Calc. Why would anybody give a thumbs down for the tutorial I never know. I appreciate your effort and time presenting this video.Thank you

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Manny thanks 👍 have a super day 🚀

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

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

    • @phillipcroukamp1825
      @phillipcroukamp1825 2 ปีที่แล้ว

      Some poeple wake up mad that thry got a small winky, so they take it out on others
      Miserable c=nts

  • @harrytornow3808
    @harrytornow3808 2 ปีที่แล้ว +4

    I'm showing this to a friend who knows NOTHING about spreadsheets. This is excellent!!!!

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว +1

      Thanks 👍 have fun 😊

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว +1

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

  • @TowelGamingHammer
    @TowelGamingHammer 2 ปีที่แล้ว +10

    This video is the only decent one covering Libreoffice Calc that I've been able to find, I daresay more than decent, it's phenomenal with how hands on it is! Learning the concepts by actually creating some useful spreadsheets makes it stick so much better, and gives me ideas for what I might be able to do and make. Thank you so much for the tutorial!

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Cool thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @timfisher6485
    @timfisher6485 2 ปีที่แล้ว +6

    This video was extremely helpful to me. I rarely dabble with Calc because I didn't understand it. This video started from ground zero and gradually gets to the more complicated features, which was easier to understand because you built on the basics. I will definitely be looking at your other videos.

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Great Tim, have fun learning new skills 🚀

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @ryanmubarak5646
    @ryanmubarak5646 2 ปีที่แล้ว +3

    Humanity needs more videos like this one! Easy, straight to the point and very useful practical examples, very appreciated afforded

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว +1

      Thank you for your comments 👍 have fun learning new skills 😊

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @wonderingworld119
    @wonderingworld119 ปีที่แล้ว +2

    Hi, I have been having a look at the export pdf to see if there is a simpler solution to selecting sheets to export. After a bit of testing I think I have found a solution. If you put your cursor over the sheet tab at the bottom of the sheets you can "hide" a sheet. You can make it reappear by selecting show sheets and making them reappear. I have tested this and the pdf export only exports sheets which are shown. I am really enjoying watching this tutorial, hope I found something that helps others.

  • @AgeingAardvark
    @AgeingAardvark ปีที่แล้ว +1

    Maybe you've already been told this but to print just the current worksheet to pdf, you can highlight the entire worksheet then use the 'Export' option and choose pdf format. Good Tutorial. Thank you.

  • @MarshaHague-u7d
    @MarshaHague-u7d 6 หลายเดือนก่อน +1

    I so appreciate this information. I knew nothing about calculation sheets using a computerized spreadsheet. This was wonderful. He covered a tremendous amount of information in a short video. I subscribed for more as well. Many, many thanks from a "happy beginner."

  • @ekeretteekpo3004
    @ekeretteekpo3004 2 ปีที่แล้ว +2

    Thank you for the video. I am glad to have found a tutorial on LibreOffice Calc as well. I recently decided to learn spreadsheets and as usual there are more stuff on Excel which I have been using to learn Calc. This was refreshing. Thanks, once again.

  • @kcpstudio
    @kcpstudio ปีที่แล้ว +1

    Perfect! I learned everything I needed to just by watching this tutorial. By the end of this video, I had my company’s spreadsheet ready for next years accounting. Thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Thanks 🙏 also watch th-cam.com/video/XDnBV-Tlb2g/w-d-xo.html

  • @Dev-re6fp
    @Dev-re6fp 3 ปีที่แล้ว +5

    the explaination was really good thanks man. In less than 1 and a half hours you cleared so many concepts of mine thanks again. Needless to say, you are a great teacher.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

      Thanks 👍 have fun 😊

    • @Dev-re6fp
      @Dev-re6fp 3 ปีที่แล้ว

      @@dcpwebdesigners 😊🤗

  • @relativeparadox9567
    @relativeparadox9567 6 หลายเดือนก่อน +2

    What world are you living where prices keep going down?
    :0
    Great vid.
    Extremely valuable for learning how to make my first spreadsheet at 47.
    I wast just going to learn it for Necromunda but, this may have just changed my life.

  • @lefaver
    @lefaver 3 ปีที่แล้ว +1

    Just checked most of your listed videos on Libre calcu and none of them discuss how to develop a data entry form within calcu. It seems this would be a very good addition to your series.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Ok thanks 👍 I will try working on that

  • @RajinderYadav
    @RajinderYadav 3 ปีที่แล้ว +6

    Decided to finally add to my basic knowledge, this video really taught me some new things. Definitely will cut down time how I was doing thing before, including entering a basic formula, love the filtering tip!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @RajinderYadav
    @RajinderYadav 3 ปีที่แล้ว +9

    47:40 I think you can ignore sheet when creating a PDF file by going to "Print", select "Print to file" and from there select the pages or ranges you want to save to the PDF.

  • @lolitbairiganjan2940
    @lolitbairiganjan2940 10 หลายเดือนก่อน +1

    One of the best explained tutorials.

  • @bahar770
    @bahar770 ปีที่แล้ว +1

    Thanks. Would you have a video how to define and print sheets.

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Sorry I don't have that, but I will try to make a tutorial for that soon, in excel you normally only select the cells you want to print and then select print / selected only

  • @TowelGamingHammer
    @TowelGamingHammer 2 ปีที่แล้ว +2

    For positioning the graphs with more pinpoint precision, you can right click on the graph and select Position and Size to set direct numbers. For exporting to PDF and leaving certain spreadsheets out of the export, select the sheet you want to hide, right click and select Hide Sheet, then do the PDF export. Once the export's done and you want the sheet back, right click on the sheets bar and select Show Sheet, and then the sheet you want to unhide, and then click Ok.
    Hope this helps others!

  • @davidspinelli6834
    @davidspinelli6834 ปีที่แล้ว +1

    Wonderful! I've been looking for something like this forever. Excellent tutorial. I'm very grateful.

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

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

  • @steelbak-customs
    @steelbak-customs 3 ปีที่แล้ว +2

    Omg, the taxes... But seriously, thank you for the time you put into this. Very helpful.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍 have fun 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @wingshonda2799
    @wingshonda2799 9 หลายเดือนก่อน +1

    GREAT Tutorial. is there away to to default a font and file location

    • @dcpwebdesigners
      @dcpwebdesigners  9 หลายเดือนก่อน

      No I don't think so, you can make a default file and copy to use as a starting template

  • @ninjamcstrange
    @ninjamcstrange 3 ปีที่แล้ว +1

    Thank you for this tutorial! I needed a refresher since I have not used any spreadsheet software in around a decade. Thank you! Perfect video!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Cool 😎 thanks 👍 have fun 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @adhamkarimov3558
    @adhamkarimov3558 2 ปีที่แล้ว +1

    Thank you so much for this amazing videos. All your videos are actually so good and really helpful for those who want to learn how to use Libre office cal/writer. I have learnt so much things watching your videos. Please keep making such amazing and useful videos about Libre office cal/writer.

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍 will make more videos when I get some free time

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @DrDrGerhard
    @DrDrGerhard 2 ปีที่แล้ว +1

    Great beginners tutorial. Any idea how to do things like XLookup and Power Query in LO Calc?

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍 not sure I will have to research that or try a Google search 🔍

  • @michaeldaus6348
    @michaeldaus6348 3 ปีที่แล้ว +2

    I wanted to say thank you for this amazing guide sir! You are a kind soul and an individual who truly gives back to his community. Bless you.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @michaeldaus6348
      @michaeldaus6348 3 ปีที่แล้ว

      @@dcpwebdesigners Out of curiosity sir, do you employ your fan base at all?

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

      No sorry, I already have full time staff, I make websites in my business

    • @michaeldaus6348
      @michaeldaus6348 3 ปีที่แล้ว +1

      @@dcpwebdesigners I don't mind leaving a review, I will, and I apologize for the overly forward question.

  • @kimnux
    @kimnux 11 หลายเดือนก่อน +1

    덕분에 기초적인 내용 잘 배웠습니다. 감사합니다.

  • @cbbcbb6803
    @cbbcbb6803 ปีที่แล้ว +1

    An excellent tutorial. I would like your bookkeeping tutorial re-done using Calc.

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Ok I will give it a go 😊

    • @cbbcbb6803
      @cbbcbb6803 ปีที่แล้ว

      @@dcpwebdesigners Grest. I'll be patient and wait.

  • @alstubblefield9570
    @alstubblefield9570 2 ปีที่แล้ว +2

    Love your tutorial, I am learning a lot with your help.
    thank you

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Great 👍 thanks 😎

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @hirokjkonwar8622
    @hirokjkonwar8622 3 ปีที่แล้ว +2

    That's very good explanation you're doing mate. Appreciate your work from my heart 💓

  • @mauricioflores3732
    @mauricioflores3732 ปีที่แล้ว +1

    Incredible!!!! Loved it!!! So much information. 🙌🏻

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

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

  • @jayeff4457
    @jayeff4457 2 ปีที่แล้ว +1

    You're a great teacher!
    Thanks for this video tutorial.
    Double dumbs up 👍👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @bobm3616
    @bobm3616 3 ปีที่แล้ว +1

    Question: do you have a tutorial on adding check boxes to librecalc. Need this capability, but am a novice to Librecalc. Thanks for the above view.

  • @SavingIndigo
    @SavingIndigo 2 ปีที่แล้ว +1

    Thank you so much for teaching me something I always wanted to learn! I truly appreciate you. I've been trying to improve as a person! So this guide was truly helpful!

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว +1

      Thanks 👍 have fun 😊

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @karthiktv8912
    @karthiktv8912 3 ปีที่แล้ว +1

    Nice video dude finally I learnt Libre calc from your video 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Great 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @saud9947
    @saud9947 3 ปีที่แล้ว +1

    You can also use in 1:09:30 =IF(C2="","NO","YES"). Rather than manually inputting it.
    Great video

  • @djolds1
    @djolds1 3 ปีที่แล้ว +1

    An excellent introduction. Thank you.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @navjotsingh2251
    @navjotsingh2251 3 ปีที่แล้ว +1

    Can you do a playlist about how to use the basic programming language with libre office? Not many good tutorials for beginners and I would be forever grateful

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

      I will give it a try when I get free time 👍

    • @navjotsingh2251
      @navjotsingh2251 3 ปีที่แล้ว +1

      @@dcpwebdesigners thanks for the response! You can do tutorials like how to automate libre office, how to scrape data from website, programming concepts like: oop, functions, APIs, data types, variables etc. There's lots of opportunities to make videos on Basic!

  • @ayyur66
    @ayyur66 3 ปีที่แล้ว +1

    Thanks for your informative video.A tutorial about attendance automatised sheet for class will be very helpful.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

      Ok I will try to make one soon

    • @ayyur66
      @ayyur66 3 ปีที่แล้ว +1

      @@dcpwebdesigners thank you so much

  • @enigma6925
    @enigma6925 2 ปีที่แล้ว +1

    Great Job, easy to follow, genius, thanks 🤩

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      More Libre Office Tutorials - Free Desktop Publishing Software: th-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

  • @fiazkhan289
    @fiazkhan289 2 ปีที่แล้ว +1

    can you make a tutorial for stocks adding

  • @benoitvibes5887
    @benoitvibes5887 2 ปีที่แล้ว +1

    Thank you very much. Great tutorial.

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @betterworld7916
    @betterworld7916 2 ปีที่แล้ว +1

    amazing explaining topics

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍 have fun 😊

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @joaovictorcesa9443
    @joaovictorcesa9443 3 ปีที่แล้ว +1

    Good tutorial, very down to Earth

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

      Thanks 👍 have fun 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

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

  • @tusharjain5500
    @tusharjain5500 3 ปีที่แล้ว +2

    Excellent tutorial thank you so much for this🙏

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @fiazkhan289
    @fiazkhan289 2 ปีที่แล้ว +1

    excellent work and extremally helpful thanx a lot
    keep going to help

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @RockingRooster986
    @RockingRooster986 3 ปีที่แล้ว

    The tutorial was very good. Maybe you could also have posted the links to the files you created in the video in the description.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍 I am making an update to my website where you can download all files soon

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @ikarimameen
    @ikarimameen 2 ปีที่แล้ว +1

    Great and simple.
    Thanks a million ♥️

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว +1

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @IndianForSure_1111
    @IndianForSure_1111 ปีที่แล้ว +1

    Thankyou 🙏 so much sir

  • @mastiwithdearak300
    @mastiwithdearak300 3 ปีที่แล้ว +1

    sir please make a latest video on libre office writer version 7
    Huge respect from india.......love the way u understand..

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว +1

      Thanks 👍 will try to make new tutorial soon 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Please check th-cam.com/video/BVvHZjBVHJw/w-d-xo.html

  • @TheGreatCanines
    @TheGreatCanines หลายเดือนก่อน

    Can you please explain how to create a numbered list from $10 - $1 using one cent increments, so you don't have to spend hours typing in each value.

  • @sayedattia113
    @sayedattia113 8 หลายเดือนก่อน +1

    Very good

  • @michaelgrim6926
    @michaelgrim6926 3 ปีที่แล้ว

    Thank you for the tutorial, very helpful. One alternate way of creating PDF without creating new file is to select the print option and selecting "Print to PDF", you can then select which pages to print.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @yprolly
    @yprolly 3 ปีที่แล้ว +1

    Thanks you. Nice Tutorial..

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @vivekbiragoni7331
    @vivekbiragoni7331 2 ปีที่แล้ว +1

    Thank You

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @talhamurs3279
    @talhamurs3279 ปีที่แล้ว +1

    Can I use MsExcel formulas in LibreCalc, or so I have to learn a complete new language

  • @s.baskaravishnu22
    @s.baskaravishnu22 3 ปีที่แล้ว +1

    Many thanks

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @sunlight9056
    @sunlight9056 ปีที่แล้ว

    Thanks mate, v helpful vid.

  • @Mishaal1234-kp
    @Mishaal1234-kp ปีที่แล้ว +1

    thank you bro

  • @INNO222
    @INNO222 3 ปีที่แล้ว +1

    Great clip!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @TheGreatCanines
    @TheGreatCanines หลายเดือนก่อน

    what section of your video contains information about creating an ordered number list from $10 to $1 in one cent increments?

  • @arshveersingh3528
    @arshveersingh3528 2 ปีที่แล้ว +1

    PERFECT!!!👌👍👌

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Great 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      More Libre Office Tutorials - Free Desktop Publishing Software: th-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

  • @thegreenprofit6155
    @thegreenprofit6155 3 ปีที่แล้ว

    Thanks for the video! helped alot!

  • @boomer4373
    @boomer4373 ปีที่แล้ว +1

    Nice video. Followed, but couldn't find "user interface" under "View".

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว +1

      Thanks 👍 make sure you have latest libre office

    • @boomer4373
      @boomer4373 ปีที่แล้ว +1

      @@dcpwebdesigners Just downloaded and installed version 7 for Windows 10.

    • @boomer4373
      @boomer4373 ปีที่แล้ว +1

      @@dcpwebdesigners Must give a small break for my eyes. And age is 66+

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Ok

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Rest up 👍

  • @eastcoastbearingsllc5794
    @eastcoastbearingsllc5794 ปีที่แล้ว +1

    Does LibreOffice offer a version of Microsoft Publisher?

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว +1

      No I don't think so, but try www.scribus.net/

  • @pankajpankaj5539
    @pankajpankaj5539 4 หลายเดือนก่อน

    How can I give different colour and or shape to a cell border while selecting through arrow keys or clicking by mouse in libre office calc excel?

  • @cliffs6523
    @cliffs6523 3 ปีที่แล้ว +1

    Very useful tutorial Learned a lot very quickly

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Great 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @bba.by.marilyn
    @bba.by.marilyn 6 หลายเดือนก่อน +1

    I have made a spreadsheet and saved it as a pdf file to print and saved the file also. Is there a way I can duplicate say file "A" and name it File "B" and have all the same information but be able to enter different information in the new file "b" and can made a pdf of "B" plus save 'B" to duplicate and make "file c".....

    • @dcpwebdesigners
      @dcpwebdesigners  6 หลายเดือนก่อน

      Yes you can make a copy rename the file and convert into another pdf file

  • @Chamindiu
    @Chamindiu ปีที่แล้ว +1

    Subbed.

  • @13mowe
    @13mowe 2 ปีที่แล้ว +1

    I cant figure out how to take the data from a web site to keep it live .for example an item price that is constantly changing . Do you have a link .I cant find anything

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Never done that before but wiki.documentfoundation.org/Faq/Calc/113

  • @digadiga5967
    @digadiga5967 ปีที่แล้ว +1

    Nice

  • @surinfarmwest6645
    @surinfarmwest6645 4 ปีที่แล้ว +3

    As it said beginner I thought I would have a quick skim through this as I have extensive spread sheet experience, you can sometimes pick up a small nugget of gold, we don't know everything. This, however, is novice to ninja in one and a half hours.

  • @gabbarbhaiop
    @gabbarbhaiop 3 ปีที่แล้ว +1

    16:30 Autofit cells

  • @djrackley
    @djrackley ปีที่แล้ว +1

    Best part of the whole video: "It would be a miracle if the Council Tax bill ever came down."

  • @saidneder41
    @saidneder41 3 ปีที่แล้ว +1

    THANKS FOR THIS VIDEO!!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @jamesbaxter2812
    @jamesbaxter2812 2 ปีที่แล้ว +1

    ok, so I am looking at srcip editor. it is not in Google sheets or Libre office. if it can be placed in libre office, I have tried. So can you help me. Thanks

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Read help.libreoffice.org/6.1/en-US/text/shared/guide/scripting.html

  • @kesavaprasad9959
    @kesavaprasad9959 3 ปีที่แล้ว

    Thanks a lot

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @ceciliagoldey220
    @ceciliagoldey220 2 ปีที่แล้ว +1

    Chapter 14 Auto sum. I'm running into a problem where some of my column sums gives me ### instead of a number...:(

  • @hyonledesma8113
    @hyonledesma8113 3 ปีที่แล้ว +1

    Necesito ayuda. Quiero separar archivos en libros diferente. Cada vez que abro un documento todos se abren en un solo libro y deseo que estén separados para poder verlos los 2. Abro un archivo y normal, abro otro y aparece en el archivo anterior pero como ventana y no deseo eso, deseo que se abra otro libro muy aparte del anterior

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Puede descargar Libre Office y Open Office para ver documentos en ventanas separadas.

  • @kevinellis3081
    @kevinellis3081 3 ปีที่แล้ว +1

    Great video thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @F_Du_Sea
    @F_Du_Sea ปีที่แล้ว +2

    Any time I enter a lot of money into a cell it censors it. Instead of showing "$1,650,000.00" it shows "###", how do I prevent this?

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว +1

      Make the column wider, the content you're entering cannot fit inside of the cell, so simply increase the width of the column

    • @F_Du_Sea
      @F_Du_Sea ปีที่แล้ว +1

      @@dcpwebdesigners Can't believe I missed that. Thanks!

  • @kimchee94112
    @kimchee94112 ปีที่แล้ว +1

    My LO Calc was working before now the the page break limited to 7 columns no matter how I resize the columns. The page break on the rows are OK. Downloaded new version, same thing. Anyone knows how to fix this?

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Not sure, I will need to research that

    • @kimchee94112
      @kimchee94112 ปีที่แล้ว

      @@dcpwebdesigners
      My bad, 0.89" default column width, thus across standard 8.5" sheet of paper shows 7 columns. However on Print Preview: no margins displayed or able to adjust the column widths on the fly with mouse like older versions before printing. No grid lines shown either on print preview. Seems like some good features removed, is it me or is it a bug in my version?

  • @jiritichy6855
    @jiritichy6855 2 ปีที่แล้ว +1

    My Spanish bank outputs the summary of all the spending and deposits, but the decimal point is replaced by the comma.....so it looks like E65,43 for example. I am trying to paste it in spreadsheet, but it won't calculate with decimal point as coma. I am trying to just cut and paste...but as it is I have to change all the decimal comas for decimal point..... What a drag!
    I am wondering if there is setting somewhere to change the format...I looked, where you point in yuor video...i.e. cells fromating....but cannot see that option there. Is there a way? Thanks

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Press Ctrl+H key to find & replace
      Find comma
      Enter decimal point
      The select replace all

    • @jiritichy6855
      @jiritichy6855 2 ปีที่แล้ว

      @@dcpwebdesigners Thank you ...Good tip!.....Now I tried negtive numbers sum, with all the decimal points corrected, but it returned #VALUE, AFTER USING FORMULA =C11:C22. When I used Sum insteadit calculated good. Why the formula did not work?

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Hmmmm not sure, I will have to run some tests

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว +1

      Select the column of data and make sure the cell are formatted correctly

  • @kimchee94112
    @kimchee94112 3 ปีที่แล้ว +1

    Using Windows 10, saving Libre Office 7 Cal in odf format shows an icon blank page with dogear on the top right corner. Is it possible to show more like a spreadsheet icon as show on the startup Libre Office 7?
    Also no updates other that retarding the spreadsheet when linking to an external spreadsheet. For real time updates I need to bring that external spreadsheet into the the worksheet. On my old Excel version I could have multiple spreadsheets all shown at once and link in real time without switching one spreadsheet to another like in Libre Office 7 Calcs worksheet. Hard to keep track of all the numbers this way. Am I doing it wrong?

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      I will have to investigate and see if there is a fix

  • @studio_guing
    @studio_guing 3 ปีที่แล้ว +1

    Thank you so much

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @officenotebook8911
    @officenotebook8911 2 ปีที่แล้ว +1

    ☝️☝️
    Nice tutorial
    Thanks

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 ปีที่แล้ว

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

  • @Jaguar48h
    @Jaguar48h 3 ปีที่แล้ว

    Great, Thanks !!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @marilynmb.canada9680
    @marilynmb.canada9680 3 ปีที่แล้ว

    I have created a document with protected and unprotected cells. How can I program Libreoffice Calc to move the cursor to the right on "enter" rather than down? Can anyone help me? Thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      You can press the TAB key to move to the right.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Menu Tools → Options → LibreOffice Calc → General, Input Settings change Down to Right.

    • @marilynmb.canada9680
      @marilynmb.canada9680 3 ปีที่แล้ว

      @@dcpwebdesigners Thank you! That was exactly what I was looking for!

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

  • @vimalpritham8340
    @vimalpritham8340 ปีที่แล้ว

    can you make a video for crypto portfolio tracking ,my real problem is i don't known how to import the cryptocurrency prices from websites ,there is more videos for microsoft excel but not for libreoffice calc

  • @shanderblaze1985
    @shanderblaze1985 3 ปีที่แล้ว +1

    Good video but if I may ask a question could you also do the course in Spanish for those of us who see it in Spanish? Or if you happen to already have LibreOffice courses, please show me where to see them and learn with a teacher who teaches very well (I mean the teacher to you)

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Sorry I don't speak Spanish

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

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

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Excel Microsoft Excel Tutorials: th-cam.com/play/PLRpn_0jbcinuYdNJkuVEfiIk9QQTNii5u.html

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      Microsoft Word Tutorials - Learn MS Word: th-cam.com/play/PLRpn_0jbcintU8S7eQ5gZ5dpJsqr7wcwp.html

  • @lucifiaofthefreecouncil1312
    @lucifiaofthefreecouncil1312 3 ปีที่แล้ว

    I formatted the cells to USD and any value over 9 turns into "###" how do I fix this? [Edit: Found the problem ### means there isn't enough space for that format. Solution was just widening the cell. I derpy]

  • @Z.A.N.E19
    @Z.A.N.E19 4 หลายเดือนก่อน

    14:40 🔜

  • @johnbrasher5156
    @johnbrasher5156 3 ปีที่แล้ว

    Internet searches for how to create tables in Calc turn up zero, or stuff from 2012. Apparently there is no way to create tables in Calc. So what on earth is it FOR? I hate Excel, but Calc is even worse.

    • @dcpwebdesigners
      @dcpwebdesigners  3 ปีที่แล้ว

      I suggest you actually watch the video 🤣

  • @VulcanOnWheels
    @VulcanOnWheels ปีที่แล้ว

    11:55 That's not a backslash.

  • @beam-kitty8425
    @beam-kitty8425 2 ปีที่แล้ว

    You’re speaking a bit too fast for me.

  • @woody3590
    @woody3590 ปีที่แล้ว

    AND THATS WHY FOLKS WE HAVE AN ACCOUNTANT

    • @dcpwebdesigners
      @dcpwebdesigners  ปีที่แล้ว

      Try th-cam.com/video/XDnBV-Tlb2g/w-d-xo.html