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