VBA
Create A Popup Reminder In Excel
Popup Reminder In Excel: This useful project enables you to create a popup Reminder in Excel that Beeps, Displays your Custom Message and reads it aloud. Without any knowledge in VBA, Copy the code he...
Simple ways to excel Data Validation… Let’s Push it to the Limit and Beyond
The Magic of Data Validation Introduction Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell. It also makes data entry ...
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...
Find and Replace… Amazing Functionality You Did Not Know
Table of Contents Mind Blowing Functionality of the “Find and Replace” Command This blog article maps to my video on the same topic. You can Download the Exercise File and follow along by ...
2 Effective Tools Power Query and Data Validation are Much Stronger Together
In this tutorial I am bringing multiple files from a Folder, I combine the Files together, clean and transform the data and create calculations in Power Query to return a nice report to Excel....
Change cell color based on value in Excel
Conditional Formatting is widely used in Excel and it enables us to change Font characteristics and change cell color based on value when the desired conditions are met In this tutorial I show you how...
Create a Stopwatch in Excel (Tutorial + Template)
You can easily create a stopwatch in excel with the help of VBA and simple excel functionalities. In this blog, you will learn about creating a countdown timers or a stopwatch inside a excel worksheet...
- 1
- 2
Write NOTES Inside a Function in Excel – Simple steps
One of the most common questions in my youtube channel is “How to Write NOTES inside a Function in Excel” Sometimes I build complex functions with multiple levels of nesting. To make it ea...