Excel Tutorials - Tips, Solutions, Tricks

4 Examples to Learn Excel / VBA DateDiff Function

The DateDiff function in VBA is used to calculate the difference between two dates – in terms of days, years, months, quarters, hours, minutes, etc – depending on your requirements.

MS Excel Statistics – Usage by Job, Country, Industry & App Downloads

Different statistics of Microsoft Excel – 2023

Microsoft Excel is the most popular spreadsheet program available in the World.

How to Get Length of String by VBA Len function?

To get the length of a string, value in the cell, etc., you may use the Len function in VBA.

How to Close Excel Workbook using VBA Code

In this tutorial, we will show you the code for closing the Excel Workbook using VBA. For closing a workbook, you may use the Close method of the Workbook object.

How to Create New Excel Workbook using VBA

For creating a new Excel Workbook, you may use the Workbooks object’s Add method in VBA.

Create Excel Pie Charts Using Python openpyxl

In this tutorial, we will show you how to create simple and 3-D pie charts using openpyxl – a Python library to work with Excel.

Excel VLOOKUP formula in openpyxl

In this tutorial, we will show you using VLOOKUP Excel function in openpyxl – A Python library.

How to Return Excel Specified Rows by Pandas skiprows

In many situations, you only need to fetch from a specified row rather than loading the whole Excel sheet using Python Pandas.

3 Examples to Write Multiple Data Frames in Excel by Pandas/Python

In Pandas Data Frame to Excel tutorial, we learned how to write one data frame into Excel sheet. In this tutorial, we are going to show you how to write multiple data frames by executing a Python program once only.

VBA Round Vs RoundUp Vs RoundDown

If you are using Excel directly then it has a few functions to round numbers. These are:ROUND ROUNDUP ROUNDDOWN MROUND

How to Auto-Adjust Column width by Python openpyxl

Adjustment of the column’s width as per the text or headings of the column is particularly important when you copy data from one sheet to another as using Python openpyxl, Pandas etc.