-
Advanced Options for Standard Filter in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need more advanced Filters? This video is for you. You can filter using regular expressions, eliminating duplications and use many other options. Date 2021 Language English URL https://www.youtube.com/watch?v=SkpTanQHZlU&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=59 Running Time 7:16 -
Changing Toolbar Icon Style and Size in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how to personalize your icons style and size based on your preferences. It’s very easy and you have a lot to choose from. Date 2020 Language English URL https://www.youtube.com/watch?v=KLeVsgbQt5Q&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=6 Running Time 4:54 -
Formatting the DATE for Each Language in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you can learn how to use LibreOffice Calc when you deal with multiple languages in your work. Date 2021 Language English URL https://www.youtube.com/watch?v=LnthS7eRwRQ&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=28 Running Time 2:45 -
Higher Working Speed with Autoinput in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you can learn how to use Autoinput in order to speed your workflow. Also the shortcuts are very usefull. Date 2021 Language English URL https://www.youtube.com/watch?v=wtWcVELi1g0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=30 Running Time 2:22 -
How Many Characters in a Cell? How to Add Multiple Paragraphs in a Single Cell? LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn about the upper limits of LibreOffice Calc, you can insert a lot of text in every cell. And also you will learn about adding different paragraphs in the same cell. Very useful when you want to format cells in a certain way. Date 2021 Language English URL https://www.youtube.com/watch?v=dmEuiVK-K8U&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=27 Running Time 5:06 -
How to Add Sheets and the Options for Each Sheet in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn many options that you have for inserting sheets (for example you can insert 500 sheets at once) and also how to change the sheets color, rename them and so on in LibreOffice Calc. Date 2020 Language English URL https://www.youtube.com/watch?v=Qo4EthozjJY&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=8 Running Time 6:25 -
How to Calculate the Days or Months between 2 Dates…
Type Video Recording Director LO Step by Step Abstract In this video you can learn how to calculate very easy how many days, or months (weeks, years, so on… are between 2 dates. Date 2019 Language English URL https://www.youtube.com/watch?v=4b_fL_l3OKE&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=3 Running Time 2:52 -
How to Calculate VAT using LibreOffice Calc
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to calculate VAT using Libre Office Calc Spreadsheet. Date 2018 Language English URL https://www.youtube.com/watch?v=2whakew0ZHU&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=7 Running Time 7:26 -
How to Change Spreadsheet Theme in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you want different looking spreedsheets? Do you want your own style? This video is for you. Date 2021 Language English URL https://www.youtube.com/watch?v=GF7cZRScGvA&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=47 Running Time 4:33 -
How to Convert into DECIMAL Any Number in Base 2 – 36 in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Need a quick way of transforming numbers from different base to decimal? This video is for you. Date 2021 Language English URL https://www.youtube.com/watch?v=ZivRvlW48z0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=64 Running Time 1:49 -
How to Convert into ROMAN NUMERALS in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Your children need to learn roman numerals? A easy way to do is by using the formula from LibreOffice Calc. See the video how to set up this formula. Date 2021 Language English URL https://www.youtube.com/watch?v=TSV2HHFhGyE&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=63 Running Time 3:04 -
How to Create a CSV File Using LibreOffice Calc
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to create a CSV file using Libre Office Calc. Date 2018 Language English URL https://www.youtube.com/watch?v=6WPHnobtrYc&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=15 Running Time 6:10 -
How to Create Charts in LibreOffice Calc
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to create charts using LibreOffice Calc. Date 2017 Language English URL https://www.youtube.com/watch?v=YskcMMEfxZs&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=30 Running Time 14:46 -
How to Customize Toolbar Position and Toolbar Items in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn about changing the position for toolbar from docked (fixed) to floating (movable) and reverse. Also you will learn how to add more buttons on the toolbar in LibreOffice Calc. Date 2020 Language English URL https://www.youtube.com/watch?v=GE0dbgpeCEE&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=7 Running Time 6:12 -
How to Define your own Fill Series in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract This video describe how you can define your own series in order to speed your input in LibreOffice Calc. You can create your lists and use them how many times you want. Date 2021 Language English URL https://www.youtube.com/watch?v=W8s7PimzL3s&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=33 Running Time 3:43 -
How to Delete Rows, Columns and Cells in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video we will learn how to delete a single row/column or multiple rows/columns or single/multiple cells (using 3 methods). Date 2020 Language English URL https://www.youtube.com/watch?v=GYvoaM4LFtg&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=18 Running Time 7:25 -
How to Edit, Replace or Delete Data in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Some details in this video about editing, replacing or deleting data in LibreOffice Calc. Useful for fast editing and also for not removing the formats when in fact you need it. Date 2021 Language English URL https://www.youtube.com/watch?v=ROFeNGUlDAw&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=38 Running Time 5:49 -
How to Format the Text in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn to change the text in LibreOffice Calc cells, in order to create beautiful documents for your students, clients, and so on. Date 2021 Language English URL https://www.youtube.com/watch?v=DbAfI_tUnZE&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=42 Running Time 5:02 -
How to Freeze Rows and Columns in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you want to see always the first columns or rows in any sheet you want? Freezing rows and columns is the tools for you. Do you want to know the shortcut? See the video Date 2020 Language English URL https://www.youtube.com/watch?v=0_tgo-3h2Qw&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=19 Running Time 3:26 -
How to Generate and Open a CSV File in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn to save a .odf, xls or xlsx file as a CSV file and also how to open a CSV file with LibreOffice Calc. Date 2020 Language English URL https://www.youtube.com/watch?v=ZeWfBTQlOvk&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=10 Running Time 8:13 -
How to Hide and Show Sheets in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need some columns/rows with many formula to be hidden from your report? This is what you need to know. Date 2021 Language English URL https://www.youtube.com/watch?v=hbfY2bme6Ls&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=55 Running Time 1:30 -
How to Hide Cells Content in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract You need to hide the formula in one or more cells? Don’t want to print some elements from a sheet? This video is for you Date 2021 Language English URL https://www.youtube.com/watch?v=1HlQqpVHuOE&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=57 Running Time 2:45 -
How to Hide/Show Rows/Columns in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need some columns/rows with many formula to be hidden from your report? This is what you need to know. Date 2021 Language English URL https://www.youtube.com/watch?v=hbfY2bme6Ls&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=56 Running Time 1:27 -
How to Insert Rows and Columns in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how to insert columns and rows in LibreOffice Calc, and also you wil learn how the formatting will be done to the new columns/rows. Date 2020 Language English URL https://www.youtube.com/watch?v=OBjWYf4SO5o&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=17 Running Time 7:12 -
How to Navigate from a Cell or to a Cell in LibreOffice Calc Using Different Methods
Type Video Recording Director LO Step by Step Abstract In this video you will learn some methods to navigate to and from a cell to another cells very quick and using keyboard shortcuts and not only that. Date 2020 Language English URL https://www.youtube.com/watch?v=bPCP4gJgSlU&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=12 Running Time 6:56 -
How to Remove Duplicates from a Spreadsheet Using LibreOffice Calc
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to create a custom background for Libre Office Impress presentation slides. Date 2019 Language English URL https://www.youtube.com/watch?v=a-EmSL1Zmrw&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=11 Running Time 6:16 -
How to Save a File in LibreOffice Calc and How to Change the Default Format
Type Video Recording Director LO Step by Step Abstract In this video you will learn to save a document as xls, xlsx, odf, csv, depending what you want from that file in LibreOffice Calc. Date 2020 Language English URL https://www.youtube.com/watch?v=fEuD9WQMHA0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=11 Running Time 4:17 -
How to Select Cells in LibreOffice Calc Using Different Methods
Type Video Recording Director LO Step by Step Abstract In this video you will learn some methods to select one or more cells in LibreOffice Calc using the mouse or without it. Date 2020 Language English URL https://www.youtube.com/watch?v=7suzOphyTis&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=13 Running Time 5:08 -
How to Select Cells on Different Rows/Columns in the Same Selection in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how to select different cells that are not continuous in the same slection in LibreOffice Calc Date 2020 Language English URL https://www.youtube.com/watch?v=3mow_ixRglc&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=14 Running Time 2:25 -
How to Select Rows and Columns in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Not available. Date 2020 Language English URL https://www.youtube.com/watch?v=IYNXWPqc_M4&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=15 Running Time 5:45 -
How to Select Sheets in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Not available. Date 2020 Language English URL https://www.youtube.com/watch?v=Q0pXt2HLoj4&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=16 Running Time 4:31 -
How to Set Beautiful Cell Borders in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract If you need your presentation to have beautiful borders, maybe in many colors, this video is for you. Date 2021 Language English URL https://www.youtube.com/watch?v=ilt0IXIXyL8&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=44 Running Time 4:26 -
How to Sort Columns in LibreOffice Calc
Type Video Recording Director DCP Web Designers Abstract How to Sort Columns in Spreadsheet Date 2019 Language English URL https://www.youtube.com/watch?v=MOEhRbgC_PE&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=9 Running Time 5:49 -
How to Split the Screen in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you want to see data in multiple parts of the same sheet? Than, this option is for you. Find out how to activate it, and the methods of disactivate it. It’s much easier than you think. Date 2020 Language English URL https://www.youtube.com/watch?v=Uvek76OWII4&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=20 Running Time 4:21 -
How to Use AND Function in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Need to make analysis for your data? Maybe AND is the formula you are looking for. Date 2021 Language English URL https://www.youtube.com/watch?v=YzdusOWmkBs&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=61 Running Time 2:49 -
How to Use AutoFilter and Standard Filter in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract When you need to select your data by some criteria, you would need to use filter. AutoFilter is easier to use and also very quick. Standard Filter is not very advanced but more powerful. Date 2021 Language English URL https://www.youtube.com/watch?v=tYC1b7EvTB0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=58 Running Time 4:53 -
How to Use AutoFormat in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract If you need your project to look consistent and all the tables to be formated the same this video is for you. Your documents will look nicer and you will work less in order to create and style them. Date 2021 Language English URL https://www.youtube.com/watch?v=HzLyRUqiG-c&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=46 Running Time 3:05 -
How to Use Cell Background in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Want to create very easy a chess board? Do you know easy way to do that? See the video Date 2021 Language English URL https://www.youtube.com/watch?v=4Tky5tgIFgM&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=45 Running Time 1:47 -
How to Use Conditional Formatting with Color Scale in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract For many people colors means something, more than simple data in a table. In this case this video could help you to make your table to speak to you through colors. Date 2021 Language English URL https://www.youtube.com/watch?v=IIdqcI4WA9Q&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=52 Running Time 5:37 -
How to Use Conditional Formatting with Condition in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Need to have a visual understanding of your data? if yes, this is what you need. You cand adjust this by many criteria like median, sum, average, and so on. And all the data will be dynamic. Date 2021 Language English URL https://www.youtube.com/watch?v=ZJ6CvsGIWzM&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=50 Running Time 3:25 -
How to Use Conditional Formatting with Data Bar in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need a visual help for your data? It seems you need Data Bar. This is what you need to now about it. Date 2021 Language English URL https://www.youtube.com/watch?v=ESQEMozkBF4&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=53 Running Time 4:47 -
How to Use Conditional Formatting with Icon Set in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract You like visual help for your data, but you don’t like data bar? Than Icon Set is for you, with intervals from 3 to 5, and many colors and shapes. Date 2021 Language English URL https://www.youtube.com/watch?v=uFl-MDlE4jo&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=53 Running Time 4:32 -
How to Use Document Properties in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how you can use document properties informations. And how you can edit them. Or how can you stop allow them for a document. Date 2020 Language English URL https://www.youtube.com/watch?v=tKqbyaTtXiM&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=22 Running Time 5:59 -
How to Use DOLLAR Function for Local Currency Format in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need to print the same list of prices in different currency formats? This video is for you. Date 2021 Language English URL https://www.youtube.com/watch?v=bIjxtD_vT9I&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=64 Running Time 4:13 -
How to Use FALSE Function in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Is FALSE a function? It seems yes. And the single reason is for sheets calculations, it doesn’t have any parameters to fill in, but it is very useful. See the video. Date 2021 Language English URL https://www.youtube.com/watch?v=5AWhix0kCXY&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=62 Running Time 3:14 -
How to Use Fill Series for Higher Working Speed in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video I used Fill Series for inserting very fast in a table. This way LibreOffice helps you to speed up your work and do your job when you have a lot to insert. Date 2021 Language English URL https://www.youtube.com/watch?v=2m7gfgw4fME&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=31 Running Time 6:46 -
How to Use Font Embedding and Document Statistics in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need some statistics abour your document? Do you need to print a report on another computer and want to have the same style? This video is for you. Learn about embeded fonts and document statistic in this video. Date 2021 Language English URL https://www.youtube.com/watch?v=NIKOQxos9dY&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=24 Running Time 5:15 -
How to Use Formula Bar in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn eveything about Formula Bar, how to use all elements that it contains in LibreOffice Calc. How to use Name box, Function Wizard, Select Function, Formula and Input Line. And also how to insert a formula and how to edit an existing one. Date 2020 Language English URL https://www.youtube.com/watch?v=VDdMQxAUOFs&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=9 Running Time 5:11 -
How to Use Goal Seek in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract A very useful tool for quick results in your tables. Date 2021 Language English URL https://www.youtube.com/watch?v=y7SEw8EOUfM&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=66 Running Time 2:53 -
How to Use Merge and Split in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how to use merge and split in order to combine cells or split them again. Very useful when you need more columns with the same explaination. Date 2021 Language English URL https://www.youtube.com/watch?v=8m4igeiN8B0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=34 Running Time 3:33 -
How to Use Paste Special, with Examples
Type Video Recording Director LO Step by Step Abstract In this video you will learn about all the options that we have in LibreOffice Calc – Paste Special Window. It’s much better to play with this option in order lo learn more. Date 2021 Language English URL https://www.youtube.com/watch?v=cp1hVf5taTs&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=39 Running Time 12:21 -
How to Use Pivot Table in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract If you need to “play” with data, Pivot Table is for you. You can have a very good image of your data and shows you just the info you need. Date 2021 Language English URL https://www.youtube.com/watch?v=usMA1X_c9F0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=51 Running Time 8:57 -
How to Use REGEX in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you want advanced search for LibreOffice calc? This video is for you. Regular expression are a very powerful tools in order to create complex search patterns. Date 2021 Language English URL https://www.youtube.com/watch?v=okhT1INBW7I&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=25 Running Time 5:53 -
How to Use REPLACE Function in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Do you need to replace some years or numbers with something else? It’s very easy. Check out the video. Date 2021 Language English URL https://www.youtube.com/watch?v=0GZ6CXd-nAo&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=60 Running Time 4:23 -
How to Use Security Options in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn 2 features from Security tab (Properties) in order to protect your document and also force the check for changes. Date 2020 Language English URL https://www.youtube.com/watch?v=z1e5Wr36l5s&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=23 Running Time 4:52 -
How to Use Select All Sheets in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract A very powerful tool I wish I knew earlier. It can improve your eficiency, but you need also to be careful when using it. Date 2021 Language English URL https://www.youtube.com/watch?v=MjpMrnSE8c0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=35 Running Time 4:17 -
How to Use the Navigator in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how to open the Navigator, why it is useful and how to use it by example. Date 2020 Language English URL https://www.youtube.com/watch?v=0hM7uC-yrHs&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=21 Running Time 5:11 -
How to Use Value Highlighting in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Possible errors in spreadsheets? How to fix them quickly? See how… Date 2021 Language English URL https://www.youtube.com/watch?v=bwaphO-gw94&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=48 Running Time 4:01 -
How to Validate Date and Time, Cell Range, List and Text Legth in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract When you need to avoid errors in inputing data, or you need more precise anc coincise input validating data should be a must. Watch the video for more info. Date 2021 Language English URL https://www.youtube.com/watch?v=6fHqBToqZQU&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=37 Running Time 8:12 -
How to Validate Numbers in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract It’s important for you what numbers insert the users in your form? If your data is very important to be consistent please watch this video. Date 2021 Language English URL https://www.youtube.com/watch?v=qjZvEFk9Kb0&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=36 Running Time 9:09 -
Inserting Fields in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn how to use the current date, the name of the sheet or the name of the document and how to insert them into a LibreOffice document. Date 2021 Language English URL https://www.youtube.com/watch?v=o_FBmuK5Flo&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=40 Running Time 2:45 -
Inserting Multiple Lines of Text into the Same Cell (3 methods)
Type Video Recording Director LO Step by Step Abstract This video will show you 3 methods of inserting a text on multiple lines into the same cell. Very useful when you need your text to be well arranged. Date 2021 Language English URL https://www.youtube.com/watch?v=LPyckV5ihQg&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=41 Running Time 4:25 -
LibreOffice Calc – Absolute and Relative References
Type Video Recording Director Panopia Tutorials Abstract How to use absolute and relative cell references. Date 2015 Language English URL https://www.youtube.com/watch?v=NXWjDsxZpGY&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=16 Running Time 7:25 -
LibreOffice Calc – Adding Numbers in Different Sheets but the Same Cell
Type Video Recording Director OS College Abstract This video demonstrates how to add numbers from different sheets but in the same cell in a LibreOffice Calc workbook. Date 2020 Language English URL https://www.youtube.com/watch?v=u1ybsOu7EnI&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=31 Running Time 2:12 -
LibreOffice Calc – Advanced Filter
Type Video Recording Director Panopia Tutorials Abstract The Advanced filter is demonstrated. Date 2015 Language English URL https://www.youtube.com/watch?v=r8pK4B_aJl8&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=3 Running Time 5:00 -
LibreOffice Calc – Advanced Filter
Type Video Recording Director Sean Johnson Abstract LibreOffice Calc Advanced Filter is similar to Excel’s Advanced Filter minus some functionality however it is more powerful than it appears. Date 2017 Language English URL https://www.youtube.com/watch?v=5HktMHR9vWs&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=3 Running Time 10:54 -
Libreoffice Calc – Advanced Filter with Regular Expressions
Type Video Recording Director Sean Johnson Abstract In this tutorial, I show you how to use regular expressions with the LibreOffice Calc (spreadsheet) advanced filter to query spreadsheet data. Date 2021 Language English URL https://www.youtube.com/watch?v=bpaOm3FaY2k&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=15 Running Time 16:37 -
LibreOffice Calc – Advancing Letters
Type Video Recording Director OS College Abstract This video demonstrates how to advance letters in a column in LibreOffice Calc. For example, if the letter “A” is in cell A1 and you drag to cell A2 the letter would in it would still be “A”. This video shows how to make it a “B” and the value in cell A3 a “C”. Date 2021 Language English URL https://www.youtube.com/watch?v=6-cfAwyWS5c&list=PLK_xio5V3iePoXxxAXmRViVu9ZygWCfUW&index=3 Running Time 4:03 -
LibreOffice Calc – Array Formulas and Functions
Type Video Recording Director Panopia Tutorials Abstract Array formulas and functions: Make multiple calculations on data and get multiple results. SUMPRODUCT, FREQUENCY and TRANSPOSE are explored. Date 2015 Language English URL https://www.youtube.com/watch?v=52CmulH7xzU&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=21 Running Time 11:45 -
LibreOffice Calc – Array Formulas and Functions
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to use Libre Office Calc Array Formulas and Functions. Date 2018 Language English URL https://www.youtube.com/watch?v=66dz_nomJoA&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=14 Running Time 25:11 -
LibreOffice Calc – Background Image
Type Video Recording Director OS College Abstract The video demonstrates how to make an image inserted in LibreOffice Calc a background image to a worksheet. Date 2020 Language English URL https://www.youtube.com/watch?v=kW9rex7G484&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=29 Running Time 2:37 -
LibreOffice Calc – Bar Chart
Type Video Recording Director DCP Web Designers Abstract How to create bar charts in Libre Office 7 Calc – In this video tutorial, I will show you How to create bar charts in Libre Office 7 Calc using a few simple steps. Date 2020 Language English URL https://www.youtube.com/watch?v=hGqD3oe69T0&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=3 Running Time 6:38 -
LibreOffice Calc – Basic Formulas
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to use basic formulas in Libre Office Calc 6. Date 2018 Language English URL https://www.youtube.com/watch?v=9VSdwWRrx8k&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=19 Running Time 18:11 -
LibreOffice Calc – Calculate Averages
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to Calculate Averages using Libre Office Calc Spreadsheet. Date 2018 Language English URL https://www.youtube.com/watch?v=M4rcWxDGEvU&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=17 Running Time 10:24 -
LibreOffice Calc – Cell Border and Shadow
Type Video Recording Director OS College Abstract The video demonstrates adding a border and a shadow to a cell in LibreOffice Calc. Date 2021 Language English URL https://www.youtube.com/watch?v=jJO-ToGu7PE&list=PLK_xio5V3ieMTZd8QHdEI7ujhXvX-sOfi&index=29 Running Time 3:42 -
LibreOffice Calc – Cell Borders
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to add borders to spreadsheet cells using Libre Office Calc 6. Date 2018 Language English URL https://www.youtube.com/watch?v=CFHqFFz1rqM&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=16 Running Time 8:53 -
LibreOffice Calc – Changing Color of a Sheet Tab
Type Video Recording Director OS College Abstract This video demonstrates how to change the color of sheet tabs in a LibreOffice Calc workbook. The video was shot in CentOS 7 for Saturday Special. Date 2020 Language English URL https://www.youtube.com/watch?v=fcjgRM94jQU&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=19 Running Time 1:50 -
LibreOffice Calc – Charts
Type Video Recording Director Panopia Tutorials Abstract How to create and edit charts in Calc. Date 2015 Language English URL https://www.youtube.com/watch?v=AR-aS5Tdo5I&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=7 Running Time 13:30 -
LibreOffice Calc – Clear Direct Formatting
Type Video Recording Director OS College Abstract This video demonstrates clearing boldface and other styles applied to text in multiple cells in a LibreOffice spreadsheet with the click of one button. Date 2021 Language English URL https://www.youtube.com/watch?v=gezdRrQ0XDQ&list=PLK_xio5V3ieMTZd8QHdEI7ujhXvX-sOfi&index=32 Running Time 2:51 -
LibreOffice Calc – Cloning a Cell
Type Video Recording Director OS College Abstract This video demonstrates cloning the style of a cell and the text in it in a LibreOffice Calc spreadsheet. The cloned properties can be applied to other cells in the spreadsheet. Date 2021 Language English URL https://www.youtube.com/watch?v=t4tlNRzIS1o&list=PLK_xio5V3ieO4v6NqMvLXAkWhUXEJ9kts&index=23 Running Time 3:06 -
LibreOffice Calc – Conditional Formatting
Type Video Recording Director Eric Adams Abstract In this installment of the LibreOffice Calc series, the author takes us through conditional formatting. This lets you apply formatting styles based on certain criteria (conditions) to more easily view your data. Date 2019 Language English URL https://www.youtube.com/watch?v=S_SmRqgIrH8&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=7 Running Time 37:17 -
LibreOffice Calc – Conditional Formatting
Type Video Recording Director Panopia Tutorials Abstract Conditional formatting formats cells according to certain conditions. Color Scale, Data Bar and Icon Sets are demonstrated. Date 2015 Language English URL https://www.youtube.com/watch?v=hUaIpG4zHKQ&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=6 Running Time 10:58 -
LibreOffice Calc – Conditional Formatting
Type Video Recording Director DCP Web Designers Abstract Libre Office contains some useful features and in this tutorial will look at conditional formatting. Conditional formatting simply allows you to change the content or style of a spreadsheet cell based on specific conditions you create. There are various types of conditional formatting which can be used and the type used depends on the content of your spreadsheet cells. Date 2017 Language English URL https://www.youtube.com/watch?v=3mXrNLv_SrI&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=25 Running Time 20:11 -
LibreOffice Calc – Copying a Sheet
Type Video Recording Director OS College Abstract This video demonstrates copying a spreadsheet in a LibreOffice Calc document and placing it in a new Calc document using the Move/Copy dialog. Date 2021 Language English URL https://www.youtube.com/watch?v=qc5vCGtW7WI&list=PLK_xio5V3ieMTZd8QHdEI7ujhXvX-sOfi&index=40 Running Time 1:51 -
LibreOffice Calc – Custom Date Formats
Type Video Recording Director Panopia Tutorials Abstract How to create your own date and time format in Calc. Date 2015 Language English URL https://www.youtube.com/watch?v=swnhgXxxP5w&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=26 Running Time 12:31 -
LibreOffice Calc – Custom Number Formatting
Type Video Recording Director Panopia Tutorials Abstract Create custom number formats. Include text or color in the format. How to format cells for foreign currency. Date 2015 Language English URL https://www.youtube.com/watch?v=QzmAq-x2KM0&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=25 Running Time 13:16 -
LibreOffice Calc – Database Functions
Type Video Recording Director Eric Adams Abstract In this installment of the LibreOffice Calc series, the author takes us through using database functions. Not to be confused with the database capabilities of LibreOffice, this is specific to using a table to set the criteria for a function rather than specifying it within a formula directly. Date 2020 Language English URL https://www.youtube.com/watch?v=GOpLa4wV3jI&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=4 Running Time 15:30 -
LibreOffice Calc – Database Functions
Type Video Recording Director Panopia Tutorials Abstract Learn to use Calc’s DSUM, DCOUNT, and DAVERAGE functions. Date 2015 Language English URL https://www.youtube.com/watch?v=gkzWi8Sn4Nw&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=14 Running Time 6:59 -
LibreOffice Calc – Dates and Time
Type Video Recording Director Panopia Tutorials Abstract How to use Date and Time functions. Finding the number of days between two dates, finding the last date of any month. Make a time clock, or calculate the elapsed time between 2 events. Date 2015 Language English URL https://www.youtube.com/watch?v=Y30U-tYe00w&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=15 Running Time 6:54 -
LibreOffice Calc – Define Name
Type Video Recording Director Panopia Tutorials Abstract When you have a range of cells or a formula you use often, you can assign a name to it and use the name in place of the range or formula. Date 2015 Language English URL https://www.youtube.com/watch?v=zrA90TW_3fQ&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=18 Running Time 4:12 -
LibreOffice Calc – Deleting Contents in Multiple Cells
Type Video Recording Director OS College Abstract This video demonstrates how to delete the contents of multiple cells in LibreOffice Calc at the same time through the right-click menu. Date 2020 Language English URL https://www.youtube.com/watch?v=HK7VijptGaM&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=8 Running Time 1:31 -
LibreOffice Calc – Elapsed DateTime
Type Video Recording Director Panopia Tutorials Abstract How to get an elapsed time between 2 dates which can be days or years apart. Date 2015 Language English URL https://www.youtube.com/watch?v=7VclEi9OFcY&list=PLmTUlH8rhtEPC1bN8BjgUFrCB7lk6k7KF&index=4 Running Time 6:44 -
LibreOffice Calc – Filtering
Type Video Recording Director Eric Adams Abstract The author explains what filtering is and how to use it within LibreOffice’s Calc spreadsheet application. We cover Autofilter, standard and advanced filtering. Date 2019 Language English URL https://www.youtube.com/watch?v=B7DbmNYu0mY&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=9 Running Time 23:50 -
LibreOffice Calc – Filters
Type Video Recording Director Panopia Tutorials Abstract How to use Calc’s autoFilter and standard filter. Date 2015 Language English URL https://www.youtube.com/watch?v=aVUFTQ-Ux7k&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=9 Running Time 7:19 -
LibreOffice Calc – Financial Functions Part 1
Type Video Recording Director Panopia Tutorials Abstract An introduction to Calc’s financial functions. How to figure out how much payments will be on a loan with a constant interest rate. The PMT and CUMIPMT functions are demonstrated. Date 2015 Language English URL https://www.youtube.com/watch?v=zSfGlYoDEcE&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=5 Running Time 8:08 -
LibreOffice Calc – Financial Functions Part 2
Type Video Recording Director Panopia Tutorials Abstract More financial functions. The rate function used to find the periodic rate and the Nper function used to attain the length of a loan are demonstrated. Balloon payments, a home loan with points and the length of time to pay off a credit card are used in the examples. Date 2015 Language English URL https://www.youtube.com/watch?v=mvTJlQVSlu8&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=2 Running Time 9:16 -
LibreOffice Calc – Financial Functions Part 3
Type Video Recording Director Panopia Tutorials Abstract The FV function is used to see how much a fixed interest savings account will yield in so many years. Calc’s Goal Seek feature is demonstrated. Creating a versatile table for payments. Date 2015 Language English URL https://www.youtube.com/watch?v=3lrEJT04Zmc&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=24 Running Time 12:16 -
LibreOffice Calc – Formatting
Type Video Recording Director Panopia Tutorials Abstract Making your spreadsheets look great. Formatting cells and numbers, naming the sheet and using the fill handle. Date 2015 Language English URL https://www.youtube.com/watch?v=_r4E4iKIxEw&list=PLmTUlH8rhtEO1RjNJGHhTLKE9wFpS9qvl&index=4 Running Time 5:24 -
LIbreOffice Calc – Functions
Type Video Recording Director Panopia Tutorials Abstract Introduction to some of the basic functions like sum, max, min, average and count. Date 2015 Language English URL https://www.youtube.com/watch?v=r7kDMgHdOk4&list=PLmTUlH8rhtEO1RjNJGHhTLKE9wFpS9qvl&index=5 Running Time 2:32 -
LibreOffice Calc – Gantt Chart Part 1
Type Video Recording Director Panopia Tutorials Abstract Create a Gantt chart with Calc. In this Calc project I’ll introduce the WORKDAY.INTL function and begin building a Gantt chart for projects. Date 2015 Language English URL https://www.youtube.com/watch?v=FdYwHdWvLZQ&list=PLmTUlH8rhtEPC1bN8BjgUFrCB7lk6k7KF&index=2 Running Time 11:42 -
LibreOffice Calc – Gantt Chart Part 2
Type Video Recording Director Panopia Tutorials Abstract In part 2 the actual chart is created using conditional formatting. The NETWORKDAYS.INTL function is introduced. Date 2015 Language English URL https://www.youtube.com/watch?v=f7N0v2vGSXc&list=PLmTUlH8rhtEPC1bN8BjgUFrCB7lk6k7KF&index=3 Running Time 11:35 -
LibreOffice Calc – How to Format Cells
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to format cells in Libre Office Calc 6. Date 2018 Language English URL https://www.youtube.com/watch?v=HyOq3qxX7Gs&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=18 Running Time 12:17 -
LibreOffice Calc – IF Statements
Type Video Recording Director Eric Adams Abstract We take another look at LibreOffice Calc, specifically the IF statements, which include COUNTIF, AVERAGEIF and SUMIF as well as the IF statements of the same type Date 2020 Language English URL https://www.youtube.com/watch?v=TXtAWH8y4WY&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=6 Running Time 35:05 -
LibreOffice Calc – IFNA Function
Type Video Recording Director Panopia Tutorials Abstract When a lookup function returns an NA error, the IFNA function can prevent the error message and display a custom message or execute a function. With IFNA you can lookup a value which is located in multiple tables. Date 2015 Language English URL https://www.youtube.com/watch?v=MMSknnleD-U&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=20 Running Time 9:21 -
LibreOffice Calc – Index and Match
Type Video Recording Director Panopia Tutorials Abstract Index and Match used together are powerful functions that can find any item in a table no matter what column or row it’s in. Date 2015 Language English URL https://www.youtube.com/watch?v=8zydk03ILXs&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=19 Running Time 9:10 -
LibreOffice Calc – Inserting a Chart
Type Video Recording Director OS College Abstract The video demonstrates how to quickly insert a chart into a LibreOffice Calc spreadsheet from a selected data range. Date 2021 Language English URL https://www.youtube.com/watch?v=RHp3pqa1CqU&list=PLK_xio5V3ieMMnI2DLKCcTA8Srm7NJ0dV&index=51 Running Time 5:31 -
LibreOffice Calc – Interface
Type Video Recording Director Panopia Tutorials Abstract Getting familiar with the LibreOffice interface. Menus, splitting windows, changing the size of columns and rows and naming sheets. Date 2015 Language English URL https://www.youtube.com/watch?v=svqP_u3e5KU&list=PLmTUlH8rhtEO1RjNJGHhTLKE9wFpS9qvl&index=2 Running Time 5:03 -
LibreOffice Calc – Introduction to Formulas
Type Video Recording Director Panopia Tutorials Abstract An introduction to spreadsheets for the beginner. How to enter formulas into cells Date 2015 Language English URL https://www.youtube.com/watch?v=YBvzXW6Tzz0&list=PLmTUlH8rhtEO1RjNJGHhTLKE9wFpS9qvl&index=3 Running Time 5:28 -
LibreOffice Calc – Introduction to Pivot Tables
Type Video Recording Director Eric Adams Abstract In this installment of the LibreOffice Calc series, we take a look at pivot tables. A pivot table is an easy way to group and summarize a larger set of data. The best example I can think of for using a pivot table is creating reports. Date 2020 Language English URL https://www.youtube.com/watch?v=kDWUEXBhmFc&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=2 Running Time 1:10:41 -
LibreOffice Calc – Inverse Cosine (ACOS) Formula
Type Video Recording Director OS College Abstract The video demonstrates the formula used to calculate the inverse of a cosine (ACOS) in LibreOffice Calc. This particular formula also works in Microsoft Excel for Windows, Mac, and Online, as well as Google Sheets. Date 2020 Language English URL https://www.youtube.com/watch?v=EwqKPA5513c&list=PLK_xio5V3iePoXxxAXmRViVu9ZygWCfUW&index=2 Running Time 2:03 -
LibreOffice Calc – Large and Small Functions
Type Video Recording Director Panopia Tutorials Abstract How to use the Large and Small functions. Using the Rows and Columns functions to get incremental numbers into formulas. Date 2015 Language English URL https://www.youtube.com/watch?v=3cjVoZWrKU8&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=13 Running Time 6:08 -
LibreOffice Calc – Logical Functions
Type Video Recording Director Panopia Tutorials Abstract Calc’s Logical functions AND, OR, IF and NOT are explained with demonstrations of each. Date 2015 Language English URL https://www.youtube.com/watch?v=ONR39qXplRw&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=22 Running Time 13:19 -
LibreOffice Calc – Menus, Toolbars & Sidebar
Type Video Recording Director LO Step by Step Abstract In this video you will learn the main window in LibreOffice Calc. You will learn the terms used for different parts of the window in order to use them later. Date 2020 Language English URL https://www.youtube.com/watch?v=VnUoJHOEW8c&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=4 Running Time 6:34 -
LibreOffice Calc – Monthly Totals
Type Video Recording Director Panopia Tutorials Abstract How to get monthly totals from a table of daily amounts. Getting a month number from a month name. Date 2016 Language English URL https://www.youtube.com/watch?v=uEp928h22n0&list=PLmTUlH8rhtEN4CuyIzcGdWJbhW0X1QwRC&index=2&t=21s Running Time 9:37 -
LibreOffice Calc – More IF Statements
Type Video Recording Director Eric Adams Abstract This video gives several more examples of how to use IF statements in LibreOffice Calc. We also discuss the concept of IF and also how it is used in a few programming languages and bash scripts. Date 2020 Language English URL https://www.youtube.com/watch?v=Suo3WK6EFF8&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=3 Running Time 29:04 -
LibreOffice Calc – Natural Sorting in a Column
Type Video Recording Director OS College Abstract This video demonstrates the difference between a column that is sorted without natural sorting and one with identical data that is sorted with natural sorting. It is part of OS-College’s LibreOffice tip of the day. Date 2020 Language English URL https://www.youtube.com/watch?v=LWaPnjfVgP4&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=2 Running Time 2:04 -
Libreoffice Calc – Pie Chart
Type Video Recording Director DCP Web Designers Abstract How to create pie charts in Libre Office 7 Calc – In this video tutorial, I will show you How to create pie charts in Libre Office 7 Calc using a few simple steps. Date 2020 Language English URL https://www.youtube.com/watch?v=79RBq9zcSGk&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=4 Running Time 6:45 -
LibreOffice Calc – Pivot Table
Type Video Recording Director DCP Web Designers Abstract In this video tutorial, I will show you how to create pivot tables in Libre Office. Date 2017 Language English URL https://www.youtube.com/watch?v=0uQfxGNWvic&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=24 Running Time 21:31 -
LibreOffice Calc – Pivot Tables
Type Video Recording Director Panopia Tutorials Abstract Pivot tables allow you to rearrange, filter and sort data without using formulas. Date 2015 Language English URL https://www.youtube.com/watch?v=YeR8Ka_-nQs&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=8 Running Time 7:01 -
LibreOffice Calc – Random Numbers & Fill Series
Type Video Recording Director Panopia Tutorials Abstract Learn how to use the Random Number Generator. Use the Fill Series to populate a range of cells with a pattern of numbers or dates. Date 2015 Language English URL https://www.youtube.com/watch?v=vE_j4DI43Zk&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=4 Running Time 9:05 -
LibreOffice Calc – Rounding
Type Video Recording Director Panopia Tutorials Abstract Calc’s rounding functions demonstrated and why you should always round when multiplying numbers with percentages. Date 2015 Language English URL https://www.youtube.com/watch?v=2ijl9DSdlRs&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=27 Running Time 11:00 -
LibreOffice Calc – Sidebar
Type Video Recording Director OS College Abstract This video gives an overview of the sidebar in LibreOffice Calc. Date 2018 Language English URL https://www.youtube.com/watch?v=AXWb9x_djRg&list=PLK_xio5V3iePkvbL6Uw8tUexYQDPCoP79&index=3 Running Time 4:44 -
LibreOffice Calc – Sort
Type Video Recording Director Panopia Tutorials Abstract Sorting is easy in Calc using buttons or the sort dialog. Date 2015 Language English URL https://www.youtube.com/watch?v=p2hkq_JIRiE&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=10 Running Time 3:25 -
LibreOffice Calc – Sorting
Type Video Recording Director Eric Adams Abstract In this installment of the LibreOffice Calc series, the author explains what sorting is and how to use it. We cover basic sorting options as well as some more in-depth capabilities. Date 2019 Language English URL https://www.youtube.com/watch?v=JIOBWW61nuQ&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=8 Running Time 15:53 -
LibreOffice Calc – Sorting, Filters, Conditional Formatting and Charts
Type Video Recording Director Eric Adams Abstract The author takes some time to explain how to best use the capabilities of LibreOffice’s Calc spreadsheet application. We covered sorting, filters, conditional formatting, and charts. We will cover more on charts, pivot tables and database functions in a future stream. Date 2019 Language English URL https://www.youtube.com/watch?v=PiEclII1540&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=10 Running Time 38:56 -
LibreOffice Calc – Split Window
Type Video Recording Director OS College Abstract This video demonstrates how to create a split window in LibreOffice Calc, so you can view data in the spreadsheet side-by-side that are not in the spreadsheet in close proximity. Date 2021 Language English URL https://www.youtube.com/watch?v=IlJHQoC8eNQ&list=PLK_xio5V3ieMTZd8QHdEI7ujhXvX-sOfi&index=26 Running Time 2:07 -
LibreOffice Calc – Spreadsheet Beginners Tutorial
Type Video Recording Director DCP Web Designers Abstract This is a free LibreOffice Calc Beginners Tutorial. In this tutorial, we will cover the fundamental of using LibreOffice Calc Spreadsheet. Date 2020 Language English URL https://www.youtube.com/watch?v=bgO40-CjYNY&list=PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ&index=5 Running Time 1:26:08 -
LibreOffice Calc – Subtotals
Type Video Recording Director Panopia Tutorials Abstract Use Calc’s Subtotal feature to group data and get subtotals without using formulas. Date 2015 Language English URL https://www.youtube.com/watch?v=bJJbynoqA5A&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=11 Running Time 4:20 -
LibreOffice Calc – Sumifs, Countifs, Averageifs
Type Video Recording Director Panopia Tutorials Abstract Getting the sum, count or average according to certain criteria. Date 2015 Language English URL https://www.youtube.com/watch?v=61XHDh_4h84&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=17 Running Time 6:28 -
LibreOffice Calc – SUMPRODUCT
Type Video Recording Director Eric Adams Abstract This video takes us through using the LibreOffice Calc SUMPRODUCT array function which multiplies corresponding elements in the given arrays, and returns the sum of those products Date 2020 Language English URL https://www.youtube.com/watch?v=0UUruWtxPp0&list=PLuQidjXcLYEWyTlohYBIoeOlqkmPPVutK&index=5 Running Time 11:05 -
LibreOffice Calc – Text Box Overview
Type Video Recording Director OS College Abstract The video demonstrates how to create a text box in LibreOffice Calc and change styles for the text and the box. Date 2021 Language English URL https://www.youtube.com/watch?v=wATmC7tG9sU&list=PLK_xio5V3ieO4v6NqMvLXAkWhUXEJ9kts&index=6 Running Time 3:37 -
LibreOffice Calc – Text Functions
Type Video Recording Director Panopia Tutorials Abstract Joining text to functions and cell references in formulas and Using the TEXT function to format numbers. Date 2015 Language English URL https://www.youtube.com/watch?v=Pazq0uHmvPI&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=23 Running Time 7:34 -
LibreOffice Calc – Undoing Sending an Image to Background
Type Video Recording Director OS College Abstract This video demonstrates reversing sending an image to the background in a Calc spreadsheet. The tutorial also applies to the undo function in general. Date 2020 Language English URL https://www.youtube.com/watch?v=FoLrzMOUH4s&list=PLK_xio5V3ieO4v6NqMvLXAkWhUXEJ9kts&index=3 Running Time 4:12 -
LibreOffice Calc – Vlookup & Drop-Down Lists
Type Video Recording Director Panopia Tutorials Abstract Lookup a value in one column then find another value in a column to the right. or use Hlookup to do the same thing with rows. Learn how to create a drop-down list for a cell to eliminate input errors. Date 2015 Language English URL https://www.youtube.com/watch?v=-VYxfTiODlo&list=PLmTUlH8rhtEOaSRxo_oCE0nAa3qxHe67Z&index=12 Running Time 8:19 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (01) – A first Look
Type Video Recording Director The Frugal Computer Guy Abstract This video also describes the title bar, menu bar, what is a cell, what is the active cell, and how to move around the screen. Date 2011 Language English URL https://www.youtube.com/watch?v=HdOLxR_NlrQ&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=2&t=52s Running Time 4:03 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (02) – Fictitious Company
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial calculates the profits for a fictitious company using free software program Libre Office, which is almost identical to Open Office and similar to Excel. Date 2011 Language English URL https://www.youtube.com/watch?v=Q6XEV69PyVE&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=3 Running Time 5:42 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (03) – Formatting the Fictitous Company
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will format the data typed in the previous tutorial to make it a little easier to view. Date 2011 Language English URL https://www.youtube.com/watch?v=8eYhQ29Sunw&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=4 Running Time 3:44 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (04) – Saving your Spreadsheets
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show a few ways to save your spreadsheets. Date 2011 Language English URL https://www.youtube.com/watch?v=7QbF6TEGdIk&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=5 Running Time 3:12 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (05) – Printing your spreadsheets
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show some tips for printing out your spreadsheets. Date 2011 Language English URL https://www.youtube.com/watch?v=obUuWTdC0sk&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=6 Running Time 4:17 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (06) – Lemonade Stand Arithmetic
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how arithmatic works in your spreadsheets. Date 2011 Language English URL https://www.youtube.com/watch?v=ped-0_16FW8&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=7 Running Time 6:41 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (07) – Fill Handle Anchoring
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show a fill handle example and and anchoring example for your spreadsheets. Date 2011 Language English URL https://www.youtube.com/watch?v=n_FSKbIIWbs&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=8 Running Time 4:39 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (08) – Define Cells by Names
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how to define a name for a cell for your spreadsheets. Date 2011 Language English URL https://www.youtube.com/watch?v=AADXtH36cc8&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=9 Running Time 2:18 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (09) – 2 Rows of Text in 1 Cell – Formatting
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how put multiple lines of text in one cell and other formatting. Date 2011 Language English URL https://www.youtube.com/watch?v=zl5EFJLPdxk&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=9 Running Time 6:01 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (10) – Format phone number – Sort button
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how to format for a U.S. Phone Number and zip code. Date 2011 Language English URL https://www.youtube.com/watch?v=ry8lCzAbw4A&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=11 Running Time 4:43 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (11) – MultiColumn Sort / Random Order
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how to sort multiple using columns and how to sort in a random order. Date 2011 Language English URL https://www.youtube.com/watch?v=VV84OXP5Apk&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=12 Running Time 3:07 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (12) – Freeze, Filter, and Split
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how how to use Freeze, Filter, and Split. Date 2011 Language English URL https://www.youtube.com/watch?v=NHsJYDuyGXE&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=13 Running Time 4:16 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (13) – Forms
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show page break view, how to turn on and off tool bars, and List Forms. Date 2011 Language English URL https://www.youtube.com/watch?v=E1G1IGFO7OA&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=14 Running Time 3:24 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (14) – Drop Down Box
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how to validate input with a drop down down list box. Date 2011 Language English URL https://www.youtube.com/watch?v=L6aEsgJKekg&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=15 Running Time 3:06 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (15) – Input Help / Validate Input
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how to display a cell input message and validate data into a cell. Date 2011 Language English URL https://www.youtube.com/watch?v=tUIgrmMA2wI&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=16 Running Time 4:46 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (16) – Dates Function
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how the date function works. Date 2011 Language English URL https://www.youtube.com/watch?v=0pcC2WB6m00&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=17 Running Time 3:33 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (17) – Add a Birthdate
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how to create some random birthdays for our contact list. Date 2011 Language English URL https://www.youtube.com/watch?v=4un2HMj2Pz4&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=18 Running Time 3:48 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (18) – Subtotals
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how subtotals work on a list of cell with numberical values (like Salaries). Date 2011 Language English URL https://www.youtube.com/watch?v=IH_BQJO091E&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=19 Running Time 3:53 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (19) – 1 Column into 2 back to 1
Type Video Recording Director The Frugal Computer Guy Abstract This video tutorial will show how concatenate 2 columns into 1 column then separate them back into 2 columns. Date 2011 Language English URL https://www.youtube.com/watch?v=NLdoDjr-qyY&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=20 Running Time 4:23 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (20) – CountIf CountBlank
Type Video Recording Director The Frugal Computer Guy Abstract See how the CountIf and CountBlank functions work! Date 2011 Language English URL https://www.youtube.com/watch?v=4RL8wr4dgs0&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=21 Running Time 5:09 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (21) – Conditional If and Or functions
Type Video Recording Director The Frugal Computer Guy Abstract See the basics of “If” “And” and “or” functions as used in a spreadsheet program. Date 2011 Language English URL https://www.youtube.com/watch?v=DjDFXMDy2J0&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=22 Running Time 4:11 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (22) – Advanced Formatting
Type Video Recording Director The Frugal Computer Guy Abstract An in depth view of the style and formatting as used by LibreOffice and OpenOffice. Date 2011 Language English URL https://www.youtube.com/watch?v=pqn3JeuDA2I&list=PL0pdzjvYW9RFFHskLsq3Rvb5NpoFi_ud2&index=23 Running Time 6:06 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (23) – Conditional Formatting
Type Video Recording Director The Frugal Computer Guy Abstract Learn how to add conditional formatting to your spreadsheets. Date 2011 Language English URL https://www.youtube.com/watch?v=_PMCHrHQTR4&list=PLB6667216F5948B34&index=24 Running Time 7:17 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (24) – Weekday
Type Video Recording Director The Frugal Computer Guy Abstract What the Weekday Function is and how to use it. Date 2011 Language English URL https://www.youtube.com/watch?v=1OJYAg4_g1E&list=PLB6667216F5948B34&index=25 Running Time 6:13 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (25) – VLookup Part 1
Type Video Recording Director The Frugal Computer Guy Abstract VLookup basics — ascending order (Mode 1) Date 2011 Language English URL https://www.youtube.com/watch?v=FhWVrw2tZHs&list=PLB6667216F5948B34&index=26 Running Time 5:35 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (26) – VLookup Part 2
Type Video Recording Director The Frugal Computer Guy Abstract Using VLookup with exact match (Mode 0) Date 2011 Language English URL https://www.youtube.com/watch?v=WAEE2Z4Wz9E&list=PLB6667216F5948B34&index=27 Running Time 4:36 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (27) – Password Protect and Read Only
Type Video Recording Director The Frugal Computer Guy Abstract How to password protect your spreadsheet file and give “Read Only” password protection to your spreadsheet files. Date 2011 Language English URL https://www.youtube.com/watch?v=LbJKQWP1p-o&list=PLB6667216F5948B34&index=28 Running Time 3:09 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (28) – Protecting a Sheet in a file
Type Video Recording Director The Frugal Computer Guy Abstract How to password protect a single sheet or tab in a spreadsheet file. Date 2011 Language English URL https://www.youtube.com/watch?v=oG2K851NXCg&list=PLB6667216F5948B34&index=29 Running Time 2:25 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (29) – Protect sheet allow calculations
Type Video Recording Director The Frugal Computer Guy Abstract How to password protect a single sheet, but allow users to update specific cells and see results to calculations. Date 2011 Language English URL https://www.youtube.com/watch?v=uErDbB9ZoQs&list=PLB6667216F5948B34&index=30 Running Time 3:42 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (30) – Use cells from another worksheet
Type Video Recording Director The Frugal Computer Guy Abstract How to view/use cell values on your worksheet with cell values from a different worksheet tab. Date 2011 Language English URL https://www.youtube.com/watch?v=_eC_8TsOuyQ&list=PLB6667216F5948B34&index=31 Running Time 2:07 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (31) – Create multiple Sheets
Type Video Recording Director The Frugal Computer Guy Abstract How to change tab colors, tab names, add/remove sheets/tabs, create multiple identical sheets at the same time. Date 2011 Language English URL https://www.youtube.com/watch?v=HvGluTYK89o&list=PLB6667216F5948B34&index=32 Running Time 5:06 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (32) – Summarize multiple Sheets
Type Video Recording Director The Frugal Computer Guy Abstract This video will add a sheet using Move/Copy and finish the summary sheet started in Video 31. Date 2011 Language English URL https://www.youtube.com/watch?v=T1L0P4ZbFaE&list=PLB6667216F5948B34&index=33 Running Time 2:57 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (33) – Add Hyperlink Index page
Type Video Recording Director The Frugal Computer Guy Abstract The video will show you how to create an index page with hyperlinks to the tabs in that file and how to move/copy a sheet to another document. Date 2011 Language English URL https://www.youtube.com/watch?v=ntuKV6qyBo4&list=PLB6667216F5948B34&index=34 Running Time 4:10 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (34) – Pie Chart
Type Video Recording Director The Frugal Computer Guy Abstract Create a simple pie chart, add title, change the colors of the slices of pie, change font in the legend. Date 2011 Language English URL https://www.youtube.com/watch?v=GjfHxXJOxBg&list=PLB6667216F5948B34&index=35 Running Time 6:41 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (35) – Charts Data Series
Type Video Recording Director The Frugal Computer Guy Abstract How to chart restaurant meals sold, by store. Explain what the data series is and how to use it and create chart on a separate sheet. Date 2011 Language English URL https://www.youtube.com/watch?v=MEUuwq7FS7k&list=PLB6667216F5948B34&index=36 Running Time 5:24 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (36) – Charts Subgroup and rept()
Type Video Recording Director The Frugal Computer Guy Abstract Create a chart with subgroups and create a bar graph without using the chart feature. Date 2011 Language English URL https://www.youtube.com/watch?v=FNWcng19DWE&list=PLB6667216F5948B34&index=37 Running Time 2:01 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (37) – DataPilot Part 1
Type Video Recording Director The Frugal Computer Guy Abstract Summarize, Subtotal, and Filter large amounts of data using DataPilot (also Known as Pivot Tables) Part 1 Date 2011 Language English URL https://www.youtube.com/watch?v=Qo0GoudZ01M&list=PLB6667216F5948B34&index=38 Running Time 4:06 -
LibreOffice Calc, OpenOffice Calc, Excel Tutorial (38) – DataPilot Part 2
Type Video Recording Director The Frugal Computer Guy Abstract Summarize, Subtotal, and Filter large amounts of data using DataPilot (also Known as Pivot Tables) Part 2 Date 2011 Language English URL https://www.youtube.com/watch?v=S4I4qkbR2WY&list=PLB6667216F5948B34&index=39 Running Time 3:33 -
Simple Replacing Exercise in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Replacing some nouns in sentences very easy in LibreOffice Calc Date 2019 Language English URL https://www.youtube.com/watch?v=gJbIHNHT9-Y&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=2 Running Time 1:57 -
Spelling, Autocorrect Options and Automatic Spell Checking in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Spelling, Autocorrect options and Automatic Spell Checking in LibreOffice Calc are useful tools in order to be sure that your documents have a correct spelling. You can change your language and of course, you can customize the autocorrect words or symbols. Date 2021 Language English URL https://www.youtube.com/watch?v=SAxo2d-xzho&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=29 Running Time 3:58 -
Spreadsheet: Calculation, Filter, Formatting, Pivot Table, Chart
Type Video Recording Director The Unicorn Abstract Showing how to do some basic calculation in spreadsheet, also showing how to sort, filter, set conditional formatting, create pivot table, create charts Date 2018 Language English URL https://www.youtube.com/watch?v=Fny5OIv7P64&list=PLpbIR2RiZZ6_zXM_acbvcV5UP6PUgR5Zz&index=3 Running Time 20:32 -
Spreadsheets Limits in LibreOffice Calc + Experimental Settings
Type Video Recording Director LO Step by Step Abstract In this video you will learn about spreadsheets limits: rows, columns, sheets. and also will find about experimental features about this limits in LibreOffice Calc. Date 2020 Language English URL https://www.youtube.com/watch?v=7PKAn3ykb8Q&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=5 Running Time 5:37 -
Text Alignment in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract In this video you will learn different options to align the text in LibreOffice. Date 2021 Language English URL https://www.youtube.com/watch?v=_r4RStzVdGM&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=43 Running Time 7:31 -
Why to Use Aggregate Function in LibreOffice Calc
Type Video Recording Director LO Step by Step Abstract Aggregate function could make your life easier in case you have data with some mistakes. Check this video to see how to use it. Date 2021 Language English URL https://www.youtube.com/watch?v=OYCHpyt0Hsk&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=32 Running Time 7:27 -
Working with Numbers: the Basics (LibreOffice Calc)
Type Video Recording Director LO Step by Step Abstract In this video we will study the difference between numbers as text and numbers. We will learn how to add automatically leading zeroes and how to insert negative numbers and format them. Date 2021 Language English URL https://www.youtube.com/watch?v=_K8WF79vu3w&list=PLzad0VvGzlSqpBFs-kqkhz2pgcaf8bT3s&index=26 Running Time 6:17