Blog

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

Create a Stopwatch or a Countdown Timer in Excel… Step By Step

How to Create a Timer or a Countdown in Excel… Very Useful Creating a Timer/Stop watch in Excel Professionals who are used to organizing their lives in Excel at some point wish Excel could include a t...

Pivot Table and Pivot Chart in PowerPoint… Are You Serious?

Excel is a member of a big family called the Microsoft Office Suite of Applications, which includes among other members, PowerPoint and Word… Accordingly, they share a common Interface (the Ribbon and...

Recording Macros… Totally with Shortcuts

Uniquely Shortcuts… Recording Macro We all have Excel tasks that we perform repetitively. Each task may require tens of steps… Why waste your time, redoing the same steps, while you can record a macro...

Protect Your Data without any Codes… VERY Hidden is Much More Than Just Hidden

You can Download the Exercise File  by Clicking on the Button       The most valuable thing in your Excel Files is the data you create and store. sometimes, if it is viewed without auth...

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