The Document Foundation Blog

  • TDF Home
  • LibreOffice Home
  • Grant Requests
  • Tenders
  • Media Hub
  • Merchandise
  • Financials & Reports
  • Donate

LibreOffice Calc Videos

  • 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

 

  • What is LibreOffice?

    LibreOffice is a free and private office suite, compatible with Microsoft Office / 365. It is open source and has regular updates with new features and improvements.
  • Animated banner outlining how donations are used: Your donations are helping us to support hackfests around the world; Expand our infrastructure with new software services; Pay a small team working on release building design, documentation and more; Every year, organise the LibreOffice Conference; Contract a dedicated quality assurance engineer; Fund tenders for writing and improving LibreOffice code. Donate and let's make LibreOffice even better! Just click on this image. Thank you!

  • Search

  • CII Badge

    CII Badge

  • RSS TDF Planet

    • Projects selected for LibreOffice in the Google Summer of Code 2025
    • 2025-05-14 Wednesday
    • TDF and LibreOffice website, blogs and social media – Annual Report 2024
    • 2025-05-13 Tuesday
    • 2025-05-12 Monday
    • LibreOffice Quality Assurance (QA) in 2024 – TDF’s Annual Report
    • 2025-05-11 Sunday
    • 2025-05-10 Saturday
    • ODF 20th Anniversary Video
    • QA/Dev Report: April 2025

  • Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

Copyright

Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2).

Trademarks

LibreOffice and The Document Foundation are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our Trademark Policy.

Legal Information

Impressum (Legal Info)
Privacy Policy
Privacy Tools

Credits

Theme: Ribbon by MyThemeShop.

The Document Foundation Blog Copyright © 2025.
Theme by MyThemeShop. Back to Top ↑