Excel’s new XLOOKUP function is now generally available. Learn How to Apply XLOOKUP function?

Here comes the Xlookup function. Now say goodbye to the Vlookup function. The most popular function of Excel is called Vlookup Function. A few months ago Microsoft launched a new function Xlookup Function.Now it has been added in the update to Office 365. In this article, let’s learn how to Apply XLOOKUP Function and what … Read more

Excel VBA Tutorial 5 – Text Box Properties, Text Box Currency Format and Date Format

Text Box Properties  In Excel VBA tutorial 4 we learned how to add different tools to the user form. In today’s tutorials, we will learn about the properties of text boxes. We will learn about different formats of text boxes. About User Form Properties In Tutorial 3, we saw some important points. In the same … Read more

Excel VBA Tutorial 2 – Enable developer tab in excel | Excel Macro, VBA tutorial for beginners |

Developer tab in excel- Excel VBA, Macro tutorial for beginners to make excel vba programming Tutorial 2 Like any software in Excel, if we want to manage data through user form, then we have to learn VBA. Read the article written in Tutorial 1 on what is Excel VBA and Macro. The first step to create … Read more