inflearn logo

Excel Vibe Coding: Automate Ribbon Menus with AI Without Knowing VBA [Power Tools Masterclass]

Not an Excel course that ends when you finish learning, but one that makes your own tool “snap” into the ribbon. It’s time to stop letting VBA books become mere bookshelf decorations! Even without knowing a single line of code, you can create your own automation button simply by conversing with AI. Discover now, through this free course, how to create CustomUI-based add-ins—a method revealed from start to finish for the first time in Korea by a Microsoft Excel MVP.

5 learners are taking this course

Level Basic

Course period Unlimited

Excel
Excel
MS-Office
MS-Office
Business Productivity
Business Productivity
add-ins
add-ins
AI
AI
Excel
Excel
MS-Office
MS-Office
Business Productivity
Business Productivity
add-ins
add-ins
AI
AI

What you will gain after the course

  • The ability to complete VBA code through conversations with AI alone: “Excel vibe coding”

  • How to Create Your Own Tabs and Buttons Directly in the Excel Ribbon Menu

  • My Own Actually Working Excel Automation Add-in (XLAM) Tool — Everything from Creation to Distribution Explained

  • A 75-page 'study notes' PDF provided along with the lecture videos — for optimal learning effectiveness


Excel ribbon menus,
now create them yourself with AI!

Leave repetitive tasks to AI
and solve them with your own Excel tools.


For repetitive Excel tasks, even when you ask the IT department to develop a macro, the answer is always "next month."】【。

You may have bought a VBA book with great resolve, only to find it becoming a bookshelf ornament after just a few days when faced with incomprehensible English commands.

Even after struggling to complete a macro, have you ever opened a new file only to find that the button has disappeared without a trace?

Stop waiting for someone else’s help.
Anyone can create the features they want
and become an Excel automation expert.

This course is conducted using the 'Excel Vibe Coding' approach. Instead of memorizing VBA syntax, simply describe the functionality you want to AI in words, and the code will be completed. Once you learn the R·C·T (Role·Context·Task) conversation formula, you too can get started right away today.


Complete VBA code in no time by conversing with AI,
and create your own Excel add-in yourself.


We’ll transform professionals worn out by repetitive tasks into Excel automation experts,
creating a more convenient and smarter work environment for you.

From creating your own tab in the Excel Ribbon menu to completing cell, sheet, and workbook automation features one by one, and finally distributing your finished tool as an xlam file—simply follow this complete pipeline across 4 chapters and 15 lessons.



By the end of this course, you will be able to


You can create Excel VBA code yourself by conversing with AI and implement your own tab.

  • You no longer have to feel overwhelmed by complex VBA syntax. Through natural conversations with AI, you can obtain VBA code that implements the features you want and use it to complete your own Excel add-in (xlam). You’ll gain hands-on experience creating your own tools to automate repetitive tasks.


You can design and place your own tabs and buttons directly on the Excel ribbon.

  • You will learn how to use an XML framework template to create tabs and groups and customize button names and icons as you wish. You will develop the ability to systematically organize menus by type of task—cells/ranges, worksheets, workbooks, and more—through structural design.


You can complete your own Excel automation add-in that actually works.

  • You will directly implement buttons that complete daily repetitive tasks—such as filling blank cells, automatically generating tables of contents, and batch-saving PDFs—with a single click. Rather than theory, this is the hands-on result of the actual commercial add-in 'PowerTools', so the moment the course ends, a genuine tool will be installed in your Ribbon menu.


You can safely distribute and continuously manage the completed tool.

  • Learn how to protect your VBA code with a password and package it in xlam format for installation on your colleagues’ PCs. You’ll also learn how to manage your software as a sustainable, personal solution—not something you create once and forget—by incorporating version control and automatic update notifications.

✔️

Excel Vibe Coding, the One and Only Solution to Transform Your Work

You don’t need to know how to code. Just by talking with AI, your Excel will become an entirely new tool.

Build your own Excel automation with AI

Solve repetitive Excel tasks simply by chatting with AI. Complete the macro/VBA code you need, and create your own Excel add-in (xlam) with custom tabs and buttons. Kwon Hyun-wook (Exceller), an instructor with 25 years of experience (Microsoft Excel MVP and CEO of iExceller), will open up a whole new world of Excel for you.

"This is the end product you will create.

From camera tools, filling blank cells, and creating tables of contents to saving PDFs and backing up files, by the end of the course, these kinds of work automation tools will be right there in your Excel ribbon.

This isn’t theory. You’ll create, with your own hands, automation tools that you’ll use every day in your actual work.

Build Practical Automation Tools

Following the instructions of Kwon Hyun-wook (Exceller), the representative of the iExceler website, operator of the YouTube channel 'Exceller TV,' and Microsoft Excel MVP, this course guides you through the hands-on process of creating the ribbon menu framework with copy and paste and linking macros to buttons. Directly implement cell/range, worksheet, and workbook automation features that boost your work efficiency by 200%.

Fill Blank Cells
Complete the multi-step ‘Fill Blank Cells’ process with just one click. Automatically fill blank cells with team names that are entered only in the first row using a single button. Sorting and filtering are no longer a problem.

Merge cells with the same values
Cleanly merge repeating team names with a single click. Your reports become instantly easier to read. You can merge only cells with the same values or, conversely, automatically fill empty cells while unmerging merged cells.

It doesn’t end with creating it. Just like real software, you’ll learn how to protect, share, and maintain it.

Developing and Distributing
Your Own Excel Power Tools

From the fundamentals of conversing with AI to leveraging Excel’s hidden powerful features, this course provides a detailed guide to safely protecting VBA code and creating and distributing XLAM files to deploy your Power Tools across any Excel installation. This is your opportunity to introduce your very own Excel automation tools to the world.

Password-protect your VBA code, package it as an xlam, and install it directly on your colleagues’ PCs. This is the moment when the tool you created becomes a real 'product'.

Once you protect and distribute the code, your PowerTools become finished software that works anywhere.


📚

Create Your Own Excel Tool with AI

Section 1

Ribbon Menu Customization and Button Integration

Create the basic structure of the Ribbon menu with just copy and paste, then customize the names and icons of the buttons. Learn how to successfully link the created buttons to VBA macros and implement personalized functionality.


Section 2

Generating VBA Code and Implementing Automation with AI

Learn techniques for generating the desired VBA code through effective communication with AI. Implement essential practical features such as automating cells, ranges, worksheets, and workbooks, and complete an add-in that includes help and version management features.


Section 4

Excel Add-in (XLAM) Deployment and Code Protection

Learn how to prevent unauthorized modifications to the VBA code you write, and convert it to the XLAM format so it can be distributed across all Excel environments. Finally, you’ll proceed to the stage of making the Power Tools you developed available to actual users and putting them to use.


Does this situation feel familiar? It could be your story.

We can solve the challenges faced by people like you!


📌

Professionals tired of repetitive tasks
- Those who waste time manually repeating the same Excel tasks every time and feel frustrated because it is difficult to ask the IT department to develop macros

📌

Those who have repeatedly given up when faced with VBA
-
Those who recognize the need for Excel macros but find writing VBA code themselves daunting or have tried several times and ultimately given up


📌

Users who want their own custom features
- Those who feel that Excel's existing features are insufficient and want to maximize work efficiency by adding their own customized tabs and buttons to the ribbon menu


If even one of these applies to you, this course is exactly the answer you’re looking for.



Notes Before Taking the Course


Practice environment

  • Operating system: Windows 10 or later recommended

  • Required program: Microsoft Excel (version 2016 or later)

  • Recommended specifications: 4GB of RAM or more, and at least 10GB of storage space

Prerequisite Knowledge and Notes

  • Those who need to automate repetitive tasks

  • No experience with Excel macros is required.

  • You should be able to have natural conversations with AI.

Learning Materials

  • Provision of PDF learning notes materials

  • Practice example files and AI code templates provided

  • Conduct Q&A sessions based on the course content


Recommended for
these people

Who is this course right for?

  • A hands-on employee frustrated because there’s no one in the IT department to ask for a repetitive-task macro.

  • Excel users who understand the need for macros but haven’t been able to get started, or who have tried several times and given up partway through

Need to know before starting?

  • It's okay if you have no coding experience at all. As long as you know how to use Excel at a basic level, that's sufficient.

Hello
This is iexceller

Career Verified

235

Learners

42

Reviews

2

Answers

4.6

Rating

4

Courses

Nice to meet you. I am Hyun-wook Kwon (Exceler).

I will become a solution provider for everyone who aims for work efficiency.

 

  • Current: CEO of iExceller.com

  • Current: Excel Programmer • Solution Provider • Author

  • Current: YouTube Creator Channel Name: Exceller TV

  • Current: Microsoft Excel MVP

  • Former: Amorepacific Group Strategy Team Leader, Innovation Team Leader, Planning Team Manager

  • Former: Skinfood Chief Financial Officer (CFO, Managing Director), Director of Management Support

  • Former: Professor at Korea National Open University | Department of Industrial Engineering, Prime College

  • Previous: Samsung SDS Multi Campus Tutor

  • Former: Tutor and Inspection Committee Member at the Korea Agency for Digital Opportunity and Promotion 'Baeum-Nara'

More

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

iexceller's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$80.00

25%

$110.00