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
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
The Scrolling List- Start File
Filter Non Adjacent Columns in a List or Table – Start File
Dynamic Calendar For Any Month or Year
Secrets of Lists and Tables
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
Impress Your Audience with Scenario Manager – Start File