- 162
- 461 139
LibreOffice Tutorials
United Kingdom
Приєднався 22 кві 2013
Welcome to LibreOffice Mastery!** Dive into the world of LibreOffice with our comprehensive tutorials, tips, and tricks. Whether you're a beginner or an advanced user, our channel offers step-by-step guides to help you master Writer, Calc, Impress, and more. Stay updated with the latest features, enhance your productivity, and join our community of LibreOffice enthusiasts. Subscribe now and unlock the full potential of LibreOffice!
How does that sound? If you need any tweaks or additional details, just let me know! LibreOffice Tutorials Calc, Writer, Impress
How does that sound? If you need any tweaks or additional details, just let me know! LibreOffice Tutorials Calc, Writer, Impress
MASTERING IFS Function Secrets in LibreOffice Calc Made EASY!
Join me as I challenge myself to master the IFS function in LibreOffice Calc and simplify it for everyone! Unlock the full potential of LibreOffice Calc's IFS function with this comprehensive tutorial! Learn the secrets to mastering IFS in LibreOffice Calc and take your spreadsheet skills to the next level. Discover how to use the IFS function to simplify complex formulas, reduce errors, and increase productivity. Whether you're a beginner or an advanced user, this video will guide you through the process of mastering IFS functions with ease. Get ready to simplify your workflow and become a LibreOffice Calc expert! #calc
#libreoffice
If you want to support me, check this out: www.patreon.com/itseasy
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv
#libreoffice
If you want to support me, check this out: www.patreon.com/itseasy
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv
Переглядів: 81
Відео
Conquer Your List in LibreOffice Calc 2024 the Easy Way!
Переглядів 22416 годин тому
Join me as I challenge myself to master selecting lists in LibreOffice Calc 2024 in under 10 minutes! Learn how to easily select your list in LibreOffice Calc 2024 with this step-by-step tutorial. Mastering list selection is a crucial skill for anyone working with spreadsheets, and in this video, we'll show you how to do it efficiently. From selecting a single cell to choosing an entire column ...
Create a Gantt Chart in MINUTES with LibreOffice Calc 2024!
Переглядів 32214 днів тому
Join me as I challenge myself to create a fully functional Gantt chart in just minutes using LibreOffice Calc 2024! Learn how to create a Gantt chart quickly and easily using LibreOffice Calc 2024! In this tutorial, we'll show you a step-by-step process to create a professional-looking Gantt chart in just minutes. Whether you're a project manager, student, or entrepreneur, this video will help ...
Discover LibreOffice Cal's MOST POWERFUL Database Functions in 2024!
Переглядів 36121 день тому
Join me as I dive into LibreOffice Calc and challenge myself to master its most powerful database functions in 2024! Unlock the full potential of LibreOffice Calc by mastering its most powerful database functions! In this video, we'll dive into the top database functions you need to know in 2024 to take your data analysis and management skills to the next level. From data manipulation and filte...
Master FILL SERIES in LibreOffice Calc Made Easy!
Переглядів 26221 день тому
The growth feature in LibreOffice Calc's Fill Series function is useful for creating a series of numbers that follow a multiplicative pattern. Here's an example to illustrate how it works: 1. Starting Value : Let's say you want to create a series that starts with the number 2. 2. Increment : You want each subsequent number to be multiplied by 3. 3. Direction : You want the series to fill down a...
Master LibreOffice Calc 2024 with This Simple Checkbox Trick
Переглядів 413Місяць тому
To add a checkbox in Calc without using a form or VBA, you can utilize the data validation feature to create a simple checkbox effect. First, select the cell where you want the checkbox to appear. Then, go to the Data menu and choose 'Validity'. In the 'Validity' dialog, under the 'Criteria' tab, set the 'Allow' field to 'List'. Enter "TRUE,FALSE" in the 'Entries' box, which will act as the che...
Match Made in Heaven! Pairing Columns in LibreOffice Calc 2024
Переглядів 273Місяць тому
how to pair two columns and match them using the match function and sort, write a paragraph To pair and match two columns in LibreOffice Calc 2024 using the MATCH function and sort, you first need to identify the common values between the columns. Start by using the MATCH function to find the position of a value from one column in the other column. For example, if you have data in Column A and ...
Pivot Table MAGIC in LibreOffice Calc 2024
Переглядів 429Місяць тому
To add a % difference column in a Pivot Table using LibreOffice Calc, you would typically follow these steps: First, create your pivot table with the necessary data fields. Then, to calculate the % difference, you will need to add a new data field that will represent the % difference calculation. This is done by dragging and dropping the desired column into the 'Data Fields' area of the pivot t...
Master Converting Measurements in Seconds Like a Pro in 2024
Переглядів 234Місяць тому
The CONVERT function in LibreOffice Calc is a versatile tool that allows you to change a value from one unit of measurement to another within the same category. To use this function, you need to specify three arguments: the number you want to convert, the unit you're converting from, and the unit you're converting to. The syntax for the function is `CONVERT(Number; FromUnit; ToUnit)`. It's impo...
How to format paragraphs in LibreOffice Writer 2024
Переглядів 3722 місяці тому
In LibreOffice Writer, paragraph formatting is a vital feature that allows you to enhance the visual appeal and readability of your documents. To begin with, 'Drop Cap' is a stylistic feature that enlarges the first letter of a paragraph, creating a classic, elegant look. This can be accessed through the 'Format' menu, then 'Paragraph', and 'Drop Caps'. Tabs, on the other hand, help in aligning...
How to add a bonus column based on sales in LibreOffice Calc
Переглядів 2322 місяці тому
To add a bonus column using an IF function in a spreadsheet, you would first insert a new column where you want the bonus to appear. Then, you can use the IF function to set the conditions under which the bonus applies. For example, `=IF(C2=1000, "Bonus", "No Bonus")` would add a "Bonus" in the new column for all rows where the value in column C is greater than 1000. To apply conditional format...
LibreOffice Impress 2024's BEST Kept Secret For Stunning Diagrams
Переглядів 4832 місяці тому
Animating diagrams in LibreOffice Impress involves several steps to bring your presentation to life. First, ensure you're in Normal view and select the diagram you wish to animate. Then, open the Custom Animation pane by choosing View - Animation. Here, you can add animation effects by clicking the Add ( ) button. You'll be presented with a range of effects to choose from, categorized under var...
LibreOffice Calc EXPERT Shares Top Budgeting Techniques 2024
Переглядів 4843 місяці тому
Join me as I dive into the world of LibreOffice Calc and challenge myself to master the top budgeting techniques for 2024! In LibreOffice Calc, the SUMIF function is a powerful tool for managing and analysing budget spend by categorizing data based on specific criteria. This function works by summing the values in a range that meet the criteria you specify. For instance, if you have a budget sp...
The Hyperlink Hack That Changed My Writing Forever
Переглядів 2253 місяці тому
Join me as I take on the challenge of mastering hyperlinks in Writer to impress everyone with my keyword game! To create a hyperlink from an Impress presentation to a specific page in a Writer document, you would first need to ensure that the target page in the Writer document has a bookmark. Open the Writer document and navigate to the page you want to link to. Place the cursor at the desired ...
Slide Master SECRETS Revealed in LibreOffice Impress 2024!
Переглядів 1 тис.3 місяці тому
I'm diving into the world of LibreOffice Impress to uncover its best-kept slide secrets, and I'm challenging myself to create an amazing presentation from scratch in just one hour! Unlock the full potential of your presentations with our in-depth tutorial on LibreOffice Impress! In this video, we reveal the secrets to creating stunning slides that captivate your audience and elevate your presen...
How to use the Sum Functions in LibreOffice Calc
Переглядів 4873 місяці тому
How to use the Sum Functions in LibreOffice Calc
Grouping Rows vs SubTotals in LibreOffice Calc - Best Tips and Tricks
Переглядів 7183 місяці тому
Grouping Rows vs SubTotals in LibreOffice Calc - Best Tips and Tricks
Expert Tips for Combining Text in LibreOffice Calc
Переглядів 1,3 тис.4 місяці тому
Expert Tips for Combining Text in LibreOffice Calc
AVERAGEIF Function Tutorial for LibreOffice Calc 2024
Переглядів 3234 місяці тому
AVERAGEIF Function Tutorial for LibreOffice Calc 2024
How to use the SWITCH function in LibreOffice Calc 2024
Переглядів 7204 місяці тому
How to use the SWITCH function in LibreOffice Calc 2024
How LOOKUP functions work in LibreOffice calc 2024
Переглядів 1,2 тис.5 місяців тому
How LOOKUP functions work in LibreOffice calc 2024
Master LibreOffice Calc: Top Functions You Need to Know in 2024
Переглядів 1 тис.5 місяців тому
Master LibreOffice Calc: Top Functions You Need to Know in 2024
Create Weight Tracker in LibreOffice Calc (2024)
Переглядів 3485 місяців тому
Create Weight Tracker in LibreOffice Calc (2024)
Master VLOOKUP: Create stunning charts in LibreOffice Calc
Переглядів 4165 місяців тому
Master VLOOKUP: Create stunning charts in LibreOffice Calc
NEW to LibreOffice Calc - THIS is FOR YOU
Переглядів 7265 місяців тому
NEW to LibreOffice Calc - THIS is FOR YOU
How to SUMMARIZE Filtered Lists in LibreOffice Calc in 2024
Переглядів 4186 місяців тому
How to SUMMARIZE Filtered Lists in LibreOffice Calc in 2024
Easy Time Sheet Tutorial in LibreOffice Calc
Переглядів 8846 місяців тому
Easy Time Sheet Tutorial in LibreOffice Calc
How to Create a Relationship in LibreOffice Base Database!
Переглядів 2,2 тис.6 місяців тому
How to Create a Relationship in LibreOffice Base Database!
How to compare lists between two files in LibreOffice Calc
Переглядів 8306 місяців тому
How to compare lists between two files in LibreOffice Calc
Create an AUTOMATIC CALENDAR in LibreOffice Calc in minutes!
Переглядів 1,7 тис.7 місяців тому
Create an AUTOMATIC CALENDAR in LibreOffice Calc in minutes!
Thank you very much. I have been trying to do this for 2 days. It is not in the help menu.
This video is amazing! Thank you for sharing! 😊
love it
nice one
Check out courses at: www.itseasy.co.uk
but what if you could change the blue squares in your examples to a small picture (you can do this) BUT each point would show the face of the person... so in your example imagine the face of saxton smith jones green etc on your chart
cool
285
thanks
thank you!
You're welcome!
Cool
thanks
Very good thanks
Most welcome
Check out courses at: www.itseasy.co.uk
Thank you
thanks
it would be easier going into destination cell and type = then go to source cell and click on it, enter? So the destination cells is same as the source cell, including formatting. You could also add additional calculations to the destination once the result of the source is added. You may want to calculate a percentage, add/deduct an amount, just type it at the end in the right format.
it would but i wanted to show paste Special
6:05 - Whenever I use a background color or a background image, they only appear as of the presentation (F5), and never on the normal view of the slides. What can I do to change that? It's very hard to organize and design my slides if the BG color or BG images only show up on the show view.
not sure what is going on here i can see mine
@@libreofficetutorials9499 It fixed by itself I don't know how.
this should be integrated to integrate with base
maybe
cool
thanks
Great thanks
You are welcome
Cool
thanks
Thanks for this
thanks
Cool way to filter data
Great video. I am going to enter my lps (6000), as well as my cds(3000). Does bease support autofilling so if i have several recordings of Queen, i could just type qu and it will fill in the rest.
You can create a drop down list and then it will on the first letter
Would be great if there's a formula such as =sparkline(...)
Fill series, check it out
thanks
How would this work if I have a column full IDs that need every account associated with it to be populated as a new row
should work OK, if you create a helper column as shown
is there any way to get similar feature with slicer? thank you sir
I have not seen it yet
Going to make a grocery database to help me meal plan and budget. 😊
You got this!
I think it's important that people leave comments, so that others will know that the video is a good one to watch. Now how many of you actually read this whole comment from start to finish. If you did leave a like, give credit where its due.
thanks
that's good, but how to align them
that is the trick
Love it
thanks
Nice to know
Check box in Calc
Using LibreOffice 7.6.0.3 doesn't have a Layout Tab as far as I can see. However, after much searching, the following gets to the additional Page Break Style drop down options. From the main menu bar select... Insert, then ... More Breaks, then Manual Break. The Page Style option drop down is now available.
thanks
Thanks. Praying this goes as well for me tomorrow.
You got this!
thank you
Nice to know
thanks
Nice
Match Function
Didn't understand that at all. Sorry. So there is not an easy way to add new data to a graph? In Excel you can just click on the graph then drag the box in the data to cover the new values.
It is definitely not Excel
Thanks. For future reference, or anyone else using OpenOffice Calc instead, pretty much means use semi-colon where you would normally expect to use a comma to separate stuff, e.g. =IF(AND(B2="a";D2>2000);"Reasons";"And sht")
thanks
Cool stuff
thanks
Nice to know
thanks
Add a Pivot table %
Thank you for this awesome tutorial!
You're very welcome!
Tiny tip - you can also add a space to the end of a modified column heading and it will allow it.
Yes I do know that, same in Excel, thanks though
You basically missed the whole point of the secrets of slide master. You are not showing how to work with multiple slide masters, how to choose which slide master applies to which slide and so on. You just covered the very basic minimum.
true, I use multiple slide masters myself but if you are new to it I thought covering multiple slide masters might be a step too far. Might be wrong
awesome videos and love it
Thanks!
Thanks I thought there's no such thing in LibreOffice and I have to use filthy ms products
Great tutorial, exactly what I needed! Thanks
Great to hear!
Thanks for the reply. Your videos are very informative and concise and its a shear pleasure to listen to your voice. I have created a database and forms for 37 of my soccer team mates and it came out exactly as per your video. Now I need to created the exact same for another club with 30 members ?. Is there no way that I can just copy the first and save it and change the details ? Please advise and thanks in advance.
yes you can. Create a new file then copy your data and paste it into the new file