Showing all 20 articles in this category.
Shouldn't Have Combined these two topics into One: In this blog a Formula actually means the Worksheet Functions, that we use in excel sheets directly that begi...
Built-in Excel Worksheet Functions This Is What We Do When Excel Does Not Have A Formula That We Need Desperately. There are plenty of Excel Worksheet Functions...
How to Change Excel Date Format? Excel date format related function are grouped in Menu-> Formula -> Date & Time Option. Using this, we can get today's date & t...
Excel Import Data From Another Workbook - VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import dat...
Macro for Vlookup Tutorial A Vlookup function search for ‘value’ in the first column of ‘table Range’ & returns a value from the same row. Syntax: =Vlookup (‘va...
Making of #N/A Error & Solve it If You are an Frequent MS Excel User, then you should have seen those Unexpected return codes from Formula that start with Hash(...
Random Numbers in Excel Formula, VBA & SpreadSheets Is it any Guessing Game? Yes. If you can predict the next number these functions can generate then, Microsof...
Excel Functions Vs Array Formula In this article, we are going to search for value in a Excel table without using Vlookup function. The formula that we are goin...
How To Create Excel Data Table? A Data Table generates different scenarios for your formula. You can use it to do What-if analysis. Lets first create a Excel Ta...
How to Subtract Numbers in Excel? There is no built in function in Excel to perform subtraction. Use one of the methods explained below. In Excel, we could perf...
Engineering Unit Conversion Table In Excel If you want to convert kg to lbs, meter to feet or liter to gallon -this Engineering Unit Converter Excel app can per...
Import Data from Excel to Excel To pull data from another workbook to current active Excel, try these methods. Data Import option to query data from another wor...
How To Add Hyperlinks in Excel Using Formula? Higher version of MS Excel like 2007 or above have built in function to add links. Select a cell to insert a hyper...
Calculate Percentage in Excel Percentage can be explained as a proportion or ratio between two numbers in 100 scale. i.e., 250 out of 1000 is 25% (i.e., 250 : 1...
How to set color in alternate Rows? In Excel, alternate Rows/columns can be shaded using one of these 3 methods. Conditional Formatting Vba code to color altern...
How to get Last day of Month? Excel has many option to find this End of Month. But in this page, We have given only the direct method. In Excel this formula can...
1. How to Remove #N/A error in Excel Formula & Vlookup NA Errors? To remove #N/A error, first You should find a way to detect it within the Excel formula. Unfor...
In today's world, the data sets we have is huge and we can have so many criteria to be followed on the data For Example: Sum Average etc. Let us say we have N p...
A. Insert Numbers with Leading Zeroes in Excel To add leading zeroes in Excel to a number, use one of these methods. But before using one of these methods, you ...
How to Replace #N/A error in Excel Formula & Vlookup? In many of the Excel formula, we get #N/A as return value. Espcially we get this quite often in Vlookup fo...