Blog

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

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