interactive online courses

interactive online courses

This is the learn by doing course that will help you to gain the skills in an interactive way.

Read More

Beginner to Pro in Excel

Beginner to Pro in Excel

Helpful guides primarily delivered in the interactive course. For example, you'll learn about Sumif, Countif, Vlookup, Match, Index, and much more. That will help you to practice like a pro.

Read More

available on the appsource

available on the appsource

Products supported Excel 2016+, Excel 2016 for Mac , Excel Online

Read More

VLOOKUP, MATCH & INDEX

Install Add-ons: Formiraex You will learn about How to use the VLOOKUP, MATCH & INDEX functions. Use VLOOKUP to search and get the desired value from the range of data.example:=VLOOKUP(I3, D3:G6, 4, FALSE)* I3 is the lookup value.* D3:G6 is the Table array of data searched.* 4 is the column number of the returned data from Table array.* TRUE/FALSE is the logic.TRUE = Approximate matchFALSE