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 t...
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 recor...
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 th...
An Intense Tutorial on Building Surveys and Quizzes
Building A Quiz, Survey or Questionnaire … Step by Step Building Quizzes, Surveys and Questionnaires...
Impressive Chart with Chart Title Drop List
Download the eBook Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a d...
Prepare for a Successful Excel Job Interview
Excel Job Interview With over 15 years of experience in corporate training, I find that many clients...
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, c...
A Funny Excel Prank…
I learned this prank from Liam Bastick – Excel MVP (Sumproduct company)…. Hope no one ...
From Data to Dynamic Dashboard … All In One Dashboard with Form Controls
Complete Course on Dashboards Creation with form controls ...
Find and Replace… Amazing Functionality You Did Not Know
Mind Blowing Functionality of the “Find and Replace” Command This blog article maps to m...