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

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.