VBA

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

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

Create a Dependent Drop List With No Source Data

Geography Data Types and Data Validation Office 365 We learned in previous examples different ways t...

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

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

An Intense Tutorial on Building Surveys and Quizzes

Building A Quiz, Survey or Questionnaire … Step by Step Building Quizzes, Surveys and Questionnaires...

Find and Replace… Amazing Functionality You Did Not Know

Mind Blowing Functionality of the “Find and Replace” Command This blog article maps to m...

Impressive Chart with Chart Title Drop List

Download the eBook   Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a d...

Prepare for a Successful Excel Job Interview

Excel Job Interview With over 15 years of experience in corporate training, I find that many clients...

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

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link