Excel
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...
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...
Color Hundreds of Sheet Tabs in One Step in Different Colors
To Download the exercise File and Follow along click Here Here is the Code Sub ChangeColors() Dim WS As Worksheet Dim IndexColor As Long IndexColor = 50000 For Each WS In Workshe...
- 1
- 2
