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 
Excel/VBA Right Function
The Right function returns specified numbers of characters from the right of the string.
It takes two arguments – both are required:
Insert Image in Excel sheet by openpyxl
By using openpyxl.drawing.image module, you may insert images to the Excel sheet using Python programs.
How to freeze Excel Columns/Rows by openpyxl freeze_panes
In Excel, freezing columns or rows while scrolling through data can be very useful, especially for sheets with large data.
Get Last / Append New Excel Column by openpyxl max_column
By using max_column, you may get the last column in the Excel sheet. In this tutorial, we will show you in a Python program to get the last column number in a sheet.
Excel / VBA PasteSpecial Method: Explained with 3 Examples
PasteSpecial function in VBA Normally, as you copy/paste a cell or range of cells in…
How to get Excel Sheet last row by openpyxl
In this tutorial, we will show ways to get the last row number by using Python openpyxl library.
Excel / VBA IIf Function: Explained with 3 Examples
The IIf function (capital II and small f) can be taken as a simple form of If..Then..Else statements.
How to Access Excel Sheets by Name in Openpyxl
In this tutorial, we will look at how to get a sheet by name and then perform some operations like adding a row, coloring data, setting interior/background color to that sheet – rather than active sheet.
3 Ways to Get Excel Sheets List using Pandas/openpyxl
In this tutorial, we will show you getting the list of Sheets in an Excel Workbook by using Pandas.
VBA CountA method
CountA function returns counts of cells that are not empty (in range or array).
Alternatively, CountA returns the count of cell in range or array with data.
Add/Remove Index Column by Pandas read_excel index_col parameter
The read_excel method has a parameter index_col which default value is: index_col=None
Other values supported are int, list of int.
2 Examples to use VBA CDate function
The CDate function converts an expression to date type.
Excel / VBA Autofill Method
AutoFill is a pretty useful method in VBA that can be used to auto fill the cells in the specified range.
How to Comment Single Line/Block in Excel / VBA
In VBA, you may add single line comments or block (multiple line comments) by using:
Single quote for single comment
Using the menu option for block of comments
Excel/VBA Weekday Function
The Weekday function returns the number of day of the Week for the given date.