Excel
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
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 here under and paste it int...
My New Book Is Now on Amazon
I recently published a new book on Amazon: Data Validation… a back door to Master Excel Here is the promo video for the book. I am also including in this article the Intro pages and the Table of Conte...
What Should I use: Excel or Google Sheets?
Comparing Excel, Excel Online, and Microsoft 365 Microsoft Excel is a member of the Office Suite of applications. Being the most popular spreadsheet software, it is used by over 750 million persons ac...
An Intense Tutorial on Building Surveys and Quizzes
Building A Quiz, Survey or Questionnaire … Step by Step Building Quizzes, Surveys and Questionnaires either to test knowledge on any topic or collect answers… is extremely common and useful. In a prev...
The Greatest Excel Event … Is Now At your Finger Tip
The Greatest Excel Event From 21st. to the 23rd. of July Non-Stop Learning by 50 Microsoft MVPs (Most Valuable Professionals) donating their time for charity – all profits will be donated to a global ...
