Microsoft Excel is most powerful software application for office use. And it’s strength lies in the use of advanced formulas for calculating any sort of given data. Here we have listed some of the most common and advanced formulas for MIS. Have a look! Excel Formulas Text Output Formula Description i am […]
Most common Excel formulas for MIS Read More »
Excel has built-in functions called VLookup [Verticals Lookup] and HLookup [Horizontal Lookup] These two functions are now most widely used formula for finding absolute and reference values from sheet. VLOOKUP is a Vertical Lookup for searching values from first column. VLookUp : Please create following excel sheet with data in it and write
VLookup and HLookup Read More »
This example shows a simple marks calculation using MS-Excel. Here are the steps for calculating total, average, minimum and maximum marks. 1. First of all, create a sheet with following data in it. 2. Place cursor next to “Total Marks” column and type the formula [while writing a formula in excel it is mandatory to
Simple Marks Calculation using Excel Read More »
The following example explains the calculation of Employee salary using MS Excel with simple understanding steps. Step 1 : Create a sheet with following data in it. Step 2: To calculate Bonus, click on “Insert Function” Step 3: select “if” from the list Step 4: Enter the formula as per following screen image [Here Cell
Calculate Employee salary using MS Excel Read More »
