Find my codes on:

Go to Repos

Find my articles on:

3 Ways to Count Weekends in a Project Duration​​

Create multiple documents using Mail Merge (with File Names picked from Excel)

Find Repeat Customers in Excel

Excel custom formats

LAMBDA: The ultimate Excel worksheet function

Using LET to make Excel formulas more readable

Count Errors in Excel using Formula, LAMBDA, VBA

Extract numbers from text

Dynamic Arrays — Excel vs Google Sheets

Start Excel using the Command Prompt

Why learning Power Query and Power Pivot is essential for all Excel users

The Guide to the (Hidden) Universe of Microsoft Excel features​​

VBA on the Web?

Convert Pivot Table results into Formulas​​​

How to finish online courses?

Append arrays in Excel using FILTERXML​​

Split data into columns using FILTERXML

Create your own icons on PowerPoint

​.

Convert Number to Words in Excel and Word

​.

Automate Excel Charts to PowerPoint in 1 Click

Handling Errors in Excel

Create letter / number sequence dynamically in Excel

Power BI (DAX) vs Tableau (LOD) vs Excel