Functions

In this blog, we would understand one of the highly used date functions in Excel which is – NETWORKDAYS function in excel. This tutorial would… Read Article

In this tutorial, we would learn how to extract or get the second value from the time in Excel using the SECOND function in Excel.… Read Article

In this blog, we would unlock one of the excel time function called the Excel MINUTE formula. This tutorial would cover the purpose and objective… Read Article

In this tutorial, we would unlock the HOUR function in excel, its purpose and objective, syntax, and arguments. We would also take some simple examples… Read Article

In this blog, we would unlock one of the most-used excel functions viz. DAY formula in Excel. We would cover the following – purpose and… Read Article

In this tutorial, we would unlock one of the rarely used date functions in Excel viz. DATEVALUE. Here, we would cover the purpose & objective… Read Article

LAMBDA function is a new feature in Excel that allows you to create your own reusable function or formula in excel without programming coding knowledge.… Read Article

The ‘Power Query’, popularly known a ‘Get & Transform’, is an excellent tool pre-installed by Microsoft in its higher versions of excel (Excel 2016 and… Read Article

The Excel Power Query feature, popularly known as ‘Get & Transform’, is a life-saver tool used to extract and transform data from various sources into… Read Article

Excel Power Query feature is an amazing tool provided by Microsoft in Excel to get the data from various sources and transform it according to… Read Article

The Excel Power Query tool is like a lifesaver tool when you want to extract some of the data from external files and folders or… Read Article