Excel
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...
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 ...
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...
Create A Popup Reminder In Excel
Popup Reminder In Excel: This useful project enables you to create a popup Reminder in Excel that Beeps, Displays your Custom Message and reads it aloud. Without any knowledge in VBA, Copy the code he...
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...