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...

Personal Macro is restricted to use with others opened Excel workbook. So, it hides by default from Macro list. Personal Macro basically creates another Excel window which is hidden. If you unhide the hidden window then you can see the Personal Macro. Before you Delete the Personal Macro, you need to unhide the Excel window first. How to unhide the Personal Macro Window? To Open the Personal Macro Window first go to the Workbook that contains the Personal Macro. Then Click on View | Unhide: Image 1: Unhide the Personal Macro Workbook Then you will see a Unhide dialog box contains the unhide workbooks list: Image 2: Unhide workbook Click on PERSONAL and then Ok. Now you will see that new Personal Workbook displayed and shown in Taskbar. I mage 3: After unhide the Personal workbook shown in Taskbar How to delete from Personal Macro? After unhiding the Personal workbook, Close all opened workbook including Personal Workbook that contains personal macro. And Exit from Microso...

Subtotal() is basically used to get instant summary of a filtered data table. It is used with the support of AutoFilter tool or can be used alone. If you use AutoFilter for Subtotal then all hidden rows become visible. But if you do not use AutoFilter then hidden rows becomes hidden. Subtotal Function: The Subtotal function structure is: =SUBTOTAL(function_number,ref1) Function Details: There are 2 main parts of this function. These are: function_number: Subtotal function can calculate many things like, SUM, COUNT, AVERAGE etc. Each of these function are stored with a number in Subtotal(). What you need to do is mention the Number first from below list: Image 1: SUBTOTAL() number chart ref1: This is nothing but a Range. You can Select a single cell or few cells selected randomly, or a range of cells. Example: Based on below data table assume that, you need to know the Salary of Mr. A in D4 cell. Image 2: Sample data table for Subtotal In D4 ce...