1 тысяч подписчиков
271 видео
How to Switch Beta Channel to Current Channel and Vice Versa Excel (2 Easy Ways)
Handling Similar Validation Using WithEvents Keyword in VBA
Password Validation Using REGEXTEST | Helpful Website to learn REGEX
Excel VBA : Create Custom Events In OOP
Read more than 255 Columns From Closed Workbook Without Opening: ADODB Part 2
Looping In Immediate Window: VBA Tricks You may need to know
Read Data From Closed Excel File Without Opening: Part1
Introduction to Dictionary in VBA : Dictionary use case (Part 2)
10. Delete All Sheets Except Active Sheet Using Office Scripts (Be careful before running the code)
2. Read Named Range Info Using Office Scripts
8. Remove All
Distinct Items From A Range Using Office Scripts (Not Unique ones)
Get Matching Rows Using Office Scripts
Property Data Directly in Excel from ATTOM API
Extract Search Results from Website to Excel: One click solution
Excel VBA : Install AutoHotkey and Use Case for VBA
Add a Calculated Column In A Table Using Office Script
Checkbox Adding by using VBA
Trust access to the VBA project object model In Mac Excel
AUTOHOTKEY : Run and Stop AUTOHOTKEY
3. Dynamically Collect All Named Range Details Using Office Scripts
Extract Text from Scanned PDFs using OCR | Full Tesseract Tutorial
7. Real Application of Named getType method in Office Scripts
1. Create Named Range Using Office Scripts
Compatible Folder Picker Both For Windows and Mac
9. Basic of Worksheet Automation in Office Scripts
Sort Table By Custom List Power Query: Multiple Practical examples included.
Replacer.ReplaceText Vs Replacer.ReplaceValue M Function : Explanation on List.ReplaceValue
Enum In VBA: Learn to use them correctly.
AUTOHOTKEY : HotString & Their Usage
Last non blank row and column number using VBA
No Grid Lines? Extract Multi-Page PDF Invoices Easily (Python + PDFPlumber/PyMuPDF)
Local Recursive Lambda Without Saving In the Name Manager
Highlight Active Row or Column of any sheet Dynamically using VBA
Extract Borderless Tables from PDFs with Python (Real-World Examples + Techniques)
Transform Flat Table to Long Table with Full Code and Explanation for Beginner in Excel Power Query
Text Data Type Power Query
Web Scraping Made EASY With Html.Table M function: Complete Guidelines.
How To Repair a Corrupted Excel file Which Crash Excel on Opening File
New Context Menu For XLSM File
Accessing Controls(TextBox) Using For Loop in Userform
Table ExpandColumn in Power Query
Best Python Libraries to Extract Tables from PDFs Easily
Extract PDF Tables to Excel with Python | Split by Header into Multiple Sheets
Clockify REST API with VBA | GET & POST Requests Explained
How to Extract Table Data From Arabic Language PDF | Right-to-Left Text Handling
5. Delete Named Range Using Office Scripts
Vstack N Times and Repeat Each Row N Times Using LAMBDA
Speed Up Python API Calls 60x Faster | Bulk API Optimization Tutorial
Step-by-Step PDF Links, Emails & Data Extraction with Python PyMuPDF – 2025 Guide
