Excel/VBA Right Function 
Insert Image in Excel sheet by openpyxl 
How to freeze Excel Columns/Rows by openpyxl freeze_panes 
Get Last / Append New Excel Column by openpyxl max_column 
Excel / VBA PasteSpecial Method: Explained with 3 Examples 
The INDEX function in Excel
The Excel INDEX function requires the position and range and returns the value based on that position. If you do not know the position, you may get this by using MATCH function.
Excel Dropdown List
In this tutorial, I will show you how to make dropdown list in Excel with examples. Not only will I show you ways of how to create dropdown but how to use its values in different formulas as well.
The MROUND function for rounding nearest to 5, 10, 100, 1000 etc.
For getting the nearest multiple for any number like 5, 10, 100 etc. you may use the MROUND function in Excel. The MROUND function takes two arguments: MROUND(number, multiple)
Excel Subtract Date Formulas
There is a number of ways for calculating the difference between two dates in Excel. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates.
The functions to replace text in Excel
The Excel REPLACE and SUBSTITUTE functions can be used for replacing new text string by existing text in the given text. See the examples, syntax, and difference between these two functions by this tutorial.
How to round numbers in Excel?
The Excel has a number of functions that enable rounding the decimal numbers as per the need. These functions are: ROUND
ROUNDUP, ROUNDDOWN and MROUND
HLOOKUP Function in Excel
The Horizontal lookup function, HLOOKUP in excel is used to find the specific value in a row for the table that is arranged horizontally.
4 Ways of How to Calculate Age in Excel (Years, Months and Days)
Formulas to Calculate Age in Excel In Excel, you may calculate the age in a…
The DATEDIF Function in Excel
The Excel DATEDIF function takes the start date, end date, unit and calculates the difference in terms of days, months or years between these two dates. The unit specifies what you require; days, month, or years.
What are Excel FIND and SEARCH functions?
The FIND is case sensitive to return the position. The ‘C’ and ‘c’ has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the ‘*’ and ‘?’ wildcards in the FIND function.
How to Identify/Remove Duplicate Data in Excel sheet
In this tutorial, I will show you step by step of how to find the duplicate data in rows/columns. This is followed by steps for deleting the duplicate data.
MATCH Function in Excel
The Excel MACTH function returns the relative position of the specified item from the given range of cells. This is how the MATCH function can be used:
Using Excel AND function with IF
The Excel simple IF function enables us to test a condition and returns True or…
What is the purpose of IFERROR function?
The IFERROR function enables us to trap and handle the errors that occur in functions or use it independently. You may display descriptive messages e.g. “0 is not allowed” etc.
IF function in Excel
The IF statement is generally taken as a decision making statement. In Excel, the IF is a function that enables us doing that.