- 75
- 17 566
Free Office App Galore
Philippines
Registrace 28. 12. 2022
Smooth operations with LibreOffice's suite of productivity apps are the goal behind this channel. With an estimated 200 Million users worldwide LibreOffice has a very big user base. And the biggest among the "free" suites, especially if you add the 300 Million downloads for Apache OpenOffice, from which LibreOffice is a fork.
Help is not always at your fingertips for open source software, or if yes, many times hid behind lengthy and wordy descriptions understandable only for the "initiated". Using the world's second-biggest search engine CZcams is easier to find a short and crisp answer to your problem. On my channel, an ordinary guy will give you the solution to your problem in ordinary language.
Help is not always at your fingertips for open source software, or if yes, many times hid behind lengthy and wordy descriptions understandable only for the "initiated". Using the world's second-biggest search engine CZcams is easier to find a short and crisp answer to your problem. On my channel, an ordinary guy will give you the solution to your problem in ordinary language.
How to Extract Tabular Data
In this video, I will show you how to extract tabular data from websites and import it into a LibreOffice Calc spreadsheet.
zhlédnutí: 35
Video
How to Find and Replace Empty Cells
zhlédnutí 29Před měsícem
In today's short video, I will show you how to find blank cells in a table and fill them with content.
How to Animate Text
zhlédnutí 44Před měsícem
In this video, I will show you how to make lines, words, or letters appear individually in LibreOffice Impress.
How to Set Up a Presentation
zhlédnutí 24Před 2 měsíci
In this video, I will show you the basics of how to set up a presentation in LibreOffice Impress.
How to Calculate Interest and the Power of Compounded Interest
zhlédnutí 2Před 2 měsíci
In this video, I will show you the power of compounded interest and how to calculate it. I will also tell you the story of the "Joseph's Penny". See also www.schwiizerfranke.com/en/josephspfennig. (Don't worry, it's in English.)
How to Edit a PDF File
zhlédnutí 57Před 2 měsíci
In this video, I will show you three short steps on how to edit a PDF file in LibreOffice Draw. IMPORTANT: Make sure you have legal permission before editing a PDF file online. It is your sole responsibility.
How to Create QR Code and Barcode
zhlédnutí 48Před 3 měsíci
In this short video, I will show how you can create a QR code or a bar code in LibreOffice Calc. With a code scanner on your cell phone, you can check the code immediately.
How to Create a Flowchart
zhlédnutí 89Před 3 měsíci
In this video, I will show you how to create a flowchart in LibreOffice Draw. A flowchart uses standardized geometric shapes to show a computer program's logical sequence of steps. 00:00 Intro 00:09 What is a Flowchart 00:19 Elements of a Flowchart 00:50 Draw the Flowchart 03:09 Outro
How to Create a Bubble Chart
zhlédnutí 102Před 3 měsíci
Learn how to use LibreOffice Calc to create a bubble chart with three or more variables. This step-by-step tutorial will guide you through the process of creating a visual representation of your data. Impress your colleagues and make data analysis easier with this handy skill! If you want to know more about bubble charts in general, and the "do's and don'ts" of these special charts, follow this...
How to Use the COUNTIF Function
zhlédnutí 16Před 4 měsíci
In this video, I will show you how to use the COUNTIF function in LibreOffice Calc. You will learn how to apply COUNTIF with eleven different use cases.
How to Use the AND Function
zhlédnutí 23Před 4 měsíci
In this video, I will show how to use the AND function in LibreOffice Calc. Table of Contents: 00:00 Intro 00:09 What is the AND function? 00:30 A smaller than B? 01:00 A larger than B? 01:28 A equal to B? 01:52 Outro CZcams does not like the arrows for the equations, so I had to write them out!
How to Create a Mindmap in Draw
zhlédnutí 210Před 4 měsíci
In this video, I will show you how to create a mind map in LibreOffice Draw. Table of Contents: 00:00 Introduction 00:38 Page Orientation 00:56 Find and Configure Rounded Rectangles 01:12 Create the center ellipse and insert text 01:38 Edit text 01:59 Edit the ellipse's style 02:22 Create a rectangle and insert text 03:06 Edit text 03:21 Edit the rectangle's style 03:43 Connecting the elements ...
How to Create and Customize Charts
zhlédnutí 44Před 6 měsíci
In this video, I will walk you through the process of creating and customizing charts in LibreOffice Calc. I will give you hints of which chart to create for what purpose.
Formulas Made Easy-Click and Drop
zhlédnutí 39Před 6 měsíci
In this video, I will show you how to crunch numbers efficiently by clicking and dropping data. This will make your data entry faster and easier.
How to Password Protect Your Files
zhlédnutí 52Před 8 měsíci
In this video, I will show you how to protect your files and documents with a password. It is a simple and straightforward process. IMPORTANT: Never forget your password. Without it you cannot recover your file anymore!
How to Automatically Fill In Weekdays, Months, and Dates
zhlédnutí 28Před 9 měsíci
How to Automatically Fill In Weekdays, Months, and Dates
How to Change Font Color (and Other Effects)
zhlédnutí 209Před rokem
How to Change Font Color (and Other Effects)
How to Change Font, Font Size, and Style
zhlédnutí 1,1KPřed rokem
How to Change Font, Font Size, and Style
How to Add Checkboxes (and Other Forms)
zhlédnutí 74Před rokem
How to Add Checkboxes (and Other Forms)
How to Hide and Show Rows, Columns, and Sheets
zhlédnutí 34Před rokem
How to Hide and Show Rows, Columns, and Sheets
THANKK YOUUUUUUUUU
Glad I could help!
Promo-SM 🤭
Can you tell me please what Promo-SM means!
Nice tutorial! Thanks!
Glad it was helpful!
Thank you for your tutorial!
Thank you for watching and for your kind words!
0:43
Hi, what do you mean by that? Elaborate a little, please!
Thank you sire
You are most welcome!
When I try to split the data in a row, in the text to column window, each row is separated by an empty row. For example in text to column Row 1 cabinet part A data string, Row 2 is empty, Row 3 cabinet part B data string, Row 4 is empty. So when I OK the split the information is now in every second row and does not line up with the information on the left and extends further down.
Hello there, I don't quite understand. You say you want "to split data in a row", do you really mean "row", or do you mean column? Send me some screenshots or even a short screen recording of your problem so that we can troubleshoot together.
@@officeappuniversity Isn't a column vertical and a row horizontal? How do I send you screen shots?
Hi, of course you are correct, column is vertical and row horizontal. Please send your screenshot to "officeappuniversity8105@gmail.com". Honestly I am a little confused about your terms "...cabinet part B data string". So I need to see what you mean. By the way, did you consult the blog I linked in the video's description? And one more thing: my LO's version is 7.5.
@@officeappuniversity I sent you an email with screenshots. A picture is worth a thousand words. Although not showing I have tried placing multiple columns on the left side and still have the same results.
Dude, clear and easy to understand. Awesome! Thank you!
You are welcome and thank you for your nice comment.
Thanks for the information !
You're welcome! I'm glad you found the information helpful.
that was helpful thanks
Thank you very much, dear Alqissa_Wally_Kan. Hope you will subscribe to my channel!
done you deserve it@@officeappuniversity
Thank you! Sorry to be so late, saw your reply only now!
lol i watch this to reverse it
Good idea and creative!
Can we do transition in libre office - impress
Yes, you can. Please have a look at: help.libreoffice.org/latest/en-US/text/simpress/guide/animated_slidechange.html. I hope that helps, if not, let me know!
Thank you so much sir
🤪 *Promo SM*
☹️ "PromoSM".
Hi, thank you for the first-ever comment on my channel! But what exactly do you mean?