Excel Tutorials - Page 2 of 12 - Tips, Solutions, Tricks

Excel / VBA Date Function with 7 Formatting Examples

VBA Date function returns the current date of the system. It can be used with the format function to get the date in the desired format. We will show this in examples.

3 Examples to Understand VBA If Or Operator

The Or operator in VBA is used to check multiple conditions. If any of the conditions is True, the code inside the If statement executes.

Write and Format in Excel by Pandas/openpyxl

In this tutorial, we will show you examples of creating a new Excel file by Python Pandas library.

3 Ways of Copy/Paste Value, Formatting, Formulas in VBA / Excel

The Range object in VBA has copy method that can be used to copy/paste the contents from one cell or range of cells to other cells.

Get Today Date in VBA

In VBA, you may get today’s date by: 1- Using Date() function 2- Now() function

Append Data in Excel by Pandas ExcelWriter / to_excel with 2 Examples

How to append new data into existing Excel file. The answer is using Pandas ExcelWriter object.

How to Move Excel Chart from One Sheet to Another

In certain scenarios, you may require to have data in one sheet and the chart created based on that data on its own sheet. So, in that sheet, no tabular data in Excel cells is visible.

Excel / VBA Split – Break a String with Examples

The Split function is used to break a given string. It returns an array of substrings.

How to Read Excel xlsx File and convert to CSV by Pandas

In this tutorial, we will show you how to read a .xlsx file (an Excel file) and then converting to CSV (Comma Separated Values) by using Pandas (A Python library).