Data Validation

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

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

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

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

Dependent Drop List – No Preparation Table

Creating dependent Drop List without Any Preparation Table What is a dependent drop List? It’s a drop List where the items change based upon your selection from another drop List. In our example we ha...

Live Interview with Brazilian Channel Excel Turbo

It was a pleasure meeting virtually Cristiano Galvao (Excel MVP) and so many of his fans and followers from Brazil and worldwide, on May 14th 2020 We had a lot of fun and I was happy to share my journ...

Do Magic with Excel Drop Lists …Dynamic Dependent Diminishing

In this project I show you how wow your boss, colleagues and clients by creating Dynamic Dependent Diminishing drop lists. At the Basic Level, using drop lists in your worksheet makes entering data an...

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link