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
Macros in Excel
Excel Macros A macro can be defined as the recording of a series of tasks. It’s the simplest form of
Excel
Creating an Excel form with Macros
This tutorial teaches you how to create an excel forms with Macros with step-by-step approaches. Step1 : Â Open MS Excel
Excel
Pivot Table using Excel
Pivot table is used to sort, count or give the average of the data stored in a spreadsheet, Pivot tables
Excel
Clear Excel Sheet using VBA
To clear the entered data in the current sheet of MS-Excel application follow the below simple steps. 1. Click on
Excel
Data validation in Excel
Data Validation with MS – Excel Data validation is an important for entering specific values in the column with size
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