How to use the basic functions in LibreOffice Calc
Vložit
- čas přidán 9. 09. 2023
- The sum, average, max, min and count functions are some of the most useful and common functions in LibreOffice Calc. They allow you to perform calculations on a range of cells and get the desired result. Here is how to use them:
- To use the sum function, type =SUM(range) in a cell, where range is the group of cells you want to add together. For example, =SUM(A1:A10) will add up the values in cells A1 to A10 and display the result in the cell where you typed the formula.
- To use the average function, type =AVERAGE(range) in a cell, where range is the group of cells you want to find the average of. For example, =AVERAGE(B1:B10) will find the average of the values in cells B1 to B10 and display the result in the cell where you typed the formula.
- To use the max function, type =MAX(range) in a cell, where range is the group of cells you want to find the maximum value of. For example, =MAX(C1:C10) will find the largest value in cells C1 to C10 and display it in the cell where you typed the formula.
- To use the min function, type =MIN(range) in a cell, where range is the group of cells you want to find the minimum value of. For example, =MIN(D1:D10) will find the smallest value in cells D1 to D10 and display it in the cell where you typed the formula.
- To use the count function, type =COUNT(range) in a cell, where range is the group of cells you want to count how many have numbers in them. For example, =COUNT(E1:E10) will count how many cells in E1 to E10 have numbers in them and display the result in the cell where you typed the formula.
These functions can also be accessed from the AutoSum button on the toolbar, which has a drop-down menu with more options. You can also use more than one range in a single function by separating them with commas. For example, =SUM(A1:A10,B1:B10) will add up the values in both ranges and display the result. How to use the basic functions in LibreOffice Calc. LibreOffice Calc tutorial.
#libreoffice #calcio
If you want to support me, check this out: / itseasy
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv
Get going with Calc
Useful info thanks
Glad it was helpful!
Thanks for this update
welcome
Love this nice and easy
Thank you! 😊
Never knew about Calc thanks
you do now
Good content
thanks
Excellent
Thank you! Cheers!
love it
thanks
I hope calc will have Table features like in Excel. Thats the only feature from Excel that I want to available in calc.
would be good
I need even more basic. How did he type Mon and get the days of the week to populate across columns. "Basic" and "Beginner" mean different things to different people.
10 minutes later edit: Did a search, discovered autofill and left click. It irks me when folks want everything spoon fed. Do a search. learn on your own. I have found that knowledge sticks better when I struggle and THEN take a class.
True, I have other videos covering getting started.