Excel Tutorial

In this article, I will tell you how to add or subtract years, months, days to an excel Date value, it will also tell you how to add or subtract hours, minutes, seconds to an excel time value with examples.

In this article, I will tell you how to add commas between words in Excel , how to add comma between first and last name in Excel, and how to add comma after first word in each cell.

In your existing excel worksheet, you might occasionally want to add a new column after each subsequent column. This can be implemented using VBA and I will tell you how to do it in this article.

In this article, I’ll go over the following techniques and scenarios about how to add new columns to Excel. I will tell you how to use ribbon options or keyboard shortcut to add one new column, how to add a number of adjacent new columns at one time, how to add inadjacent columns all at

Data Validation in Excel is a powerful tool that helps to ensure accurate data entry in Excel. It is an important part of any spreadsheet management system and is used to validate data entered into a spreadsheet before it is saved, ensuring that only valid data is saved. In this article, we’ll discuss what Data

After inserting a new row in the excel table, how to automatically update the row number of the existing row which have to move down? This article will tell you how to implement it.

Pivot Table is the best tool for the comprehensive analysis of detailed data. It organically combines the advantages of classification and consolidation. It can easily and flexibly adjust the basis of classification and summary and display the characteristics of data in many different ways.

If you want to extract the file names of the files contained in a certain folder, put them in the worksheet for other uses, it is very troublesome to input them one by one or copy and paste them. In fact, we can use the two excel functions FILE and INDEX together to extract the file name in

This article will tell you how to import filtered excel rows from one excel file into a new excel workbook. And when the source excel rows data is changed, the data in new excel workbook will also be changed dynamically by refresh the connection. There are two method to achieve this, i will introduce them

This article will show you how to import data into excel workbook from local files, the local file format can be excel, csv, text, xml, html and pdf. It also show you how to export an excel workbook to those format files.