Most common Excel formulas for MIS
Microsoft Excel is most powerful software application for office use. And it’s strength lies in the use of advanced formulas […]
Excel
Excel
Excel
VLookup and HLookup
Excel has built-in functions called VLookup [Verticals Lookup] and HLookup [Horizontal Lookup] These two functions are now most widely used
Excel
Simple Marks Calculation using Excel
This example shows a simple marks calculation using MS-Excel. Here are the steps for calculating total, average, minimum and maximum
Excel, Management
Calculate Employee salary using MS Excel
The following example explains the calculation of Employee salary using MS Excel with simple understanding steps. Step 1 : Create