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 
Top, Bottom and Range of Excel Rows by Pandas [head & tail, iloc methods]
Once you have a data frame by using the read_excel method of Pandas, you may access/manipulate Excel data in Python programs.
Load One or Multiple Sheets of Excel by Pandas sheet_name
We will show you how to use read_excel method of Pandas library to load:One excel sheet, Two Excel sheets annd All excel sheets
6 Examples to Understand VBA Equal and Not Equal to Operators
Equal to and Not Equal to are comparison operators in VBA. Used to check or compare values, let us take a look with examples one by one.
Excel/VBA Mid function [4 Examples – simple/Range]
If you require a substring from a given string, use the Mid function. You may specify the number of characters to start form in the given string in the Mid function.
Perform Case-Sensitive Search by VBA Find MatchCase – 2 Examples
How to perform a case-sensitive search using VBA Find function. We have shown examples of using “What” and “After” arguments in this VBA Find tutorial.
Excel/VBA Columns Property: Explained with 6 Examples
By using Columns property, you may: Hide/unhide columns in the Excel sheet Delete specified columns Change the interior color of an entire column or in the range
VBA Trim, LTrim and RTrim for Removing spaces
VBA has a few string functions that is used to remove spaces in strings, or cells of an Excel sheet.
VBA Multi/Two-Dimensional Arrays with 4 Examples
A two-dimensional array in VBA can be created as follows: Dim arr_2D(1 To 6, 1 To 3) As String
5 Examples to Use Conditional Formatting in Excel [Highlight Cells Rules]
Conditional formatting in Excel is the way to stand out or make different certain cells/information to others. For example, making cell red for numbers less than a certain value.
How to Read Excel Files by Pandas read_excel
Reading Excel files in Pandas – A Python library Pandas is a Python library that…
VBA Rnd, RandBetween to Generate Random Numbers [1 to 10, 1 to 1000]
You may use built-in functions in VBA to generate random numbers. The first function is Rnd().
5 Examples to Set Excel Cell, Rows, Cols Font Color in VBA
In this tutorial, we will show you how to set font color in Excel sheet cells, rows, and columns by using the range object’s Font property.
VBA IsEmpty Function
What is VBA IsEmpty function? The IsEmpty function is used to check if a cell…
VBA LOOKUP function: Explained with 5 Examples
VLOOKUP function is used to find things in an Excel sheet (table or range) by row. Basically, VLOOKUP is a sheet function but you may use it in VBA as well.
Handling Excel VLOOKUP Errors (N/A & Value)
The #N/A error occurs when a given value is not found as using the Excel VLOOKUP function.