![LibreOffice Tutorials](/img/default-banner.jpg)
- 145
- 343 098
LibreOffice Tutorials
United Kingdom
Registrace 22. 04. 2013
LibreOffice Tutorials Calc, Writer, Impress
Expert Tips for Combining Text in LibreOffice Calc
Combining text in LibreOffice Calc just got way easier, and I'm about to share expert tips that will change the way you work with spreadsheets forever! Unlock the full potential of LibreOffice Calc with our expert tips for combining text in 2024! In this video, we’ll guide you through the various methods to efficiently merge text strings, including using the CONCATENATE function, the CONCAT operator, and text joining techniques. Whether you’re creating reports, compiling data, or simply want to enhance your spreadsheet skills, these practical tips will streamline your workflow and save you time. #calc #textjoin LibreOffice Calc tutorial
Learn how to:
- Use the CONCATENATE function effectively
- Combine text using the CONCAT operator
- Utilize text formatting options for better presentation
- Troubleshoot common issues when merging text
- Explore advanced techniques for dynamic text combination
Perfect for beginners and experienced users alike, this video will help you master text combination in LibreOffice Calc. Don’t forget to subscribe for more valuable tips and tricks to enhance your spreadsheet experience in 2024!
#LibreOffice #Calc #TextCombining #SpreadsheetTips #2024Skills
#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
Learn how to:
- Use the CONCATENATE function effectively
- Combine text using the CONCAT operator
- Utilize text formatting options for better presentation
- Troubleshoot common issues when merging text
- Explore advanced techniques for dynamic text combination
Perfect for beginners and experienced users alike, this video will help you master text combination in LibreOffice Calc. Don’t forget to subscribe for more valuable tips and tricks to enhance your spreadsheet experience in 2024!
#LibreOffice #Calc #TextCombining #SpreadsheetTips #2024Skills
#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
zhlédnutí: 124
Video
AVERAGEIF Function Tutorial for LibreOffice Calc 2024
zhlédnutí 144Před 21 hodinou
Boost your spreadsheet skills with the most powerful AVERAGEIF function tutorial you've ever seen! Learn how to use the AVERAGEIF function in LibreOffice Calc in this step-by-step tutorial for 2024. The AVERAGEIF function allows you to calculate the average of a range of cells based on specific criteria, making your data analysis more efficient. Watch this tutorial to master this powerful funct...
How to use the SWITCH function in LibreOffice Calc 2024
zhlédnutí 371Před 14 dny
I'll show you how to become a LibreOffice Calc SWITCH function pro in no time - 2024's ultimate tutorial is here! In this ultimate tutorial for 2024, learn how to master the SWITCH function in LibreOffice Calc. The SWITCH function is a powerful tool that allows you to easily evaluate multiple conditions and return a result based on the first true condition. Follow along step-by-step as we demon...
How LOOKUP functions work in LibreOffice calc 2024
zhlédnutí 406Před 21 dnem
I'll show you the easiest way to master LOOKUP functions in LibreOffice Calc, even if you're a total beginner! In this step-by-step tutorial, learn how to master LOOKUP functions in LibreOffice Calc 2024. Discover how LOOKUP functions work in LibreOffice Calc 2024 and how you can use them effectively in your spreadsheets. Improve your data analysis skills and become more efficient in organizing...
Master LibreOffice Calc: Top Functions You Need to Know in 2024
zhlédnutí 495Před 28 dny
I'm about to reveal the top LibreOffice Calc functions you need to know to conquer 2024 like a pro! In this video, we will dive into the top functions you need to know in LibreOffice Calc for 2024. Whether you are a beginner or looking to enhance your skills, understanding these common functions will help you become a master at using Calc. Stay tuned to learn valuable tips and tricks to boost y...
Create Weight Tracker in LibreOffice Calc (2024)
zhlédnutí 216Před měsícem
Track your weight like a pro with this simple LibreOffice Calc tutorial - no more excuses for missing your fitness goals! Learn how to create a weight tracker using LibreOffice Calc in this step-by-step tutorial. Keeping track of your weight in a spreadsheet can help you stay motivated and reach your fitness goals. Follow along and start monitoring your progress today! #LibreOfficeCalc #WeightT...
Master VLOOKUP: Create stunning charts in LibreOffice Calc
zhlédnutí 237Před měsícem
Watch me reveal the secret to using VLOOKUP to create jaw-dropping charts in LibreOffice Calc! In this tutorial, you will learn how to master VLOOKUP in LibreOffice Calc to create visually stunning and data-rich charts. VLOOKUP is a powerful function that allows you to search for a value in a table and return a corresponding value. By mastering VLOOKUP, you can enhance your charting skills and ...
NEW to LibreOffice Calc - THIS is FOR YOU
zhlédnutí 379Před měsícem
This tutorial is for NEW USERS. If you have not used LibreOffice Calc before then this video is for you. The tutorial covers basic formatting, simples sums and how to create a chart in LibreOffice Calc. NEW to LibreOffice Calc - THIS is FOR YOU. LibreOffice Calc tutorial #calc #libreoffice If you want to support me, check this out: www.patreon.com/itseasy Classroom based courses can be arranged...
How to SUMMARIZE Filtered Lists in LibreOffice Calc in 2024
zhlédnutí 236Před měsícem
I've cracked the code on how to summarize filtered lists in LibreOffice Calc like a pro, even in 2024! Learn how to effectively summarize filtered lists in LibreOffice Calc in 2024 with this easy-to-follow tutorial. Whether you are a student, professional, or just someone looking to enhance your spreadsheet skills, this video will guide you through the process step by step. By the end of this t...
Easy Time Sheet Tutorial in LibreOffice Calc
zhlédnutí 347Před 2 měsíci
Master time sheet creation in LibreOffice Calc with these simple steps - you'll be a pro in no time! Learn how to create professional time sheets in LibreOffice Calc with this step-by-step tutorial. Whether you're tracking your own work hours or managing a team's time, this easy tutorial will guide you through the process. From formatting cells to calculating totals, you'll master time sheets l...
How to Create a Relationship in LibreOffice Base Database!
zhlédnutí 609Před 2 měsíci
Watch me show you the easiest way to build a strong relationship in your LibreOffice Base database! Learn how to create a relationship in LibreOffice Base Database with this step-by-step tutorial. Establishing relationships between tables is crucial for organizing data efficiently and ensuring data integrity. Follow along as we guide you through the process of creating relationships in LibreOff...
How to compare lists between two files in LibreOffice Calc
zhlédnutí 454Před 2 měsíci
I'll show you the quickest and easiest way to compare lists in LibreOffice Calc, saving you hours of tedious work! Learn how to compare lists in LibreOffice Calc with this step-by-step tutorial. In this video, we will show you how to compare lists between two files in LibreOffice Calc, helping you easily identify differences and similarities. Stay tuned to master this essential skill for data a...
Create an AUTOMATIC CALENDAR in LibreOffice Calc in minutes!
zhlédnutí 838Před 2 měsíci
Say goodbye to manual calendar creation - learn how to automate it in LibreOffice Calc within minutes! Learn how to easily create an automatic calendar in minutes using LibreOffice Calc! This step-by-step tutorial will guide you through the process, helping you save time and stay organized. Watch now to streamline your calendar creation process! LibreOffice Calc tutorial. #calc #libreoffice If ...
Creating Tables in LibreOffice Base Database in a Few Easy Steps
zhlédnutí 1,1KPřed 3 měsíci
Learn how to effortlessly design professional-looking tables in LibreOffice Base with just a few simple steps! Learn how to create tables in LibreOffice Base database in a few easy steps with this tutorial. Whether you are new to database management or looking to enhance your skills, this guide will walk you through the process seamlessly. Watch now to master the art of creating tables in Libre...
Create a Gantt Chart in LibreOffice Calc in 2024
zhlédnutí 1,2KPřed 3 měsíci
Say goodbye to confusing project timelines - I'll show you how to easily create a Gantt Chart in LibreOffice Calc for 2024! Learn how to create a Gantt Chart in LibreOffice Calc in 2024 with this step-by-step tutorial. Gantt charts are essential tools for project management, and using LibreOffice Calc makes the process efficient and easy. Follow along as we demonstrate the process of setting up...
Master Creating Timelines in LibreOffice Calc
zhlédnutí 655Před 3 měsíci
Master Creating Timelines in LibreOffice Calc
Why you need multiple headers in LibreOffice
zhlédnutí 415Před 3 měsíci
Why you need multiple headers in LibreOffice
Unlocking Pivot Table Secrets: % Difference, Totals
zhlédnutí 597Před 3 měsíci
Unlocking Pivot Table Secrets: % Difference, Totals
How to multiply with Paste Special in LibreOffice Calc
zhlédnutí 771Před 4 měsíci
How to multiply with Paste Special in LibreOffice Calc
How to create a moving average in LibreOffice Calc
zhlédnutí 526Před 4 měsíci
How to create a moving average in LibreOffice Calc
How to automatically add a prefix in LibreOffice Calc
zhlédnutí 619Před 4 měsíci
How to automatically add a prefix in LibreOffice Calc
Link data from Calc into Writer and have it automatically update.
zhlédnutí 890Před 5 měsíci
Link data from Calc into Writer and have it automatically update.
How to work out loan repayments in seconds in LibreOffice Calc
zhlédnutí 475Před 5 měsíci
How to work out loan repayments in seconds in LibreOffice Calc
How to use filters in LibreOffice Calc
zhlédnutí 3,7KPřed 5 měsíci
How to use filters in LibreOffice Calc
How to return multiple rows with a Vlookup
zhlédnutí 9KPřed 6 měsíci
How to return multiple rows with a Vlookup
How to use the count functions in LibreOffice Calc
zhlédnutí 1,4KPřed 6 měsíci
How to use the count functions in LibreOffice Calc
How to use the SumIF function to create a dynamic chart
zhlédnutí 843Před 6 měsíci
How to use the SumIF function to create a dynamic chart
Master the Art of BPMN Diagrams in LibreOffice Draw
zhlédnutí 890Před 6 měsíci
Master the Art of BPMN Diagrams in LibreOffice Draw
Is it possible to group image and text in LibreOffice Calc cell? Format -> Group is not active. Any tricks? Thanks
not that I can do
I'm working with spreadsheets again for the first time in two decades. Thanks for these, they're very helpful!
Glad you like them!
TextJoin: First you say you ”cheat” by adding a space to each cell, then you enter a space as a delimiter, so now you have two spaces between each word, so why adding the spaces in the cells in the first place?
Good info thanks
You bet
Love it
thanks
Nice and easy again thanks
Most welcome 😊
Simple must know stuff
thank you so much. I can see that I just needed to update my LibreOffice with "sudo apt upgrade libreoffice" Command 👍🏾 for linux, Ubuntu.
Top banana, thank you. 😊
Thank you too!
I will test this out on two test files. If it works, it's exactly what I have been looking for.
good luck
The problem is that LO Impress doesn't support most common video formats, like eg MP4. Without an explanation what formats are supported, and how to convert other formats into supported formats, any intro on how to use video in LO Impress is as useless as feathers on a fish!
I will check
AVERAGEIF function
thank you for your clear explanation on index & match function for librecalc
Glad it was helpful!
Another great tutorial 👍 Thank you
thanks
Thank you!
You're welcome!
Thanks for the lesson! Could you show some day more tricks with formatting as on 3:26?
will do
Enjoy this Thank you! This will come in handy great work 👍
Glad it was helpful!
So how do two people take one course? I see how one person takes two courses, there's got to be a way to add more people to one course?
Create a query with courses and students, where the course table is the main table a one to many with students
Very useful
Glad you think so!
Thanks for this
No problem
Uses of the Switch Function
Libre office calc me Cell select karte samay, cell ka jo border highlight hota hai, usko highlighting border ko or jayada deep ya different colour kaise de? Taki bahot sare data, me se kisi value ko search karte samay, vo searched value easily dikh Jaye.
I have a video in Excel which explains it but not calc
@@libreofficetutorials9499 ok please tell the same in excel
I actually read the documentation for Calc and it doesn't have most of this info. The video goes a _little_ too fast, I'm going to have to watch it a few times to catch everything.
sorry about that
Great presentation my guy
Glad you enjoyed
Thank You So Much, so clear and minimal, just what I needed!
Glad it helped!
Moved over from excel Amazing Thank you!
Glad it helped!
How do you do currency conversion like in Excel? Like lets say if I want to convert USD to MXN what do I need to do? Or do you have a video on that already?
you would have to do the sum
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?
do you mean make the active cell colour up?
@@libreofficetutorials9499 yes
Cool thanks
thanks
Really useful
thanks
Get started with lookup functions in Calc
Nice one
Thanks for watching
Thank you, good info, clearly and nicely presented.
Good to know
thanks
Thanks
Welcome
Easy to follow
They sure did a great job of making it unintuitive. I never would have figured that out on my own.
it is querky
If you have created a table but realise you have missed fields out and want to add them how do you reorder the fields?
select edit, then you get back into it. try right clicking on a table
thanks
thanks
Create your own tracker
Is there a way to create an outline as it functions in Google Docs? Where it's the left-hand side tab that works as a set of bookmarks that can help you locate and jump to different parts of a larger document?
Not sure what you mean here
@@libreofficetutorials9499 In google docs you can select text and select "Title, Subtitle, Heading 1, 2, 3, etc" And when you do that- it creates an outline on a sidebar on the left- based on which text is labeled as a title or header. I would like to know how to do this in Libra as well, so that I could click on the parts i bookmarked as headers and jump to that part in the document more effeciently.
Nice and clean tutorial, easy to follow and very helpful. Thank you.👍
Glad it was helpful!
sorry but sound is a disaster
Really, It sound OK for me
Thanks. How can I protect the design from end user and how does it look at the data entries? after we finish the design? The window or Icone on disc top.
Not sure what you mean here
very useful, thanks
Glad it was helpful!
Thanks for this
No problem
Nice and easy
Thanks a lot 😊
Add a chart to a Vlookup
NEW User - LibreOffice Calc
👍
great intro!
Thanks!