Blog

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

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

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

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

From Data to Dynamic Dashboard … All In One Dashboard with Form Controls

Complete Course on Dashboards Creation with form controls               Having a large number of records about countries and information split in 2 lists I cannot ge...

Comparison Chart For Dashboards

You can download the Exercise File and Follow along by clicking here below:

Randomize Items in Drop Lists …With Every Use

Is it a New List? Randomizing Drop List with every use Randomizing items in a drop list means every time you use the drop list the contents are the same but appear in a different order. This functiona...

SUBSCRIBE TO OUR EMAILING LIST AND RECEIVE FREE BOOK

Receive my Amazing Textbook “Pivot Tables From Zero To Hero” Totally FREE when you subscribe below to our emailing list.
SUBSCRIBE NOW
close-link