Excel
VSTACK or PYTHON for Combining Tables
Table of Contents Download your Exercise file by clicking the button below Download Exercise file Th...
Power Query Trick For Combining Files Without Renaming Table
Combining Files with Inconsistent Headers- No Mapping Table We have multiple files in a folder. Each...
The SCAN Function – How To Use It?
How to use the SCAN Function? Table of Contents Introduction 1 Arguments of the SCAN Function: 2 Let...
Progressive Data Bar For Your Tasks
Table of Contents If you have a list of tasks for any project, or a long To-Do list it’s good ...
Create Awesome Dynamic Charts with Reactions
Creating impressive charts with reaction labels can greatly enhance your data visualization. In this...
Intelligent Drop Lists and Evolution of Data Validation
New Intelligent Drop List in Excel Table of Contents Introduction 3 The Work Situation 3 The Old Met...
Create Multiple Folders From Excel Data In 3 Steps
Creating 50 Folders and naming them with student names is a hard task, but I must do it to save assi...
Send Messages from Excel To WhatsApp
In this article, I will show you how to integrate the functionality of WhatsApp within Excel. You wi...
Generate Codes Dynamically with a Pattern from Your Data
Sometimes you need to create a unique code for a list of Products, Sales transactions, Students or P...
The Golden Shortcut of Excel
The ONLY Shortcut that opens 20 Different Dialog Boxes. Are You An Excel Enthusiast Looking To Maxim...