Data Validation

Intelligent Drop Lists and Evolution of Data Validation

New Intelligent Drop List in Excel Table of Contents Introduction 3 The Work Situation 3 The Old Method 4 Creating The Drop List 7 The Recent Method 10 The UNIQUE function 10 Create the Drop List 12 T...

Switching Charts with A Drop list

  Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a data preparation table 3 Creating a drop list for the different months 3 Creating row labels for the 2 preparation table...

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

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

Create a Dependent Drop List With No Source Data

Geography Data Types and Data Validation Office 365 We learned in previous examples different ways to create a dependent Data Validation list. Whatever the technique used, the source data used for the...

Transform data using Power query

From Data To Analysis with Power Query and CUBEVALUE Function

In this project: We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the...

data validation

Simple ways to excel Data Validation… Let’s Push it to the Limit and Beyond

The Magic of Data Validation Introduction Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell. It also makes data entry ...

Preparing for Excel job

Prepare for a Successful Excel Job Interview

Excel Job Interview With over 15 years of experience in corporate training, I find that many clients are overestimating their knowledge in Excel. That’s why when you apply for a job requiring go...

Power query and Data validation

2 Effective Tools Power Query and Data Validation are Much Stronger Together

  In this tutorial  I am bringing multiple files from a Folder, I combine the Files together, clean and transform the data and create calculations in Power Query to return a nice report to Excel....

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.