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...
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...
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...
Excel Dice Rolling Game
Roll the Dice… Using Functions and Macro Dice rollers are needed for lots of games … If you want to have one always at hand then nothing can match the Excel dice roller which allows you to...
Blinking Conditional Formatting in Excel
Conditional Formatting is widely used in Excel and it enables us to change Font characteristics and Cell Fill color when a condition is met. In this tutorial I show you how I apply a Blinking Conditio...
