Helping nerds automate mundane tasks and learn new skills along the way

Audio transcription/captions Like a Pro with Python Whisper AI!
5:10
Audio transcription/captions Like a Pro with Python Whisper AI!
Power Automate: Weekly Cash Flow Forecasts (Full project)
31:24
Power Automate: Weekly Cash Flow Forecasts (Full project)
Automate Your boring Tasks with Python Prefect in 10 minutes!
10:31
Automate Your boring Tasks with Python Prefect in 10 minutes!
Extract multi page PDF data to Excel with python PDF Plumber library!
11:53
Extract multi page PDF data to Excel with python PDF Plumber library!
Part2-Combine and Extract multiple PDF tables to clean Excel Data using Tabula library of python
24:40
Part2-Combine and Extract multiple PDF tables to clean Excel Data using Tabula library of python
Big Excel Files? Load Them 10X Faster with Python Parquet!
5:09
Big Excel Files? Load Them 10X Faster with Python Parquet!
Automate Excel xlookup Like a PRO with python xlwings!
13:17
Automate Excel xlookup Like a PRO with python xlwings!
VBA - Run a macro when a file opens or closes!
5:26
VBA - Run a macro when a file opens or closes!
Power Automate: Send employee birthday emails using google sheet
24:31
Power Automate: Send employee birthday emails using google sheet
Simplify PDF Management: Extract First Page with pyPDF2 in Python
8:35
Simplify PDF Management: Extract First Page with pyPDF2 in Python
VBA - Expand autofilter range in one click macro!
6:03
VBA - Expand autofilter range in one click macro!
Merge multiple dataframes (2 or more) using python pandas and reduce function
6:17
Merge multiple dataframes (2 or more) using python pandas and reduce function
Where's Your Money spent? Track and Categorize Expenses with Python!
4:17
Where's Your Money spent? Track and Categorize Expenses with Python!
Fix Excel Dates with This Simple Trick using DATE function
5:54
Fix Excel Dates with This Simple Trick using DATE function
Convert Email Data to Excel Table in MINUTES with This Hack!
4:29
Convert Email Data to Excel Table in MINUTES with This Hack!
Transform Excel Data into Outlook Emails with Python in One Click!
14:49
Transform Excel Data into Outlook Emails with Python in One Click!
Power Automate: Automatically Reply to the original email
8:25
Power Automate: Automatically Reply to the original email
PDF invoices data extraction with pdfplumber in Python
6:41
PDF invoices data extraction with pdfplumber in Python
VBA- From Data Entry to Automated Emails: Build a VBA UserForm for Invoice Data Entry
37:22
VBA- From Data Entry to Automated Emails: Build a VBA UserForm for Invoice Data Entry
VBA - Concatenate selected/visible values by custom delimiter & copy to clipboard
8:31
VBA - Concatenate selected/visible values by custom delimiter & copy to clipboard
VBA - Fix date formats using split and arrays
6:17
VBA - Fix date formats using split and arrays
Power Automate: Download email attachment to onedrive, create new folder, update Excel File
13:13
Power Automate: Download email attachment to onedrive, create new folder, update Excel File
VBA - Open multiple PDF files from visible/filtered rows in Microsoft Excel directly
7:39
VBA - Open multiple PDF files from visible/filtered rows in Microsoft Excel directly
Microsoft Power toys: Screenshot to Text / Batch Image Resize / Batch File Rename etc
7:28
Microsoft Power toys: Screenshot to Text / Batch Image Resize / Batch File Rename etc
OCR/Extract text from a screeshot and export to text file using Pytesseract & Python
4:04
OCR/Extract text from a screeshot and export to text file using Pytesseract & Python
Forget Excel, Try Python Xlwings -- Part 3: File Formatting Deep Dive
15:18
Forget Excel, Try Python Xlwings -- Part 3: File Formatting Deep Dive
VBA-Open Folder Location of an active Excel File
3:55
VBA-Open Folder Location of an active Excel File
Forget Excel, Try Python Pandas -- Part 2: Pivot Tables Basic + Advanced!
12:23
Forget Excel, Try Python Pandas -- Part 2: Pivot Tables Basic + Advanced!
Forget Excel, Try Python Pandas -- Part 1: Basic Data Manipulations!
7:20
Forget Excel, Try Python Pandas -- Part 1: Basic Data Manipulations!
Microsoft Power Query - Filter and remove specific rows dynamically - 2 Methods
5:48
Microsoft Power Query - Filter and remove specific rows dynamically - 2 Methods