LibreOffice Calc Tutorial - [ Spreadsheet Tutorial ]
Vložit
- čas přidán 5. 08. 2024
- In this video tutorial, I will show you how to use basic formulas in Libre Office Calc 6.
Understanding how formulas work in spreadsheets can save you lots of time. You can use formulas to repeat processes like adding numbers together or create more custom complex formulas for data analysis.
In this video tutorial, I will give you a basic understanding of how formulas work, these same formulas work in Open Office Calc and Microsoft Excel.
Libre Office is a free alternative to Microsoft Office 365.
I would have to say Microsoft Office is better and more robust, so you may consider this in the future.
But in general day to day work Libre Office should be an acceptable solution.
Subscribe to access 500+ video tutorials: / dcpwebdesigners
Contact me on:
Instagram: / dcp_web_designers
Facebook: / dcpwebdesigners
Pinterest: www.pinterest.co.uk/dcpwebdes...
LinkedIn: / dcpwebdesigners
#LibreOffice6 #Calc #Tutorial #dcpweb
Free tutorials, infographics, articles: www.dcpweb.co.uk/blog
libreoffice (software), libreoffice calc, openoffice.org (software), libre office, libre office calc, libre office spreadsheets, libreoffice tutorial, libreoffice 6, libreoffice calc basic tutorial, libreoffice calc formulas tutorial, libreoffice formulas tutorial, libre office formulas tutorial, basic formulas tutorial, formula tutorial, calc formula tutorial, calc formulas tutorial - Jak na to + styl
Thanks for the video. We need intermediated and advanced LibreOffice tutorials.
Thanks 😎
Subscribe to access 150+ video tutorials: czcams.com/users/dcpwebdesigners
thank you, that was very clear to understand awesome
Thanks 😎 have fun learning new skills 👍
spot on dude thank you
Thanks 😎
i needed this x
Cool 😎 thanks 👍 have fun 👍
How would you [in IF... Comparison] B2 [NOT EQUAL TO] A2? Thanks!
NICE EXPLANATION SIR IM FROM INDIA
Thanks 😎
Where can I find Formula ~ # days remaing in Guarantee? Thanks!
Do you know how to save Solver models at each sheet after exporting to .xlsx?
Not sure I will have to research that
can you make a video on how to insert a specific value from a website into a calc cell?
I will try, but not sure how, would need to store spreadsheet online and write alot of code to API the data
Better to use mySQL db
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 ,
1. Save you file
2. Close file
3. Open file
4. Select row
5. Right click / insert row
@@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
Would be awesome if you can give me a Google review to help my business 👍
g.page/dcpweb/review?gm
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? 🤷♀️
Go to this video czcams.com/video/bgO40-CjYNY/video.html
Check the description and click on chapter 7 - subtraction
@@dcpwebdesigners Many thanks!
Cool 😎
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.
After you feel the sequence there should be an option just below the last cell which allows you to select series filling
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 :)
..
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.
Make sure you save the file as clac file or excel file, CSV does not retain formumas
How did you generate that vertical line next to MEDIA COST? What is Vat?
Use cell boarders for line, Vat is value added tax in the UK
@@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?
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
@@dcpwebdesigners Thanks!
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 .
Hi, 1. Watch this .. czcams.com/video/CFHqFFz1rqM/video.html
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
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. .
Try to copy the data into a new blank spreadsheet and then save to your desktop, that might fix the issue
Also download latest version of libre office czcams.com/video/a-EmSL1Zmrw/video.html
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...
Yes
Formula
=A1-B1
This is an excel tutorial but works the same in libre office calc
czcams.com/video/HfcH6-z-GCs/video.html
@@dcpwebdesigners thank you mr. dcp! i'm having to teach this next week so am needing to know about it!!!
Great 👍
R u British bro.?
Yes from London UK
This libreoffice tutorial is useful for me, thankyou.
Cool 😎