#excel trick

EXCEL Trick – How to Divide the total amount in different- different random entries in excel

Divide a number into random parts excel, how to distribute a number proportionally in excel divide a number into n parts in excel how to divide all cells by a number in excel split a number into random parts. Download Project File for Practice (.xlsx) Download Excel File Download more Excel Project File

Advanced Excel Tricks: Vlookup & Hlookup

VLOOKUP/ VERTICAL LOOKUP

In lay man terms, a function in advanced Excel used when there is surplus of data and you need to find a specific record from that datasheet in a topmost column.

 Syntax:- =Vlookup(lookup_value, table_array, col_index_num,[range_lookup])

Let us understand Vlookup through an example which involves easy steps. As we are not available with huge datasheet, so I have taken a…