In this blog, we would learn about the WEEKDAY function in excel. We would unlock the objective and purpose of the WEEKDAY function, formula syntax… Read Article
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 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 tutorial, we would unlock one of the rarely used date functions in Excel viz. DATEVALUE. Here, we would cover the purpose & objective… Read Article
In this tutorial, we would learn about the DATE function in excel. We would cover the purpose, syntax & arguments, and examples of the DATE… Read Article
While working with excel, there are many excel tasks that you cannot perform using inbuilt Excel features and functions. Or accomplishing those tasks using Excel… Read Article
Errors in excel formulas are inevitable. No matter how expert you are, some or the other day, you might have come across excel formula errors.… 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