inflearn logo

Excel Power Tools Masterclass: Automating Ribbon Buttons with AI Without Knowing VBA

Not just an Excel lecture that ends after learning, but a lecture where your own tools appear "snugly" on the ribbon. No more letting VBA books become bookshelf decorations! Even if you don't know a single line of code, you can complete your own automation buttons just by chatting with AI. Check out the free lecture now to see the CustomUI-based add-in production method, revealed from start to finish for the first time in Korea by a Microsoft Excel MVP.

3 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 "Excel Vibe Coding" ability to complete VBA code just by conversing with AI

  • How to create your own custom tabs and buttons in the Excel ribbon menu

  • Your Own Working Excel Automation Add-in (xlam) Tool — Everything from Creation to Deployment

  • 75-page 'Study Notes' provided (PDF) along with lecture videos — optimal learning effect


Excel Ribbon Menu,
now create it yourself with AI!

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


Even when you request macro development from the IT department for repetitive Excel tasks, the answer you get back is always "next month."

Did you buy a VBA book with great determination, only for it to become a bookshelf decoration within a few days in the face of incomprehensible English commands?

Even if you managed to complete a macro with great difficulty, didn't the button vanish without a trace when you opened a new file?

Stop waiting for others to help you.
Anyone can transform into an Excel automation expert
who creates the functions they want themselves.

This course is conducted using the 'Excel Vibe Coding' method. Instead of memorizing VBA syntax, you simply explain the desired function to the AI, and the code is completed for you. By mastering the R·C·T (Role, Context, Task) conversation formula, you can start right away today.


Instantly complete VBA code through conversation with AI,
and create your own Excel add-in yourself.


Transforming professionals tired of repetitive tasks into Excel automation experts,
creating a more convenient and smarter work environment for you.

From creating your own custom tab on the Excel ribbon menu to completing automation functions for cells, sheets, and workbooks one by one, and finally distributing the finished tool as an xlam file—simply follow this complete pipeline consisting of 4 chapters and 15 lessons.



By the end of this course, you will


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

  • You no longer have to feel overwhelmed by complex VBA syntax. Through natural conversation with AI, you can obtain VBA code to implement the functions you want and use it to complete your own Excel Add-in (.xlam). You will gain the experience of personally creating your own tools to automate repetitive tasks.


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

  • You will learn how to create tabs and groups using XML skeleton templates and customize everything from button names to icons as you wish. You will also acquire the structural design skills to systematically organize menus by task type, such as cells/ranges, worksheets, and workbooks.


You will be able to complete your own Excel automation add-in that actually works.

  • You will directly implement tasks you repeat every day—such as filling empty cells, automatically generating tables of contents, and batch-saving PDFs—into buttons that finish the job with a single click. These are not just theories, but actual practice results from the commercial add-in 'Power Tools,' and the moment the lecture ends, a real tool will take its place in your ribbon menu.


You can safely distribute and continuously manage the completed tools.

  • You will learn how to protect your VBA code with a password and package it in .xlam format to install it on your colleagues' PCs. By incorporating version control and automatic update notification features, you will master how to operate your creation as sustainable, personal software that evolves over time, rather than a one-off project.

✔️

Excel Vibe Coding, the one and only solution to innovate your work.

It's okay if you don't know how to code. Just by conversing with AI, your Excel will become a completely new tool.

Creating Your Own
Excel Automation with AI

Solve repetitive Excel tasks now just by conversing with AI. Complete the Macro/VBA code you want and create your own Excel Add-in (.xlam) with custom tabs and buttons. Instructor Kwon Hyun-wook (Exceller), a Microsoft Excel MVP and CEO of iExceller with 25 years of experience, will open up a whole new world of Excel for you.

"This is the result you will be creating.

From the Camera tool and filling blank cells to creating tables of contents, saving as PDF, and backing up files—by the time you finish this course, these task automation tools will be right there in your Excel ribbon menu.

This is not theory. You will complete the automation tools you'll use every day in actual work with your own hands.

Creating Custom
Automation Tools for Practical Work

Following the instructions of instructor Kwon Hyun-wook (Exceller)—CEO of the i-Exceller site, operator of the YouTube channel 'Exceller TV,' and Microsoft Excel MVP—this guide will walk you through the practical process of building a Ribbon menu framework using copy-and-paste and linking macros to buttons. Experience firsthand how to implement automation features for cells/ranges, worksheets, and workbooks that will boost your work efficiency by 200%.

Fill Empty Cells
Solve the 'Fill Empty Cells' function, which usually requires multiple steps, with just a single click. Automatically fill empty cells in data where team names are only entered in the first row with one button. Sorting and filtering will no longer be an issue.

Merge Cells with Same Values
Cleanly merge repeating team names with a single button. The readability of your reports will change in an instant. You can merge only cells with the same values, or conversely, unmerge cells and automatically fill the resulting empty cells at the same time.

It doesn't end with just creating it. You will learn how to protect, share, and maintain it like real software.

Developing and Distributing
Your Own Excel Power Tools

From the conversation formulas for talking to AI to utilizing powerful hidden features in Excel, we provide detailed instructions on how to create and distribute XLAM files that securely protect VBA code and transplant Power Tools into any Excel environment. This is your chance to release your own Excel automation tools to the world.

From setting a password on your VBA code to packaging it as an xlam and installing it directly on a colleague's PC. This is the moment the tool you created becomes a real 'product'.

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


📚

Creating Your Own AI Excel Tools

Section 1

Customizing the Ribbon Menu and Linking Buttons

You will learn how to create the basic structure of a ribbon menu simply by copying and pasting, and how to customize button names and icons. We will cover how to successfully link the created buttons with VBA macros to implement user-customized functions.


Section 2

Generating VBA Code and Implementing Automation Using AI

Learn techniques for generating desired VBA code through effective interaction with AI. Implement core practical functions such as cell, range, worksheet, and workbook automation, and complete an add-in that includes help documentation and version control features.


Section 4

Excel Add-in (XLAM) Deployment and Code Protection

Learn how to prevent unauthorized modification of your VBA code and convert it into XLAM format so it can be deployed across all Excel environments. Finally, proceed with the steps to release and utilize the developed Power Tools for actual users.


Does this situation look familiar? This could be your story.

We can solve the concerns
of people like this!

📌

Working professionals tired of repetitive tasks
- Those who feel frustrated by wasting time manually repeating the same Excel tasks every time, and find it difficult to ask the IT department for macro development

📌

Those who have given up on VBA every time
-
Those who feel the need for Excel macros but find writing VBA code daunting, or have tried several times only to eventually give up.


📌

Users who want their own custom functions
- Those who feel that existing Excel features are not enough and want to maximize work efficiency by adding their own customized tabs and buttons to the ribbon menu.


If any of these apply to you, this course is the perfect answer.



Notes before taking the course


Practice Environment

  • Operating System: Windows 10 or higher recommended

  • Required Programs: Microsoft Excel (2016 version or higher)

  • Recommended Specifications: 4GB RAM or more, 10GB or more of storage space

Prerequisite Knowledge and Important Notes

  • Those who have a need for automating repetitive tasks

  • It is okay even if you have no experience with Excel macros.

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

Learning Materials

  • Study note PDF materials provided

  • Providing practice example files and AI code templates

  • Operation of Q&A sessions based on lecture content


Recommended for
these people

Who is this course right for?

  • A practitioner who is frustrated because there is no one in the IT department to ask for a repetitive task macro.

  • Excel users who recognize the need for macros but haven't been able to start, or have tried several times only to give up halfway.

Need to know before starting?

  • It is perfectly fine even if you have no prior coding experience. As long as you have a basic understanding of how to use Excel, that is sufficient.

Hello
This is iexceller

Career Verified

199

Learners

35

Reviews

2

Answers

4.7

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!

Limited time deal ends in 7 days

$2,070,943.00

30%

$110.00