Blog

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

What Should I use: Excel vs Google Sheets?

Comparing Excel, Excel Online, and Microsoft 365 Excel vs Google Sheets is a Never-ending battle. However, we will try to make things clear while choosing a Spreadsheet program for your workflow. Lets...

Create a Dependent Drop List With No Source Data

Geography Data Types and Data Validation Office 365 We learned in previous examples different ways to create a dependent Data Validation list. Whatever the technique used, the source data used for the...

Transform data using Power query

From Data To Analysis with Power Query and CUBEVALUE Function

In this project: We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the...

data validation

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

Building surveys and quizzes with 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...

Find and Replace using excel

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

Chart in Excel

Impressive Chart with Chart Title Drop List

Download the eBook   Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a data preparation table 3 Creating a drop list for the different months 3 Creating row labels for the ...

Preparing for Excel job

Prepare for a Successful Excel Job Interview

Excel Job Interview With over 15 years of experience in corporate training, I find that many clients are overestimating their knowledge in Excel. That’s why when you apply for a job requiring go...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.