No Image

VLookup and HLookup

April 21, 2017 SKB 0

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 […]

No Image

Macros in Excel

June 22, 2016 SKB 2

Excel Macros A macro can be defined as the recording of a series of tasks. It’s the simplest form of automation – show a software […]

No Image

Pivot Table using Excel

June 22, 2016 SKB 0

Pivot table is used to sort, count or give the average of the data stored in a spreadsheet, Pivot tables are also useful for converting […]

No Image

Clear Excel Sheet using VBA

June 22, 2016 SKB 0

To clear the entered data in the current sheet of MS-Excel application follow the below simple steps. 1. Click on ” Developer” tab in MS-Excel […]

No Image

Data validation in Excel

June 22, 2016 SKB 0

Data Validation with MS – Excel Data validation is an important for entering specific values in the column with size or length. Here are the […]