Unique List of Records in Excel (Advanced Filter, Remove Duplicates, Pivot Table and Macros for Unique List of Records)

There are different options available in MS Excel to create a UNIQUE LIST OF RECORDS from large datasets. But all these options are designed to work with data present in different rows of a single column. If you want to extract a unique list from data present in different columns of individual rows, either you have to write a complex formula or create a macro

Different options available in Excel for creating a unique list of records are explained in this video. They are Advanced Filter, Remove Duplicates and Pivot Table. Then how to create macros for the same. This video is highly recommended to people with little programming knowledge because it tells you how easy it is to create Macros and customizing without any programming skills.

Topics discussed are :

1. Creating a Unique list of Records using Advanced Filter
2. Creating a Unique list of Records using Remove Duplicates
3. Creating a Unique list of Records using Pivot Table
4. Macro for extracting a Unique list from data present in different columns of a Single Row
5. Creating Employee Timesheet using Data from Biometric Sensor

To receive notification at the same of Video releases, 'Subscribe' to my Channel and press the 'Bell' Icon

#UniqueListOfRecords
#AdvacnedFilter
#RemoveDuplicatesInExcel

Everything about Sum Function in MS Excel (3D Sum & Shortcuts for AutoSum)

Almost every Excel user will be familiar with the use of Sum Function in MS Excel. But are we making use every possibility of this wonderful function? For example the concept of 3D Sum.

In this Session, Different methods of using the Sum Function are explained in detail. Then about the concept of 3D Sum and a few Shortcuts related to Sum function. Topics discussed are : 1. Using Individual values inside Sum Function 2. Cell References inside Sum Function 3. Range References inside Sum Function 4. 3D sum for consolidation values from a series of sheets 5. Shortcuts related to Sum Function