Excel

VSTACK or PYTHON for Combining Tables

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...

The Golden Shortcut of Excel

The ONLY Shortcut that opens 20 Different Dialog Boxes. Are You An Excel Enthusiast Looking To Maxim...

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...

Multiple Folders From Excel Data

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...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.