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...
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...
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...
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...
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...
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...
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 ...
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...
We have sent your quick reference guide for creating Dashboard.
Please check your inbox to receive Your Gift.
Happy Learning !!
Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.
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...