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

Source : Image

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

• Apache Openoffice - Tutorial Creating query on database using App Apache Openoffice

• Apache OpenOffice - Tutorial create table using formula SUM IF, SUM IFS, & SUM PRODUCT using app Apache Openoffice

• Apache OpenOffice - How to create calculating future finance using FV, PMT , and PV formulas using app Apache Openoffice

• Apache OpenOffice - How to Calculating Depreciation with various methods

• Apache OpenOffice - How to calculate financial finance using openoffice calc