LibreOffice Calc Tutorial - [ Spreadsheet Tutorial ]

[@MegaFg2010]

Thanks for the video. We need intermediated and advanced LibreOffice tutorials.

[@dcpwebdesigners]

Thanks 😎

[@TheSemgold]

Do you know how to save Solver models at each sheet after exporting to .xlsx?

[@dcpwebdesigners]

Not sure I will have to research that

[@joannavandermeer7511]

I may be a bit dim but is there a way of minus-ing using this? so you have one total and want to minus another one...

[@dcpwebdesigners]

Yes Formula =A1-B1

[@dcpwebdesigners]

This is an excel tutorial but works the same in libre office calc kzbin.info/www/bejne/fpfGeWljr5J6edU

[@joannavandermeer7511]

@@dcpwebdesigners thank you mr. dcp! i'm having to teach this next week so am needing to know about it!!!

[@dcpwebdesigners]

Great 👍

[@ex-bahamutgamer8381]

How to save formulas function in LibreOffice Calc? I am having trouble saving the formula function and all values becomes a solid value not function value.

[@dcpwebdesigners]

Make sure you save the file as clac file or excel file, CSV does not retain formumas

[@bengalbaby6118]

How would I make a formula for subtraction? I want to do some mileage data, and subtract beginning numbers from ending numbers. Would I use the '=IF and then the greater or lesser sign? Thanks in advance. Can you tell I am new at this? 🤷‍♀️

[@dcpwebdesigners]

Go to this video kzbin.info/www/bejne/mJiyZWNjeM-MhLs

[@dcpwebdesigners]

Check the description and click on chapter 7 - subtraction

[@bengalbaby6118]

@@dcpwebdesigners Many thanks!

[@dcpwebdesigners]

Cool 😎

[@danielgdlv]

can you make a video on how to insert a specific value from a website into a calc cell?

[@dcpwebdesigners]

I will try, but not sure how, would need to store spreadsheet online and write alot of code to API the data

[@dcpwebdesigners]

Better to use mySQL db

[@aayushkumar7442]

NICE EXPLANATION SIR IM FROM INDIA

[@dcpwebdesigners]

Thanks 😎

[@gripWIN]

Where can I find Formula ~ # days remaing in Guarantee? Thanks!

[@44lezdan]

Hello back again, I have been trying to inset a line on a spread sheet , and get the following . Filled cells cannot be shifted beyond the sheet ,

[@dcpwebdesigners]

1. Save you file 2. Close file 3. Open file 4. Select row 5. Right click / insert row

[@44lezdan]

@@dcpwebdesigners Thank you it works on most spread sheets but not on the one i have been trying . But thanks again will try another way delete the entry and re enter it . Cheers

[@dcpwebdesigners]

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

[@kimchee94112]

How did you generate that vertical line next to MEDIA COST? What is Vat?

[@dcpwebdesigners]

Use cell boarders for line, Vat is value added tax in the UK

[@kimchee94112]

@@dcpwebdesigners @12:19 that vertical line looks more like Extended ASCII Code 221 or 222. Don't think I could do that with borders in the middle of a cell. Is that right?

[@dcpwebdesigners]

AHH sorry that is called "pipe character" www.google.com/search?q=pipe+character&oq=pipe+charwct&aqs=chrome.1.69i57j0l3.10728j0j4&client=ms-android-h3g-gb-revc&sourceid=chrome-mobile&ie=UTF-8

[@kimchee94112]

@@dcpwebdesigners Thanks!

[@Bankside1997]

Having some trouble with Calc, hoping maybe someone here can help. When putting the months or the weekdays, Calc will display them automatically in sequence as one would expect but only if the default language is Spanish {I use Spanish and English languages for Calc}. When I change the default language to English and try doing the same it will not display them sequentially, just repeat Monday or January. What is the fix for this? Regards.

[@dcpwebdesigners]

After you feel the sequence there should be an option just below the last cell which allows you to select series filling

[@gripWIN]

How would you [in IF... Comparison] B2 [NOT EQUAL TO] A2? Thanks!

[@rickcontreras59]

thank you, that was very clear to understand awesome

[@dcpwebdesigners]

Thanks 😎 have fun learning new skills 👍

[@44lezdan]

Sorry to bother you but i have tried this for 3 months i have created a spreadsheet about my dvd's three columns 2 of text 1 of numbers times 58 entries .but when i look in print preview nothing there . and how to i add grid lines please . Im not very technical i hope you can help please .

[@dcpwebdesigners]

Hi, 1. Watch this .. kzbin.info/www/bejne/eXeronl8r5alp68

[@dcpwebdesigners]

I am not sure why you do not see data in print preview, try clicking on the first cell in spreadsheet and then go to print preview

[@44lezdan]

Well don't know how to thank you brilliant but i must say i had to pause it a few times i'm not as quick as you. But sad to say nothing in the tutorial worked on my particular sheet must be corrupt so have started all over again . All the other documents the border worked on and was excellent many thanks and i will keep it in favourites for use again at my speed. Thanks Again very kind. .

[@dcpwebdesigners]

Try to copy the data into a new blank spreadsheet and then save to your desktop, that might fix the issue

[@dcpwebdesigners]

Also download latest version of libre office kzbin.info/www/bejne/l16onoaCZr-gqNk

[@49Macman]

Thanks.

[@MTmoneytree]

spot on dude thank you

[@dcpwebdesigners]

Thanks 😎

[@KikiORkiesha]

i needed this x

[@dcpwebdesigners]

Cool 😎 thanks 👍 have fun 👍

[@dcpwebdesigners]

Subscribe to access 150+ video tutorials: kzbin.info

[@MrDavePed]

Hi what function do I use to determine the monthly payment on an amortization? I'd like to input the amount of the loan, the number of months and the interest rate. From that data I'd like to generate the monthly payment amount. Thanks much :) ..

[@adisakapichai5512]

R u British bro.?

[@dcpwebdesigners]

Yes from London UK

[@adisakapichai5512]

This libreoffice tutorial is useful for me, thankyou.

[@dcpwebdesigners]

Cool 😎