Excel

My New Book Is Now on Amazon

I recently published a new book on Amazon: Data Validation… a back door to Master Excel Here is the promo video for the book. I am also including in this article the Intro pages and the Table of Conte...

What Should I use: Excel or Google Sheets?

Comparing Excel, Excel Online, and Microsoft 365 Microsoft Excel is a member of the Office Suite of applications. Being the most popular spreadsheet software, it is used by over 750 million persons ac...

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

The Greatest Excel Event … Is Now At your Finger Tip

The Greatest Excel Event From 21st. to the 23rd. of July Non-Stop Learning by 50 Microsoft MVPs (Most Valuable Professionals) donating their time for charity – all profits will be donated to a global ...

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

Numbering Records Dynamically in Excel… 18 Different Work Situations

Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. Adding serial numbers manually is a pain. Moreover, they will be static and will not renumber auto...