Excel
VSTACK or PYTHON for Combining Tables
Table of Contents Download your Exercise file by clicking the button below Download Exercise file The Work Situation – Graphically If you have multiple tables in a single workbook where the tables hav...
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 file corresponds to a continent. There is a single sheet in each file having a list of countries in...
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’ see some examples: 2 Example 1: Concatenating characters 2 Example 2: Running Total 5 Example 3: F...
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 to know the percentage of completion of your Tasks in a visual way In this article, I show you how t...
Create Awesome Dynamic Charts with Reactions
Creating impressive charts with reaction labels can greatly enhance your data visualization. In this article I will show you how to turn dull report into an amazing Dynamic chart with emojis, that tel...
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 Method 4 Creating The Drop List 7 The Recent Method 10 The UNIQUE function 10 Create the Drop List 12 T...
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 assignments for each student in a separate folder. Here is how I am going to do it in 3 steps: Step One ...
Send Messages from Excel To WhatsApp
In this article, I will show you how to integrate the functionality of WhatsApp within Excel. You will be able to use Excel data from the worksheet to send personalized WhatsApp messages directly from...
The Golden Shortcut of Excel
The ONLY Shortcut that opens 20 Different Dialog Boxes. Are You An Excel Enthusiast Looking To Maximize Your Productivity? Among the countless Excel shortcuts, there’s ONE that stands out as the...