Skip to content

Opening book details…

Can I read Excel Functions for Data Matching & Ranking on EtoBox?

Excel Functions for Data Matching & Ranking by Balaji S is a document available to read on EtoBox.

What is Excel Functions for Data Matching & Ranking about?

Business analysts often need to perform matching and ranking tasks on collected data using Excel functions. Some common matching tasks include finding customer information based on an ID number or finding cumulative returns. Common ranking tasks include finding the highest or lowest performing items. This document explains how to use Excel functions such as MATCH, INDEX, VLOOKUP, OFFSET, RANK, LARGE, and SMALL for both matching and ranking data to derive further insights.

Author
Balaji S
Language
EN

More by Balaji S

Browse all works by Balaji S