October 7, 2021

Excel Table & it’s Properties

What is an Excel table? An Excel Table is not just any range of data with headings, but a specific Excel object that unlocks additional properties. […]
September 30, 2021

Excel’s 5 Useful but rarely used Functions

April 27, 2021

Find & Replace with Wildcards

April 19, 2021

Filter Data using Wildcards

April 19, 2021

HOW TO DELETE ALTERNATE ROW

If we want to delete alternate rows from a data set, then the following steps can be performed to make our task easier instead of deleting […]
April 19, 2021

Repeat Function

November 28, 2019

Wildcards

November 19, 2019

5 Things to avoid in MS Excel

While MS Excel can be a great tool to automate your work, save loads of time and make your work flexible, there are certain things that […]
November 5, 2019

Tired of using SUMIFS? TRY DSUM

When trying to sum values with conditions, SUMIFS has always been our go-to function. However, when there are too many conditions, going on adding criteria, selecting […]