Excel
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 ...
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...
Impressive Chart with Chart Title Drop List
Download the eBook 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 ...
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....
A Funny Excel Prank…
I learned this prank from Liam Bastick – Excel MVP (Sumproduct company)…. Hope no one does it to me 🙂 By far and away the most popular ‘trick’ (in all senses of the word!) I demonstrate...
Find and Replace… Amazing Functionality You Did Not Know
Mind Blowing Functionality of the “Find and Replace” Command This blog article maps to my video on the same topic. You can Download the Exercise File and follow along by clicking on the li...