Tutorial uses match formulas, index formulas, and combines vlookup formulas in Calc Apache OpenOffice
Tutorial : Tutorial uses match formulas, index formulas, and combines vlookup formulas in Calc Apache OpenOffice
Video : Indonesian 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
What Will I Learn?
In the video I gave an explanation how to create formulas math in OpenOffice, and the tools I describe below.
- How to use Match formula
- How to use Index formula
- How to combine the Vlookup and match formulas
- How to combine the Vlookup and index formula
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
Read more - Wikipedia
My Operating System
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, Here I explain by using the formula MATCH, INDEX, and Combine the Vlookup with match formulas, and Vlookup with index formulas. The tools we'll be using are listed above, in the What We Can Learn!
Video Tutorial
Curriculum
If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :
- Apache OpenOffice - Tutorial creates tables with basic formulas (Spreadsheet)
- Apache OpenOffice - Tutorial creates tables with VLOOKUP, HLOOKUP, and SUM formulas (Spreadsheet)
- Apache OpenOffice - Tutorial creates Table & Form in Database
- Apache OpenOffice - Tutorial creates Presentation slide
- Apache OpenOffice - Tutorial creates tables with IF AND & IF OR formulas
- Apache OpenOffice - Tutorial creates tables with IF LEFT, IF MID & IF RIGHT formulas
- Apache OpenOffice - Tutorial creates Report on Database
- Apache OpenOffice - Tutorial to use and Differences on formulas Min/Max & Large/Small, as well as how easy to use them with name box
- Apache OpenOffice - Tutorial create a math formula in OpenOffice
Posted on Utopian.io - Rewarding Open Source Contributors
@darsondrew, Like your contribution, upvote.
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Hey @darsondrew I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x