Public

Comparing 2 Lists with a SINGLE Click- Stunning Way




Unbelievable! 5 drop Lists in One Single Cell




Cross Filtering Charts in Excel Like in Power BI




Sort In Place- Sort- Sort By – Excel Sorting Complete Course

A picture containing drawing Description automatically generated

 

 




 


Dynamic Chart Tooltip on Mouse Hovering




 

Sales Performance Dashboard- Power BI




FILTERXML- One Function Multiple Tasks




Get a List of Any Weekday Between 2 Dates- Date Picker

 




Watch the Trap: From Multiple Lines in Each Cell to Separate Rows- Power Query




Combine Non-Identical Worksheets Dynamically – Power Query Function

 




 

 

Dynamic Report with Power Query and VLookup – Approximate Match

 




 

Pivot Tables Course For Beginners

 

 




 

12 Secrets for Creating Pivot Tables – Advanced Excel

 




 


Lambda and Let Functions Together for a Single Cell Report

 




 

Naming Cells and Ranges – Start File

A picture containing ball, player, holding, sitting Description automatically generated

 

 

 





The Scrolling List- Start File 

A picture containing drawing Description automatically generated

 

 

 

 




 


 

Filter Non Adjacent Columns in a List or Table – Start File

A picture containing ball, player, holding, sitting Description automatically generated

 

 

 



Dynamic Calendar For Any Month or Year

A picture containing drawing Description automatically generated

 

 

 




 

 

Secrets of Lists and Tables

A picture containing ball, player, holding, sitting Description automatically generated

 

 

 




 

Introducing The Lambda Function

 

 

 




 

Master Class – Dependent Drop List Start File.

 

 

 




 

HSTACK-VSTACK: Extract Records from Multiple Sheets Simultaneously – Single Cell Function

 

 

 





Download The Expiry Date File

 




 

 

Five Amazing Conditional Formatting Tips

A picture containing drawing Description automatically generated

 

 

 

 




 

Impress Your Audience with Scenario Manager – Start File

 

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.