Quick Productive Tips in Excel
Excel Tips and Tricks

Quick Productive Tips in Microsoft Excel

In this article, you will learn the quick tips in Excel to improve the productivity in Microsoft Excel.

Tip #1: Auto Serial Number:

We can Sequence function in Excel to generate the automatic serial number in a data

In the below image, we have used Sequence function on Column A-

=SEQUENCE(COUNTA(B:B)-1)

 

Auto Serial Number
Auto Serial Number

 

Tip #2: Dynamic Serial Number:

Dynamic serial number means, serial number should not be changed when we will filter the data. We can use Subtotal function to get the dynamic serial number.

In the below image, we have used Subtotal function on Column A-

 

=SUBTOTAL(3,$B$2:B2)

 

Dynamic Serial Number
Dynamic Serial Number

 

If we put the filter in the data, serial number will be adjusted automatically. For example, in the below image, we have put the filter on Sales column to filter the Sales greater than two thousand. If you see the Serial number on column A, it is in proper sequence.

 

Dynamic Serial Number with Subtotal Function
Dynamic Serial Number with Subtotal Function

 

Tip #3: Quick Filter:

We can use the quick filter using exactly right click on any cell >> Filter >> filter by cell value

 

Quick Filter
Quick Filter

 

Tip #4: Flash Fill:

To get the first name or last name from the full name, you can use the Flash Fill. You need to enter a sample name then press Ctrl+E.

Click to learn more about Flash fill

Flash Fill
Flash Fill

 

Tip #5: Column Sort:

To sort the sequence of the columns, you can go to the Data Tab >> Sort>> Options >> Select left to right orientation.

Column Sort
Column Sort

 

Watch the step-by-step video tutorial:

Click here to download the practice file

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com