Blog Posts -

📺 My latest YouTube Videos

Replace your VLOOKUP. Use THIS instead!

I Built an AI App Using Streamlit in 6 Hours

Streamlit & Google Sheets: The Easiest “Database”

Getting Started with Python in Excel

Build a SaaS with Streamlit

6 Quick Fixes to Improve Your Plotly Express Charts

Export Excel Charts to PowerPoint (Free Excel VBA Template)

ChatGPT Code Interpreter: Things Are Getting Wild

New Streamlit Chat Feature – Build a ChatGPT Clone in Under 50 Lines of Code 🤯

THIS Python Library Simplifies Working With Pandas

A Tableau Alternative in Python for Data Analysis (in Streamlit & Jupyter) | PyGWalker Tutorial

My New Excel Add-In for Interactive Charts (Behind the Scenes & Your Opinion)

AI Meets Pandas: A First Look at PandasAI

I Quit Coding – How I use ChatGPT instead as Data Analyst

I created a FREE ChatGPT Excel add-in 🤯

How to Create a Custom Excel Add-in (Step-by-Step Guide)

SQL + Python: Master Data Analysis and Create PDF Reports

Excel + ChatGPT Integration: The Ultimate Problem-Solving Duo

Create Killer Python Projects with ChatGPT’s Guidance 🔥

The Best Pandas Book

ChatGPT: Automating Excel with VBA like never before 🤯

Automate Boring Office Tasks with ChatGPT and Python

Excel Automation Made Easy with Python and ChatGPT (don’t miss out…)

Send SMS and MMS in Excel using Twilio and VBA [FREE Template]

The Ultimate Guide to Choosing Between Python and VBA

Replace Text in Multiple Word Documents with Python

Make Money Online using Python + Streamlit | Build a Sales Page to sell Digital Products 🤑

Complete Pandas Tutorial: Analyzing Data with Python

Convert All Excel Formulas into Values using Python

Don’t do THIS Pandas mistake!

Time-Series Data Manipulation with Pandas

Export Multiple Pandas DataFrames to a single Excel sheet

Pandas Trick: How to Clean Up Column Headers

The EASIEST way to load multiple EXCEL sheets in PANDAS

Deploy Your Streamlit App To Render (Free Heroku Alternative)

5 Little Known Pandas Features 🤓

Convert the content from multiple TXT or CSV files into Excel using Python (Real-World Example)

Build A Digital Resume Using Python & Streamlit

Automate Emails Using Python! Build An Automatic Payment Reminder & Schedule Your Scripts Online

Run SQL queries in EXCEL (just like a normal Excel formula 🤯)

Export a Pandas Dataframe to Excel with Document Properties

How to create a Streamlit Multi-Page Web App

Create an advanced GUI app with PySimpleGUI (Full Tutorial)

How to Lock Cells in Excel using Python 🔒 (by Cell Color, Font Style, Formula or Cell Value)

Build A Streamlit Web App From Scratch (incl. NoSQL Database + interactive Sankey chart) 🚀

How to Add a User Authentication Service (Login Form) in Streamlit + Database

How to Add a User Authentication Service (Login Form) in Streamlit

Turn Your Excel Sheet Into An Interactive Application Using Python (Full Project)

Merge multiple PDF files based on their name using Python (Real-World Example)

Make a GUI with just ONE LINE of code using Python

Compare Two Excel Sheets with Different Number of Rows and Find Differences using Python

Turn Your Excel Data Into An Interactive Dashboard Using Python | Pyecharts Tutorial

Download All Messages & Attachments From Outlook Using Python

The EASIEST way to insert a NAVIGATION into your Streamlit app

Weighted Average Calculation in Pandas

Supercharge Excel With Python 🚀

Generate MS Word documents in bulk based on an Excel list using Python

How to Merge Excel Files with Different Headers in Python

Create a Data Entry Form for MS Word in 10 Minutes using Python | PySimpleGUI & docxtpl Tutorial

Export Pandas DataFrames to new & existing Excel workbook

Find & Replace Values in Multiple Excel Files using Python (fast & easy)

How to Split Each Excel Sheet Into a Separate File Using Python

Build a Website in only 12 minutes using Python & Streamlit

Add a snowflake animation to your streamlit web app (quick & easy)

Python: How to Loop Through Folders and Subfolders

Create and Distribute Excel Files using Python and Outlook | Automate Excel with Python

How To Easily Insert Python Charts Into Excel

How to use the Pathlib Module in Python | QuickStart Guide for Beginners

Automate Excel Reporting Using Python (Real-Life-Example) | Pandas, Plotly, Xlwings Tutorial

4 Pandas Functions That I Wish I Knew Earlier

Turn An Excel Sheet Into An Interactive Dashboard Using Python (Streamlit)

Integrate Lottie Animations Inside Your Streamlit App!

Group Excel Sheets & Save Them As Separate Workbooks

Copy Data From Multiple Files to Master File | Read/Write Closed Excel Files Using Openpyxl

Send Bulk Emails From Your Gmail Account Using Excel VBA (with Attachments) | FREE TEMPLATE

How To Remove “Made with Streamlit”, Hamburger Icon Menu & Streamlit Header

Send BULK SMS From Your OWN Number Using EXCEL [Free Template]

Combine All Excel Files in a Folder into One Workbook

Build a Web App to Group & Plot Excel Files in Python with Streamlit

How to Send Push Notifications to Your Phone Using Excel & VBA

How To Fix | Run-time error ‘-2146232576 (80131700)’: Automation Error in Excel

Excel SUMIFS, COUNTIFS & AVERAGEIFS in PYTHON (Pandas Library)

Python: Split Each Excel Sheet Into Separate Files (fast & easy)

How To Send Bulk SMS From Excel With TWILIO + VBA [Free Template]

How to Create an Excel Data Entry Form in 10 Minutes Using Python (No VBA) | Easy & Simple

Split Excel Data into Multiple Files by Column Values using Python (fast & easy)

Create A Liquid (Water Polo) Chart From Excel Data in Python | ‘PyeCharts’ Tutorials

Automating Word Documents from Excel Using Python | ‘docxtpl’ Tutorial

How To Create Pandas Dataframe From Clipboard

How to Merge Multiple PDF Files in Excel Using Python (fast & easy)

Build a Weather App in Excel by using Python

Build a Dividend & Portfolio Tracker in Excel by using Python [Free Template]

Deploy Your Streamlit Web App on Heroku For Free (fast & easy)

Turn Your Excel File Into A Web App With Python (fast & easy) | Streamlit Tutorial

Pull Stock Data & Export It To Excel Using Python

Replace Excel Vlookup in Python Using Pandas (fast & easy) | Pandas Merge Tutorial

Read Messy & Poorly Structured Excel Files Using Pandas (Python)

How to Run Python in an Open Excel Workbook (EASY) | Combine Excel & Python | xlwings Tutorial

Solve Real-World Data Science Tasks in Python | Data Analysis with Pandas & Plotly (Full Tutorial)

Install Miniconda (Python) with Jupyter Notebook and Setting Up Virtual Environments on Windows 10

Quick Tip: Excel VBA Debugging

Send Daily Push Notifications to Your Phone Using Python | Build A New Year’s Resolution BOT (fast)

Create Gauge & Bullet Charts In 3 Seconds Using Excel and Python 🐍 | Free Excel Template

How To Create An Interactive Population Pyramid in Python Using Plotly

How To Send Bulk WhatsApp Messages From Excel Using VBA (Free & Easy) 📲

Create Hand Drawn Charts In Excel Using Python (Fast & Easy) | Cutecharts Tutorial 📊

How To Automate Excel Using Python | Combine Files & Create Charts 🤓

Turn Your Excel Worksheet Into An Exploratory Data Analysis Report In Just 3 Lines Of Python Code

Send WhatsApp Messages From Excel With VBA Using Twilio

Excel Template To Create Interactive Waterfall Charts | Combines VBA + Python

How To Create A Bar Race Animation Using Excel And Python

How To Create A Candlestick Chart In Python Using Plotly

How To Create A GUI Program In Python Using Tkinter

How to Get Stock Data & Export It To Excel Using Python

How To Create A Word Cloud In Python

How To Create A Pie Chart In Python Using Plotly & Excel

How To Create A Waterfall Chart In Python Using Plotly & Excel

How To Create An Animated Bar Chart (Bar Race) In Python Using Plotly & Excel

How To Create A Treemap & Sunburst Chart In Python Using Plotly & Excel

How To Execute A Python Script From Excel Using VBA

How To Create An Interactive Gantt Diagram In Python Using Plotly & Excel

How To Create A GUI In Python Using Tkinter To Display COVID19 Stats

How To Get Stock Data In Excel By Using VBA