Public

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.

 

 

 



Download The Expiry Date File

 




 

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

officeinstructor

Subscribe to our Newsletter

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below