Faysal Easy Excel

The Developer tab is for those who want to develop their ideas in Excel to do their task faster. This tab allow users to create applications with Macros in VBA environment to write, modify and run Macros. This tab also allow users to record Macros, use of XML commands, ActiveX controls, use forms to design your own software in Excel Image 1: Developer tab How to show the Developer tab? In general viewing this tab is not displayed. There are main 2 ways by which you can display it on your MS Excel 2016 or MS Excel 2013. These are: From Ribbon: To activate the Developer Tab from ribbon you need to follow below steps: a) Right Click on any ribbon. b) Click on Customize the Ribbon... I mage 2: Customize the Ribbon popup menu c) Excel Options dialog box will appear. d) Select Customize Ribbon from left tab and from right most tab put a check on Developer checkbox. Image 3: Excel Options dialog box e) Then Click on OK to activate the Developer tab. From File menu: a) Click...

This Vlookup function is also known as Vertical Lookup . It is commonly used in Excel to match a lookup value from a column, and returned value from another column where lookup value matched. The match type can be define as Exactly Match or Approximate Match (Ascending Order). It works like an English L shape as I think. This function has a lot of uses. It supports Array, so that you can customize the lookup values. Vlookup Function: VLookup function is a lookup function that used in Microsoft Excel for returning a specific data from a data table by matching a cell value (Number, Date, Text, etc.). More clearly, when you need to add an information of each record of a table from source table, by matching each cell value of a specific range with source data table, then you need to use VLookup function. At present in Bangladesh , many company asks about VLookup in their Job Interview . Why? Because they feel that, if you do not have knowledge about VLookup (which is on...

It's a common problem in MS Excel. Insert menu becomes grayed out (inactive). Image 1: Insert menu not working To fixed this problem: First of all close all of your Excel file which is currently opened. Then go to this location: C:\Users\your_user_name_here\AppData\Roaming\Microsoft\Excel "your_user_name_here" is your user name which user name you are using now. There you will see: Excel15.xlb Rename it to: Excel15.old Now open your Excel file and it is done.

In general, Macro is a program written or recorded in Visual Basic programming language. In Microsoft Excel writing, editing or developing happens under Visual Basic programming language in VBA Environment. Image 1: Visual Basic for Applications What is Macro? Macro is nothing but a shortcut switch of some difficult task at once. It can be define as, a collection of commands which you can start by a single click. It is a programming language. It uses Visual Basic programming languages. To learn Macro Writing you need to learn Visual Basic programming which can help you to write your macros easily. On the other hand, if you do not have any idea about Visual Basic programming language, then you need to write your own macros with the help of Macro Recording. What is VBA? Visual Basic is a programming language built into Microsoft Excel form the Microsoft Excel 5.0 version. VB is added with Microsoft Excel for adding extra features. All macros are written under VBA Envir...

I'm glad to start writing about the most powerful and world's most popular Microsoft Excel Visual Basic for Application. Well in short, Visual Basic is a programming language of Microsoft. It is very user friendly application development programming language. As like as previous others version, Microsoft Office version included Visual Basic. In general, VB (short term of Visual Basic) is using for application development here with Microsoft Excel and some others package software of Microsoft Office 2016 like Microsoft Access, Microsoft Word etc. Microsoft Excel VBA (Visual basic for Application) has a lot of thing which make the Microsoft Excel more powerful to calculate or generate reports in seconds. Image 1: Excel VBA You know EXCEL VBA can do many interesting task in just a seconds. You can design your own input form, various dashboard, chart etc. I think EXCEL VBA is a powerful tool to do EXCEL task more faster. For example, You need to design a table with border ever...