Open Office 4 Calc Spreadsheet Beginners Tutorial

Поделиться
HTML-код
  • Опубликовано: 21 дек 2024

Комментарии • 334

  • @jeffmisenheimer6006
    @jeffmisenheimer6006 4 года назад +22

    Great tutorial even though it is a few years old. I am a new Open Office user and it has helped greatly!

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад +2

      Cool 😎 thanks 👍 I will lane updated tutorials soon ....

  • @malacca1951
    @malacca1951 4 года назад +2

    Just spent an hour trying to figure out a problem with Currency and how to show it properly! (I'd forgotten after 4 months of 'Lockdown'!) Your tutorial showed me a 'right-click' which helped me in 5 seconds! I'd spent ages viewing instructions, manuals, youtube videos and phoning friends but YOU sorted it in an instant! Very helpful and you've saved me a sleepless night - and a bad temper too !
    I'm now going to go back and learn more! Wish I'd found you 5 years ago !! Thanks again! And keep up the good work!

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

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

  • @user-yq2wk6yg8s
    @user-yq2wk6yg8s 2 года назад +3

    I have used Open Office spreadsheets to do my annual tax return about 3 times already but in the year between returns I forget how to use it! So it was really helpful to find this simple and easy to follow instruction for the basic stuff, which is all I need. Thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  2 года назад

      Thanks 👍 please also check Small Business Bookkeeping Tutorials: ruclips.net/p/PLRpn_0jbcint5TC-X6JNN4A6Z9I2zPczN

  • @mikeykany1973
    @mikeykany1973 7 лет назад +1

    There are millions of people out there who left school before the use of IT was commonplace, yet are now running businesses on their own. Have you noticed the amount of cloud based bookkeeping services now popping up like Quickbooks or Free agent? They are good but over a year can cost hundreds of pounds in subscription fees.
    And you can just imagine in a few years once they have got you, the price will just go up and up. Spending a little time learning this will save you money and allow you to understand your business better. These tutorials are an absolute gold mine of information and value.

    • @dcpwebdesigners
      @dcpwebdesigners  7 лет назад

      +Michael Kane have fun learning new skills :) and try to share your knowledge as well ;)

    • @mikeykany1973
      @mikeykany1973 7 лет назад +1

      DCP Web Designers Just wondering, have you done a sheet on recording mileage?

    • @dcpwebdesigners
      @dcpwebdesigners  7 лет назад

      +Michael Kane no not done that before but you should be able to do this yourself using the logic from tutorial. Try to think about what data you need to capture first, also if you want to capture daily, weekly or monthly, capture millage in miles or Km, cost for fuel etc.

  • @srommann
    @srommann 10 лет назад +13

    This has probably been the most beneficial information I've learned for my small cleaning business. Simply stated, easy to understand. Thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад

      Many thanks. Take a look at my RUclips page and you will find other useful business tutorials :)

  • @corettamill
    @corettamill 5 лет назад +2

    VERY GOOD TUTORIAL ...I understood every step.....You are a good teacher..... Thanks

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Thanks 😎

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Lot more free tutorials here Open Office 4 Tutorials: ruclips.net/p/PLRpn_0jbcinvBC_9_E1XUjpYwFVAnEKuH

  • @ACBIXI
    @ACBIXI 3 года назад +2

    i just love the fact that you are still replying to comments, awesome video mate

  • @countessblackula1
    @countessblackula1 8 лет назад +3

    Thank you,I've not used a spreadsheet for 2yrs & totally forgot how to use it so you were a great help :)

  • @mikescuba1
    @mikescuba1 4 года назад +1

    Just wanted to extend to you a big thank you. I've never understood how to set up a spreadsheet before. It was like entering a maze. Your Tutorial was very easy to follow. You have made me very happy. Many Thanks for the info.

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Cool thanks 😎 have fun 👍

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

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

  • @mlburns69
    @mlburns69 10 лет назад +3

    excellent 32 min and i made a business spreadsheet thanks for what you do you made it make sense

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад +3

      You are welcome Michael, check out my youtube channel for more spread sheet tutorials :)

  • @GanmaB
    @GanmaB 10 лет назад +1

    thank you so much!! Have been searching on how to do a spreadsheet and now you have made it more understandable!!!!

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад +1

      Your welcome Becky. Have fun learning new skills :)

  • @rajeshkaushikofficial1544
    @rajeshkaushikofficial1544 6 дней назад

    It helped me in exam after 11 years thank you🎉

  • @astaabukauskaite5086
    @astaabukauskaite5086 9 лет назад +2

    Thank you very much for your time and effort recording all your tutorials! Its so helpful!!!

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад

      Your welcome and many thanks for your comments :)

  • @shazzorama
    @shazzorama 2 года назад +1

    This is spot on, thanks very much. I like your style of explaining. Clear and concise.

    • @dcpwebdesigners
      @dcpwebdesigners  2 года назад

      Thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  2 года назад

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

  • @soulzinhovsf
    @soulzinhovsf Год назад

    almost 10 years later and still helped me, thanks!!

  • @TMFitness
    @TMFitness 10 лет назад +4

    Dude this is awesome. I just built my first ever spreadsheet (no small feat for me) and feel like a boss! Cheers.

  • @thegamerwithskills7558
    @thegamerwithskills7558 3 года назад +2

    Thanks a lot ... as my computer practical is tomorrow ...

    • @dcpwebdesigners
      @dcpwebdesigners  3 года назад +1

      Ok cool 👍 good luck

    • @dcpwebdesigners
      @dcpwebdesigners  3 года назад

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

  • @pyder
    @pyder 3 года назад +2

    This was very helpful and easy to understand. I've never done spreadsheets before and this definitely helped me get started. Thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  3 года назад +1

      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

  • @CrystalKing1956
    @CrystalKing1956 10 лет назад +1

    This is great and just what I needed. Have a feeling I'll be visiting your channel often! thanks!

  • @Skylinesandsunsets
    @Skylinesandsunsets 9 лет назад +1

    Thank you for creating this spreadsheet tutorial. It really helped me learn what I needed to know about open office.

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад +1

      That's great :)

    • @Skylinesandsunsets
      @Skylinesandsunsets 9 лет назад +1

      DCP London Web Designers - Two questions for you:
      1) What are the differences, if any, between open office and MS Excel?
      2) Would you recommend LibreOffice?

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад +1

      open office is free, excel is very similar but paid for application libre office is also good, check my RUclips channel for libre office calc tutorial.....

  • @Mellow2599-oct
    @Mellow2599-oct 6 лет назад +3

    Thank you. I found it very helpful and easy to understand even for a non- English speaker like me

  • @69josephbc
    @69josephbc 8 месяцев назад +1

    Beautifully explained, thank you very much.

  • @TwinCessnaPilot51
    @TwinCessnaPilot51 8 лет назад +1

    Greetings from Florida!
    Thank you so much for your very helpful Spreadsheet Tutorial. You have no idea how much you have helped me.
    Cheers!

  • @davidmadisontheguardian
    @davidmadisontheguardian 10 лет назад +4

    More and more lately, I've been learning that if I look hard and long enough, I can find an answer to my challenge.
    Growing up, I found out that I didn't think like the other kids and would get in trouble in school. This extended to my later years as a young man, when I couldn't hold down a 9-5 job.
    So I went into business for myself doing yardwork. I worked and with the help of grant money, pulled myself up out of homelessness.
    I've been wanting to educate myself on spreadsheets, but my version of WORD is dated way back to 2002 or 2003; and RUclips simply doesn't have that much information on it; or I just haven't figured out how to comb out the useful stuff from the junk.
    Just recently I discovered that I had Apache Open Office 4; and wondered what it was all about and if it had a spread sheet. It did.
    I want to use this spread sheet to create a budget for both my personal and my landscaping (yard work for now) business.
    Thank you so much for creating these tutorials!
    Dave/Nate/Knave

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад

      David Madison your welcome, if you check my youtube page you can find tutorial on business bookkeeping: m.ruclips.net/user/dcpwebdesigners

    • @davidmadisontheguardian
      @davidmadisontheguardian 10 лет назад +1

      Thank you :-) ; I'll be looking into that Crystal.

  • @goodnightbanjo
    @goodnightbanjo 4 года назад +1

    You Sir, are blooming fantastic. Thank you!

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

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

  • @maxtofone
    @maxtofone 8 лет назад +3

    Thanks a lot for this brilliant tutorial, just what I needed!

  • @elizabetholiviaclark
    @elizabetholiviaclark 8 лет назад +1

    Time well spent. Thank you so much for this useful tutorial.

  • @LoneTaurus82
    @LoneTaurus82 9 лет назад +3

    This was a very helpful and straight forward tutorial. I need to build my spreadsheet skills and you explained the basics quite well. I have Open Office on my computer so I was able to follow along with your video using OpenOffice Calc with ease. Thanks alot!!

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад

      Ken Gevon thank you for your comments :) - check out my youtube page for more free tutorials: ruclips.net/user/dcpwebdesignersvideos

  • @anastasistsagaris1259
    @anastasistsagaris1259 10 лет назад +1

    Thank you very much for this tutorial,it was very helpful for me to learn how to start with this program as a beginner!!!

  • @ChicagoDreamer5
    @ChicagoDreamer5 Год назад +2

    Great information & very helpful. Question: How did you get the blue color in your menus and toolbars at the top? I'd sure like mine to look like that. Thanks so much!!

  • @ReallyRedPanda
    @ReallyRedPanda 9 лет назад +1

    Very clear and comprehensive tutorial, thanks very much! :)

  • @lusindadionne9941
    @lusindadionne9941 9 лет назад +4

    TY this is most helpful . I cannot pull up the spread sheets that I have already done

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад

      You need to make sure you save the file when adding data to spreadsheet.

  • @bathroomtilecenter2180
    @bathroomtilecenter2180 5 лет назад +1

    Thanks a lot very useful
    hope to see your next videos

  • @josephrouse1443
    @josephrouse1443 10 лет назад +1

    Good video! Do you have a tutorial on how to create an address book and/or merge your contacts with it in open office? Thanks

  • @LizyPulpy
    @LizyPulpy 4 года назад +1

    Thank you, this has been a lot of help! I want to move from retail to office work so I'm trying to gain all the skills I can!

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

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

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Libre Office Tutorials: ruclips.net/p/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Open Office 4 Tutorials: ruclips.net/p/PLRpn_0jbcinvBC_9_E1XUjpYwFVAnEKuH

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Microsoft Excel Tutorials: ruclips.net/p/PLRpn_0jbcinuYdNJkuVEfiIk9QQTNii5u

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Microsoft Word - Tutorials: ruclips.net/p/PLRpn_0jbcintU8S7eQ5gZ5dpJsqr7wcwp

  • @dwaynedibbley6124
    @dwaynedibbley6124 9 лет назад +1

    Sweet. Cheers for your time and effort.

  • @katelynjahnke4218
    @katelynjahnke4218 8 лет назад +1

    Thanks so much for this tutorial! It helped me a ton!

  • @just000honest
    @just000honest 10 лет назад +1

    Very helpful tutorial. Thanks

  • @kingarthur5877
    @kingarthur5877 8 лет назад +1

    Thank you for making my life so much easier !!!!!

  • @graemenevill
    @graemenevill 9 лет назад +1

    I appreciate that - be looking for your next

  • @Blade56762
    @Blade56762 9 лет назад +1

    Thank you for this excellent tutorial.

  • @melodymccoy
    @melodymccoy 9 лет назад +2

    Thank you so much, I can finally do a spreadsheet quickly!

  • @rebeccabrown8546
    @rebeccabrown8546 11 лет назад +1

    Thanks so much. I look forward to continuing tomorrow. One thing, I kept having a problem with the BOLD, it kept bolding prices. Can you help?

    • @dcpwebdesigners
      @dcpwebdesigners  11 лет назад

      Hi Rebecca Brown select the price column by left clicking on the column letter and then select the bold button. This will remove bold from the whole price column. The select the cell only with the price label and then select bold agian to make price label bold only :)

  • @Tennishead21
    @Tennishead21 10 лет назад +1

    This helped me tremendously. Many thanks! :)

  • @michellebarrett6841
    @michellebarrett6841 7 лет назад +1

    Thank you so much really clear instructions!

    • @dcpwebdesigners
      @dcpwebdesigners  7 лет назад

      +Wanderlust Women thanks :) check out my new website blog with Lots of new tutorials. www.dcpweb.co.uk

  • @TH3M4G1CM4Nx
    @TH3M4G1CM4Nx 7 лет назад +1

    Thank you, this was a good tutorial.

  • @RogersPhotographyOG
    @RogersPhotographyOG 5 лет назад +1

    Thank you very much. I've avoided spreadsheets for decades but ow I need them to keep track of copyrighted works posted.

  • @edenbridgematt
    @edenbridgematt 10 лет назад +1

    Thanks for a great tutorial for beginners to Open Office spreadsheets. :)

  • @PeacePays
    @PeacePays 10 лет назад +1

    thank you for your time and lesson, was very helpful & well done

  • @psylentknight
    @psylentknight 4 года назад +1

    This was a fantastic tutorial! Will refer to it again if I have any hang-ups!

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

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

  • @khushboothakur4945
    @khushboothakur4945 4 года назад +1

    Thank you sir for your guidelines 😊

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Cool 😎 thanks 👍

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

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

  • @Yourperfectcanvas
    @Yourperfectcanvas 11 лет назад +1

    thank you for this it has been very helpfully I do have one question when I export date in open office excel it puts a space in front of each text in all boxs how can I remove this

  • @albertgainsworth
    @albertgainsworth 10 лет назад +1

    Thanks. I really appreciated this presentation. It got me started.

  • @maggiemorton4722
    @maggiemorton4722 Год назад +1

    so helpful, thank you!

  • @portcity935
    @portcity935 8 лет назад +2

    Great tutorial, I will be watching more. Thank You!

  • @TheGrandeGamer
    @TheGrandeGamer 9 лет назад +1

    is there any way to change what it says in the boxes with the letters and numbers?

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад

      No this is not possible, letter and numbers are used for referencing cell positions on spreadsheet.

    • @TheGrandeGamer
      @TheGrandeGamer 9 лет назад +1

      ah ok, thanks

  • @keithhulsed914
    @keithhulsed914 7 лет назад +1

    Great tutorial. Very helpfu,l thanks.

  • @pianoman598
    @pianoman598 11 лет назад +1

    Excellent video. Thank you so much!

  • @RichBlaker
    @RichBlaker 9 лет назад +1

    THANKS! That kicked me off on using spreadsheets, I know what I'm doing now, Cheers!

  • @rickymatthews249
    @rickymatthews249 6 лет назад +1

    I need it this. Cause those are fundamental skills that I still need to get a hang of for my job.

  • @therewearethen-bx1fn
    @therewearethen-bx1fn 3 года назад +1

    ...thank you...really clear explanation

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

    • @therewearethen-bx1fn
      @therewearethen-bx1fn 3 года назад +1

      @@dcpwebdesigners ...yes...am happy to...all the best

  • @VictoryTabernaclevtc
    @VictoryTabernaclevtc 6 лет назад +1

    Can I you use OpenOffice to keep files for all my members? And can I look them up by there name, birthday, ect?

  • @MC5374-o8f
    @MC5374-o8f 7 лет назад

    Is there a way to add the mileage data to each client? I have some done but I'm hoping there's an easier way to copy mileage to client

  • @dcpwebdesigners
    @dcpwebdesigners  11 лет назад

    Your welcome :) - Have fun !

  • @gabrielleboucan4026
    @gabrielleboucan4026 8 лет назад +1

    Incredibly helpful, thank you!

  • @Cjcool03
    @Cjcool03 11 лет назад +2

    Thanks so much for video tutorial,it is really help me so mcuh...One Love

    • @dcpwebdesigners
      @dcpwebdesigners  11 лет назад

      Chijioke Ezeh no problem. Good to see my tutorials are helping people. Have fun learning new skills :)

    • @Cjcool03
      @Cjcool03 11 лет назад +1

      I am working on that now..Thanks.

  • @biswajeetbalabantray8133
    @biswajeetbalabantray8133 8 лет назад +2

    Great Video. Couldn't have been any better!!

  • @ameliaemery6545
    @ameliaemery6545 8 лет назад +1

    question can we change the column a to something instead of haveing to put the perpose of that column in the 1 spot

    • @dcpwebdesigners
      @dcpwebdesigners  8 лет назад +1

      +amelia emery no this is not possible as the column letters are used to reference cell positions...

    • @ameliaemery6545
      @ameliaemery6545 5 лет назад +1

      Ok good to know thanks

  • @suniell276
    @suniell276 6 лет назад +1

    REALLY HELPFUL, THANKS..

  • @elisadominguez5682
    @elisadominguez5682 10 лет назад +1

    very helpful, thanks!

  • @bobcatt2294
    @bobcatt2294 Год назад

    Great work, and a thumbs up and subscribed.

  • @mss5288
    @mss5288 9 лет назад +1

    Thank you so much for this tutorial, it really helped me a lot

  • @stephenkraljic2336
    @stephenkraljic2336 8 лет назад +1

    Thank you for your help.

  • @fadumoali7477
    @fadumoali7477 10 лет назад +1

    Great example for first time user's, but i'm confused in how to make a list of names in alphabet order?
    Thanks.

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад

      Please check the following tutorial here: ruclips.net/video/epDaUQyaLU0/видео.html

  • @vernabenn5592
    @vernabenn5592 6 лет назад +1

    Brilliant, thank you!

  • @donalcole
    @donalcole 8 лет назад +1

    This has been very helpfull.

  • @autumnzink5470
    @autumnzink5470 7 лет назад +1

    Thank you so much for a simple way to do this! I never knew it was so simple, IF you know what to do :)

  • @juliej.991
    @juliej.991 4 года назад

    Thank you very much! It's very useful for me.

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад

      Thanks 👍 have fun 👍

    • @dcpwebdesigners
      @dcpwebdesigners  4 года назад +1

      More Open Office 4 Tutorials: ruclips.net/p/PLRpn_0jbcinvBC_9_E1XUjpYwFVAnEKuH

  • @sycamore1955
    @sycamore1955 5 лет назад +1

    How do I get the sum symbol to appear on the toolbar?

  • @matan4808
    @matan4808 7 лет назад +1

    That's great Thank you

  • @dcpwebdesigners
    @dcpwebdesigners  11 лет назад

    Thanks :) - glad you found the tutorial useful

  • @MarkLawsonY3K
    @MarkLawsonY3K 10 лет назад +1

    good start....thanks mate.... even with the tute full size seeing the box data was so small... fyi... Because of you I"ve got my first SS to build on and experiment with. Lawson di Ransom Canyon

  • @johnmike1387
    @johnmike1387 10 лет назад +1

    Very nice tutorial..

  • @IEraiderfan
    @IEraiderfan 7 лет назад +1

    Thank you for the tutorial.

  • @Upcamehill
    @Upcamehill 8 лет назад +1

    When I use the auto filter the cells appear that I choose, but underneath the results are just gray area. There are no rows and columns, so I can choose to sum a column. How can I get empty rows and columns to show as they do on your video?

    • @dcpwebdesigners
      @dcpwebdesigners  8 лет назад

      +Upcamehill make sure you have a recent version of open office...

    • @Upcamehill
      @Upcamehill 8 лет назад

      I am using 4.1.2. from October of 2015. I see that you posted the video in 2013. Maybe this can not be done in the later versions after 2013.

    • @dcpwebdesigners
      @dcpwebdesigners  8 лет назад

      +Upcamehill try removing the auto filter and then make sure you select the whole row and add auto filter again

    • @Upcamehill
      @Upcamehill 8 лет назад +1

      I tried that. At first it didn't work, but now it is working after doing that a few times. I guess I was doing it wrong the first few times. Thanks for your help!

    • @dcpwebdesigners
      @dcpwebdesigners  8 лет назад +1

      +Upcamehill cool :)

  • @SilverTrove
    @SilverTrove 9 лет назад +1

    Great video! I have an online business, so the application is a bit different, but the information was helpful. I do have a couple of questions; What if you enter the information in each line in random order and you later want to go back and put them in date order? Is there an automatic way to do that? Also, can you insert a line between existing lines if you left something out the first time?

    • @dcpwebdesigners
      @dcpwebdesigners  9 лет назад

      Carol Braden-Williams - to sort columns please watch this tutorial: ruclips.net/video/epDaUQyaLU0/видео.html
      To inset a new line - Right mouse click on the row number (left slide of spreadsheet) and select insert new row.

  • @PeteMP3
    @PeteMP3 8 лет назад +1

    This has been perfect for me. Thank you

  • @KMacFNP
    @KMacFNP 5 лет назад +1

    I'm new to open office. I subscribed to your channel by the way :)
    My question is, how do we just limit the cells we like to work on? Like say only from A to E on the columns and 1 through 30 on the rows?

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Hi, you cannot limit the amount of columns or rows, that not how spreadsheets work. You can increase the width of the columns so you only see columns A to E but I would not do this for the row.

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Another Note: If you want to print out data or create a PDF file then you can highlight only the data you want to print or convert into a PDF

  • @dcpwebdesigners
    @dcpwebdesigners  11 лет назад +5

    Open Office 4 - Calc Spreadsheet Beginners Tutorial
    #openoffice4 #calc #tutorial #dcpwebdesigners

  • @schoenas4
    @schoenas4 8 лет назад +1

    When I have a price and I want to multiple a percentage, what is the formula/format that would be used? Formula used is =E2*1.3, but it does not calculate a total just leaves the equation in its place. Cell is formatted as a Number - General. Page as a bunch of order data and hate to have to retype if not necessary. If a blank sheet is opened and formal only is inserted then the formula is calculated. Hope this makes sense.

    • @dcpwebdesigners
      @dcpwebdesigners  8 лет назад

      +Kelsey Stupka same format in open office

    • @dcpwebdesigners
      @dcpwebdesigners  8 лет назад

      +Kelsey Stupka Hi, your formula looks correct, make sure all the cells in column which contain formula for formatted to number value as this seems to be the only reason the formula is showing a text rather than calculation.

  • @kylebowman613
    @kylebowman613 6 лет назад +1

    When you drag down from a cell to auto fill, why is there no drop down menu after to choose between fill series and copy cells? Sometimes I don't want it to fill series, but copy the same value into every cell below.

    • @dcpwebdesigners
      @dcpwebdesigners  6 лет назад

      Simply select the cell you want to copy down and copy the data, the highlight the cells and paste

  • @qualitycarpetcare8122
    @qualitycarpetcare8122 7 лет назад +1

    very helpful for a spreadsheet noob

  • @tharshans5833
    @tharshans5833 3 года назад +2

    Great bro

  • @Pattys1967
    @Pattys1967 8 лет назад +1

    HI,I JUST NEEDED TO SAY...THANK YOU SO MUCH FOR THIS TUTORIAL,I JUST FOUND YOUR HOW TO MAKE A PROPERTY MANAGERS SPREAD SHEET AND NEXT THING I KNOW,IM DOWNLOADING THE OPEN OFFICE,ITS FREE,CANT BEAT IT,IT HAS EVERYTHING JUST LIKE WINDOWS OFFICE WHATEVER,BUT AGAIN,LOVE YOUR TUTORIALS,IM WATCHING THIS ONE BECAUSE I NEED TO LEARN HOW TO DOCUMENT ALL OUR RENT COLLECTIONS,NAMES OF TENANTS AND PROPERTY COSTS,IM HOPING THIS WILL HELP ME,THANK YOU FOR SHARING YOUR VIDEO AND YOUR TIME WITH US ALL SUBBED AND LOVED ; )

  • @lhensworld
    @lhensworld 5 лет назад +1

    Why does not appear the given data after i autofilter them? It just shows the All, Top 10 and Standard fliter?

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Should work fine, not sure why is problem for you

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Try making a basic spreadsheet and then try the auto filter to see if works, if not then download latest version of software

    • @user-yq2wk6yg8s
      @user-yq2wk6yg8s 2 года назад +1

      If you click on 'All', it will show a list of all the choices existing in the column, in alphabetical / numerical order. You choose one from that list and it then displays all the rows which have that choice.

  • @quincypeabody8469
    @quincypeabody8469 5 лет назад +1

    Thank you !

  • @paulstringer7083
    @paulstringer7083 8 лет назад +2

    can u please tdo an article on how the ?database works. I am a radio Dxer i am i want to make a list of stations i have received.

  • @CorinaDonea
    @CorinaDonea 10 лет назад +1

    Hi,i am trying to do step by step what u do in ur tutorial,but i can't go to far cuz after i write the first 4 words: Data,Inviction nr. etc...then i drag with left click on the words and after that press B button...they don't look like it should and instead the 4 words transforms in Data in all for columns.I don't get it,what im doing wrong?

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад

      Hi,
      1. Make sure you have formatted the columns correctly
      2. Also make sure the column is wide enough to display all content entered in cells

    • @CorinaDonea
      @CorinaDonea 10 лет назад +1

      DCP Web Designers Thank you!

  • @mrbreez33
    @mrbreez33 8 лет назад +1

    Thanks buddy.

  • @opticrainbow
    @opticrainbow 10 лет назад +1

    Great video. Question though - For some reason I'm so compelled to have an exact number of rows and columns, not an infinite number like a continuous scroll. Is there any way in OO to turn off that infinite scrolling feature? I really want to just see my data and not one big infinite sheet of cells! Thanks dude.

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад

      Hi, you can't stop the scrolling but you could zoom in to see less rows and columns. Use ctrl key and your mouse wheel to zoom in.

    • @opticrainbow
      @opticrainbow 10 лет назад

      Wow, there's no way to just set a table that is say 5 x 5 or 10 x 10? I would think that is a really basic function. Do you know of any programs that allow for that?

    • @dcpwebdesigners
      @dcpwebdesigners  10 лет назад

      You could use open office writer and create a fixed table but you won't have the functionality of a spread sheet.

    • @opticrainbow
      @opticrainbow 10 лет назад +1

      Oh okay right on. Thank you :-)