Mammoth Club All levels 2 sections 10 lectures

Natural-Language Spreadsheet Automation with Excel, Ollama, and Openpyxl

Start automating your own spreadsheets today.

01
Skill level
All levels
02
Sections
2
03
Lectures
10
04
Instructor
Jared M
What's inside

This course includes.

2
Sections
10
Lectures
19
Resources
Certificate of completion
Included
Mobile and desktop access
Included
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

2 sections · 10 lectures
+ 01 Downloading Ollama + Models 1 lecture
01.01 Downloading Ollama + Models Locked
+ 02 Python Implementation 9 lectures
02.01 Project Initialization + First Request To Ollama Locked
02.02 Selecting an Excel File To Work With Locked
02.03 Dynamically Prompting Ollama with User Input Locked
02.04 Parsing Our JSON Response Locked
02.05 Mapping Output to Excel Function Calls Locked
02.06 OpenPyxl Insert Value + Insert Formula Functions Locked
02.07 OpenPyxl Highlighting Ranges Locked
02.08 OpenPyxl Formatting Ranges Locked
02.09 OpenPyxl Conditional Formatting Locked
Description

About this course.

Telling Excel what you want in plain language is more useful than another formula to memorize.

This video course connects Ollama and openpyxl so you can automate spreadsheet work through natural language.

► Download Ollama, set up your project, and send your first request.

► Select an Excel file, prompt dynamically, and parse the JSON response.

► Map AI output to Excel functions, inserting values and formulas.

► Highlight, format, and apply conditional formatting with openpyxl.

It's a practical build, from the first prompt to a formatted spreadsheet.

✅ Lifetime access to all modules.

Instructors

Taught by people who ship.

JM

Jared M

Instructor

Produced by a team of Mammoth Club industry experts. Over 15 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.

Ready to start building?

Start automating your own spreadsheets today.

Buy lifetime access →