This is a tutorial on LibreOffice Calc covering, how to automatically update charts. The tutor demonstrates how to use the Offset function and the CountA function to automatically return data for a chart. The CountA function returns the number of items displayed in a list, while the offset function returns data from a row and or a column reference. In this example the tutor explains how to return the last three dates in one list and the last three sales figures in another. As additional data is added the last three items will always be shown. LibreOffice Calc
#calc
#libreoffice
#libreoffice
If you want to support me, check this out: / itseasy
Classroom based courses can be arranged at https://www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/
Udemy Courses https://www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv