Excel

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 has built-in functions called VLookup [Verticals Lookup] and HLookup [Horizontal Lookup] These two functions are now most widely used

Excel Macros A macro can be defined as the recording of a series of tasks. It’s the simplest form of

This tutorial teaches you how to create an excel forms with Macros with step-by-step approaches. Step1 : Open MS Excel

Pivot table is used to sort, count or give the average of the data stored in a spreadsheet, Pivot tables

To clear the entered data in the current sheet of MS-Excel application follow the below simple steps. 1. Click on

Data Validation with MS – Excel Data validation is an important for entering specific values in the column with size

This example shows a simple marks calculation using MS-Excel. Here are the steps for calculating total, average, minimum and maximum

The following example explains the calculation of Employee salary using MS Excel with simple understanding steps. Step 1 : Create