Power Query

Generate Codes Dynamically with a Pattern from Your Data

Sometimes you need to create a unique code for a list of Products, Sales transactions, Students or Patients records or any other work situation. Having a unique identifier for each record is very impo...

How to write notes inside a function in excel

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

power query

4 Easy Ways to Combine Files with Power Query

With the help of Power Query, you can work with multiple files and sheets and be able to combine the data efficiently. When working in Excel, you might be organizing your data in different files, and ...

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.