Writer: A word processor like Microsoft Word and WordPerfect.

The major components of this software include: Well, today there are many such alternatives available, but Apache OpenOffice is the first legitimate free contender to Microsoft Office and a worth trying option.Īpache OpenOffice – Free Open-Source Office SoftwareĪpache OpenOffice is one of the leading open-source office productivity software for word processing. Having said that, trying Microsoft Office alternatives is surely the easy way out. Then there’s one feature that most of us aren’t a fan of – The Price Tag. are loaded with features but, practically getting used to all of them would take weeks of training. Understand how to create lists of items with Data ValidationĪutomate data entry with Auto-Fill and Flash-fill.Microsoft Office apps like Word, PowerPoint, Excel, etc. Understand how to manipulate and combine INDEX/MATCH functions and VLOOKUP/MATCH functions and VLOOKUP/INDIRECT functions and HLOOKUP/MATCH functions and more combinations of functions to maximize efficiency. Master how to combine VLOOKUP and HLOOKUP functions to perform one function Learn how to map data with VLOOKUP and INDEX function Master the skill of tracing dependents and precedents of dataįlourish in the skill of nesting functions The New Excel 365/Excel 2021 Dynamic Array Functions - SORT function, FILTER function, RANDARRAY function, SEQUENCE function, UNIQUE function, XLOOKUP function, SORTBY function Learn how to work with Excel functions from scratch ( absolute beginner) to a comfortable professional This course uses Microsoft Excel 2021 as a tool to learn and master Excel functions.

You will be guided step by step on how to be an excellent formula analyst with Microsoft Excel. You are welcome to this Microsoft Excel Functions course.

Open office excel