Excel Tutorial

How To Insert One Column, Multiple Columns, Adjacent Columns, Non-Adjacent Columns In Excel

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

How To Insert One Column, Multiple Columns, Adjacent Columns, Non-Adjacent Columns In Excel Read More »

The Ultimate Guide to Adding a Blank Option Using Data Validation in Excel

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

The Ultimate Guide to Adding a Blank Option Using Data Validation in Excel Read More »

How To Import Filtered Excel Rows From One Excel File To Another Dynamically

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

How To Import Filtered Excel Rows From One Excel File To Another Dynamically Read More »

How To Filter Excel Rows By Multiple Customized Condition

Microsoft Excel provides a filter function for you to find out required rows by the customized condition in a very long excel worksheet. The filter feature includes a basic filter that provides simple condition filtering and an advanced filter that provides complex condition filtering. This article will show you both the 2 filter features with

How To Filter Excel Rows By Multiple Customized Condition Read More »