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
Posted on Utopian.io - Rewarding Open Source Contributors