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

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

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

What is Power Query and why do you need to use it

What is Power Query? Why Do you need it?

Table of Contents Among the hundreds of millions of Excel users, still very few people know the importance of using Power Query. In this article, I shed light on the game-changer tool Power Query. Get...

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 assignments for each student in a separate folder. Here is how I am going to do it in 3 steps: Step One ...

  • 1
  • 2
  • 9

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.