Apache OpenOffice - Using Offset, Choose and Indirect on Openoffice calc

images (1).jpeg

Today i will share about my course curriculum about calculating depreciating asset using the formula offset, choose, and indirect using database on OpenOffice . this is a lesson from the lecture I learned about Openoffice

Tutorial : Apache OpenOffice
Video : English Language
Github : https://github.com/apache/openoffice

Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information

About Project

Apache OpenOffice is an open source code (open source) application suite that can be obtained for free. The package includes word processor components, spreadsheets, presentations, vector illustrations, and data warehouses (databases)

What Will I Learn?

How to use Offset formula on database
How to use Choose formula on database
How to use Indirect formula database

Requirements

System Requirements : Program Install Support: Install and Uninstall
System Requirements : No special requirements.
OS Support Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB based Linux distributions) Mac OS X (x86-64 only)

Information

Website & Download: https://www.openoffice.org/
Type : Office suite software
License : Dual-licensed under the SISSL and GNU LGPL
Operating System : Linux, OS X, Microsoft Windows, Solaris
Platform : IA-32, x86-64, PowerPC, SPARC

Difficulty

Intermediate

Description

Apache OpenOffice is the leading open source office software for word processing, spreadsheets, presentations, graphics, databases and more. It can be downloaded and used completely free for any purpose. In the video below, i describe how to using offset, choose, and indirect formula to looking data product

Offset - Returns a modified reference, given a reference, an offset, and a desired size

Choose - Returns a value from a list, given an index number.

indirect - Returns a reference, given a text string.

Video Tutorial

Curriculum

Hey @yandot, your contribution was rejected by the supervisor @buckydurddle because he found out that it did not follow the Utopian rules.

Upvote this comment to help Utopian grow its power and help other Open Source contributions like this one. Do you want to chat? Join me on Discord.

Saya sampai saat ini benaran gk ngerti utopia ini, benar2 sya ktinggalan @yandot

Utopian adalah tempat untuk kontribusi bagi proyek-proyek sumber terbuka yang ada. Untuk kontribusi apa pun, dan berbagai kategori bang

Bagikan tutorialnya dan ilmunya lah biar bisa ikut kontribusi di proyek utopian

Hubungi saya di Discord saya akan menjelaskan tentang utopian dan bagaimana cara berkontribusi nya . Karena utopian hanya untuk proyek Opensource

this is a good science for me, before i do not understand about this, apache's name is the same as the band in my city, where songs, songs are good to hear and motivate. thank for sharing:)

Thank you! I am glad if my college science helpful for other steemian! it is an apache band whose one song is "Boh hate gadoh" I know it: D

Kurikulumnya mantap kali membuat saya tambah pusing kepala bagi yang tidak mengerti seperti saya ini, dan terimakasih banyak atas bantuannya yang lalu sehingga akun saya sudah aman kembali

Terimakasih atas dukungannya . Hehe iyaa semoga lain kali harus lebih hati-hati agar akun nya tidak di hack lagi

Postingan di utopian wajib bahasa inggris ya bang @yandot?

Iyaa harus bahasa inggris dan tentang proyek opensource

Thank you @yandot for your contribution.

Some suggestions to help you create more professional videos:

There's echoey sound in your audio. Try to 'edit' the echoey sound from the audio in audacity or you can cover the windows in your room to take out that hollowy echoey sound. In this way, your audio will come out more professional and easier to listen to.
When there are mistakes done in the video, 'edit' them out so that the users can stay engaged in your presentation.
You can use arrows, box, or other teaching devices in the video to make your points to stand out more clearly.

Thank you again for your contribution.

Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.

[utopian-moderator]

Thank you for your review and approval @rosatravels . Thank you for advice i will do better in the next time

Wow mantap @yandot 😁👍