Excel

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

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

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 Patients records or any other work situation. Having a unique identifier for each record is very impo...

Translate Text or Functions in Excel

Three Methods To Translate Text or Functions in Excel

If you ever wondered how to translate excel spreadsheets into another language.  This blog will give you a clear guidance on how to do exactly that.  Translation is more than just changing words from ...

How to write notes inside a function in excel

Write NOTES Inside a Function in Excel – Simple steps

One of the most common questions in my youtube channel is “How to Write NOTES inside a Function in Excel” Sometimes I build complex functions with multiple levels of nesting. To make it ea...

Quality Analysis Report in Power BI

In this tutorial we are going to create a dynamic dashboard that analyses a production business where we have our data scattered in multiple files. With many products, employees and locations, the aud...

Dynamic Report With Power Query and VLOOKUP – Approximate Match

When you want to create a dynamic report from multiple sources and you need an approximate match, If the VLOOKUP Cannot get the job done, Then Power Query will come for rescue. In this tutorial I crea...

Excel Data Validation Webinar- FREE Master Class

Are you ready to rock and keep improving your Excel Skills? You are Invited to join a FREE Master Class delivered online (Watch the Recording Here Below) Speaker: Nabil Mourad (Excel MVP) Topic: Depen...

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.