Libre Office 7 Calc Spreadsheets Beginners Tutorial

Поділитися
Вставка
  • Опубліковано 26 лис 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: ua-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

  • @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

  • @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

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

  • @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."

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

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

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

  • @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

  • @lolitbairiganjan2940
    @lolitbairiganjan2940 10 місяців тому +1

    One of the best explained tutorials.

  • @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 ua-cam.com/video/XDnBV-Tlb2g/v-deo.html

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

  • @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

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

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

  • @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

  • @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

  • @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

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

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

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

  • @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

  • @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

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

  • @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 🔍

  • @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 👍

  • @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: 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

  • @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

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

    An excellent introduction. Thank you.

  • @TheGreatCanines
    @TheGreatCanines Місяць тому

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

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

    Thank you very much. Great tutorial.

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

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

  • @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

  • @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?

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

  • @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

  • @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

  • @sayedattia113
    @sayedattia113 8 місяців тому +1

    Very good

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

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

  • @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

  • @kimnux
    @kimnux 11 місяців тому +1

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

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

    Thankyou 🙏 so much sir

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

    PERFECT!!!👌👍👌

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

      Great 👍

    • @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

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

    Great clip!

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

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

    can you make a tutorial for stocks adding

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

    Thanks mate, v helpful vid.

  • @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

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

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

  • @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

  • @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

  • @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

  • @s.baskaravishnu22
    @s.baskaravishnu22 3 роки тому +1

    Many thanks

  • @Mishaal1234-kp
    @Mishaal1234-kp Рік тому +1

    thank you bro

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

    Thanks for the video! helped alot!

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

    Thank You

  • @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

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

    Does LibreOffice offer a version of Microsoft Publisher?

  • @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

  • @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...:(

  • @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

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

  • @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?

  • @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 ua-cam.com/video/BVvHZjBVHJw/v-deo.html

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

    Subbed.

  • @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 👍

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

    Nice

  • @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: ua-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.

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

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

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

    Great video thank you!

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

      Cool 😎 thanks 👍

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

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

  • @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

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

    Thanks a lot

  • @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

  • @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: ua-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

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

    16:30 Autofit cells

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

  • @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]

  • @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

  • @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: ua-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

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

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

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

    ☝️☝️
    Nice tutorial
    Thanks

  • @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

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

    Great, Thanks !!

    • @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 to help my business 👍
      g.page/dcpweb/review?gm

  • @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: ua-cam.com/play/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ.html

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

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

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

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

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

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

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

  • @Z.A.N.E19
    @Z.A.N.E19 4 місяці тому

    14:40 🔜

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

    AND THATS WHY FOLKS WE HAVE AN ACCOUNTANT