VLOOKUP stands for Vertical Lookup. As the name specifies, VLOOKUP is a built-in Excel function that helps you look for a specified value by searching for it vertically across the sheet. VLOOKUP in Excel may sound complicated, but you will find out that it is a very easy and useful tool once you try it. Look at […]
If MS Excel formula is not working, There may be two types of issues that can be Formula error; 1. When Who sheet is not working When All the formulas in whole sheet are not working/calculating/updating, it might be only one reason, activate automatic option; Click to learn 2. When A Specific Formula is not […]
Here is very critical issue that you may found while working on excel; MS excel formula is not calculating/update result automatically. There may be two types of this issue; A specific formula is not working but others are working fine. Learn how to fix it All the formulas in whole sheet are not working/calculating/updating. First […]
Duplicate values happen when the same value or set of values appear in your data. Remove Duplicate Values 1. Remove duplicate values with the Remove Duplicates command This example teaches you how to remove duplicates in Excel. 1. Click any single cell inside the data set. 2. On the Data tab, in the Data Tools group, click Remove […]
XLOOKUP() Horizontal & Vertical lookup functions by dw faisalabad Introduction xlookup and vlookup Limitations xlookup and vlookup comparison table xlookup Syntax Major Differences 13 XLOOKUP Examples More Emaples xlookup vs vlookup vs index/match Pros & Cons of XLOOKUP Summary Conclussion Introduction XLOOKUP has defeated Vlookup by introducing eight new features that has increased the working […]
Several Windows users are reporting that they are unable to use the arrow keys to move between the cells in Microsoft Excel. This seems to be recurring issues that happen on a lot of different Office versions including on Excel 2010, Excel 2013 and Excel 2016 What is causing the arrow keys to stop working […]
In this article we will discuss about how to Add Space Between Characters Or Every Digit In Excel, we will learn this step by step with VBA Codes. Supposing you have a list of text strings or numbers, for adding space between characters or every digits, what can you do? The following methods can help you […]
Microsoft has introduced a new function in MS Excel – X LOOKUP; A very new and unique function which will replace V LOOKUP. Take a look at Practical Training on X LOOKUP Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an […]
How to automatically transfer Save data from one sheet to another in excel Easily Record & Save data and transfer it to another sheet Learn how to auto save/record data entries in excel 2007 2010 2013 2016 without any formulas just using macro in excel transfer data from one excel worksheet to another automatically Record […]
Excel has many functions to offer when it comes to manipulating text strings. The following is the list regarding to the arrangement of text. Alignment Function Find Vs Search Remove Unwanted Characters Text To Columns Number Of Instances Concatenate Strings Compare Text Lower/Upper Case Number Of Words Separate Strings Substitute Vs Replace
Learn how to share Excel data with Word documents and other files. Paste Most of the time, you’ll simply need to paste static Excel data in a Word document. 1. Select the Excel data. 2. Right click, and then click Copy (or press CTRL + c). 3. Open a Word document. 4. Press CTRL + […]
When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you’ll be able to create a new workbook, choose a template, and access your recently edited workbooks. From the Excel Start Screen, locate and select Blank workbook to access the Excel interface. Understanding User Interface The Ribbon PowerPoint uses a tabbed Ribbon system instead of traditional menus. The […]
A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations. A range is a group or block of cells in a worksheet that has been selected or highlighted. When cells have been selected they are surrounded by an outline or border as shown in the image […]
Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes. The Userform we are going to create looks as follows: The user selects Animals from a drop-down list. As a result, the user can select an animal from a second drop-down list. The user selects Sports […]
Add the Controls | Show the Userform | Assign the Macros | Test the Userform This chapter teaches you how to create an Excel VBA Userform. The Userform we are going to create looks as follows: Add the Controls To add the controls to the Userform, execute the following steps. 1. Open the Visual Basic […]
Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc. To create an ActiveX control in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. For example, in the ActiveX Controls group, click Command Button to insert a command button control. 3. Drag a command […]
WorksheetFunction | ScreenUpdating | DisplayAlerts | Calculation The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options. WorksheetFunction You can use the WorksheetFunction property in Excel VBA to access Excel functions. 1. For example, place a command button on […]
Function | Sub The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become very useful as program size increases. Function If you want Excel VBA to perform a task that returns a result, you can use a function. […]
One-dimensional Array | Two-dimensional Array An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number. One-dimensional Array To create a one-dimensional array, execute the following steps. Place a command button on your worksheet and add […]
Workbook Open Event | Worksheet Change Event Events are actions performed by users which trigger Excel VBA to execute code. Workbook Open Event Code added to the Workbook Open Event will be executed by Excel VBA when you open the workbook. 1. Open the Visual Basic Editor. 2. Double click on This Workbook in the […]
