Dynamic Arrays

The SCAN Function – How To Use It?

How to use the SCAN Function? Table of Contents Introduction 1 Arguments of the SCAN Function: 2 Let’ see some examples: 2 Example 1: Concatenating characters 2 Example 2: Running Total 5 Example 3: F...

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

Retirement planning in Excel

Retirement Planning in Excel (Easy and Effective method)

Retirement Planning in Excel using Functions, Dynamic Arrays, and Power Query To get the best out of Excel, you need to combine the different functionalities together in achieving your goal. In this p...

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.