XL Xplorer is something similar to File Explorer in windows. The Treeview option in XL explorer displays the list of every open workbook and associated worksheets in a PC. This list includes the hidden worksheets too.
The most important feature of XL Xplorer is that it helps you to navigate through all those open workbooks and worksheets.
Use of Named Ranges in Excel will make the formulas easy to read, understand and maintain. This is just another Great Time Saver in Excel something similar to Custom Views.
Topics discussed are :
1. Creating a Named Range using Name Box
2. Creating a Names using Name Manager
3. Creating Names from Selection
4. Use in Formula option of Defined Names
5. Uses of Names & Named Ranges
6. Some Cool features of Names & Named Ranges
For receiving notification about video releases, Subscribe to the channel and press the Bell Icon. https://bit.ly/2qvP29e
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
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
