Excel VBA Practical Programming

Name: Excel VBA Practical Programming
Price: 99000 KRW
Rating: 5 (1 reviews)

For office workers who are tired of repetitive Excel tasks, we will teach you coding, and for those who only know Excel in a simple way, we will teach you its power and infinite possibilities!

(5.0) 1 reviews

26 learners

Level Basic

Course period Unlimited

xlwhy

Excel

VBA

Excel

VBA

What you will gain after the course

Automating tasks that frequently appear in practice
Finish manual Excel work with one button

For those of you who are tired of repetitive Excel work
I highly recommend using Excel VBA in your work! 📗

Visual Basic for Applications (VBA)

As a programming language embedded in Microsoft Office,
This is a function that automates tasks.

Anyone who's ever used Excel has probably dreamed of learning Excel macros and VBA at least once! However, the high barrier to entry makes it difficult to actually use VBA in the workplace. This is especially true for VBA. In this course, we'll teach you how to code using Excel, a fundamental tool used in companies, and help you break free from repetitive manual tasks.

I recommend this to these people 🙋‍♂️

I'm unfamiliar with Excel VBA
For those who don't know how to write

If you get stuck while coding,
People who don't understand other people's code

Debugging window while running the program
People who give up when they come out

Features of this course ✍

Automate specific tasks in a short period of time.
The code is written to be as simple and short as possible without any unnecessary details.
We will quickly proceed with only the key points, focusing on imparting knowledge.
We frequently show you debugging techniques necessary to understand code written by others.
Anyone can see and understand any of the 2007, 2010, 2013, 2016, 2019, 2021, or 365 versions.
The theory is kept to a minimum and made strictly in the practical way of general workers.

What you'll learn 📚

2-Structure Transformation_Promotional.gif

4 Address Book - Labeling_Promotional (2).gif

Expected Questions Q&A 💬

Q. Is there anything I need to prepare before attending the lecture?

You just need Excel for Windows installed on your computer. These days, most people use Excel 2010 or later, but any version higher than 2007 will do.

Q. Are there any pre-registration courses?

I recommend taking the Excel macro lecture. Try recording a lot of Excel macros.

Q. What are the benefits of taking a VBA course?

It's great for automating tasks like business or other large data volumes.

Recommended for
these people

Who is this course right for?

People who are tired of repetitive tasks in Excel
For those who want to learn what coding is (feat. Excel)

Need to know before starting?

Excel Macro
Take my previous lecture (Excel Craftsman's Macro) first

Hello
This is

220

Learners

Reviews

4.3

Rating

Courses

--Development History--

Samsung Fire & Marine Insurance Co., Ltd.: Product Analysis Answer Key Development Project
Doosan Heavy Industries & Construction Co., Ltd.: BEP Simulator
KT Corporation: Job Competency Advancement Program
Yanggu-gun Forestry Association: Proxy Management Program
Kumho Tire Co., Inc.: Supply Chain Management (SCM) Program Excel Part
LG Electronics: Global Procurement Analysis System Excel Part
Samsung Electronics: Global SCM Demand Analysis System Excel Part
IBM Korea: Vendor Selection Program, Excel Training for Procurement Staff
KB Kookmin Bank: Next-Generation New Product Factory Excel Part
Woori FIS: Next-Generation Project Excel Part
K-water: Water and Sewage Construction Cost Estimation Program
Haenam-gun Agricultural Technology Center: Microorganism Management Program
Community Chest of Korea: Budgeting Program
I have developed hundreds of other projects and continue to work as an active Excel programmer.

--Books--

1. Excel Summary for Smart Work Life (Basic Book 3)
2. Excel Master's Macro VBA (Macro Book)
3. Excel Master's 2016 Mastering Book (Basic Book 2)
4. Excel Master's Excel Function Mastering Book
5. Excel Master's 2013 Mastering Book (Basic Book)

Curriculum

All

41 lectures ∙ (2hr 15min)

Course Materials:

Lecture resources

Section 1. VBA Introduction and Definition

1 lectures ∙ (6min)

1. 0 vba,object,method,property,currentregion,paste
06:49

Section 2. Direct coding (Generate and send sheets using data and a template sheet)

3 lectures ∙ (19min)

Section 3. Export filtered data to another sheet

1 lectures ∙ (4min)

5. 4 Advanced Filter
04:08

Section 4. Organizing data into a converted structure

3 lectures ∙ (11min)

Section 5. Import form input data from another file

1 lectures ∙ (1min)

Section 6. Custom Form Partial Search Input/Select and Query, File Creation

3 lectures ∙ (14min)

Section 7. Merging multiple files into one

2 lectures ∙ (11min)

Section 8. Check sheet existence, advanced filter for criteria.

1 lectures ∙ (3min)

Section 9. Check if the file exists

1 lectures ∙ (0min)

Section 10. Delete Row, Insert Row

2 lectures ∙ (3min)

Section 11. Color Processing, Creating and Using UDF (User Defined Function)

1 lectures ∙ (1min)

Section 12. Merging cells (feat. loop)

1 lectures ∙ (1min)

Section 13. Definition of Event, Coding Location, and Usage

5 lectures ∙ (8min)

Section 14. Address Book (Labeling, DM) Automation

5 lectures ∙ (14min)

Section 15. Sheet processing

3 lectures ∙ (5min)

Section 16. Pivot Table object access

2 lectures

Section 17. Accessing Chart Objects and Adding/Using Form Controls

1 lectures ∙ (3min)

Section 18. Print (Batch Statement Printing)

1 lectures ∙ (2min)

Section 19. Processing Multiple Cell Values with Find

2 lectures ∙ (4min)

Section 20. Save as specific format (pdf)

1 lectures ∙ (2min)

Section 21. List all files by searching including subfolders

1 lectures ∙ (13min)

Published:

Last updated:

Reviews

All

1 reviews

5.0

1 reviews

jaeyoonhan4591
Reviews 8
∙
Average Rating 5.0
5
32% enrolled

$77.00

xlwhy's other courses

Check out other courses by the instructor!

Excel Craftsman's Macro

xlwhy

For Excel 2007, 2010, 2013, 2016, 2019, and 365 users, we will show you the power of Excel macros and the techniques and functions that can automate simple repetitive tasks without VBA coding.

Basic

Excel, MS-Office

Excel Craftsman's Macro

xlwhy

Similar courses

Explore other courses in the same field!

Master Excel 2019 Macro VBA from the Basics

comt

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

Basic

Excel, VBA, Business Productivity

Master Excel 2019 Macro VBA from the Basics

comt

[2024 New Year Special] Excel beginner practical skills that are 10 times faster!

wonhokang902456

Excel is not something that you can learn quickly by learning new functions or difficult features. Try playing a game with just the keyboard. I'll show you how much time you can save!

Basic

Excel, MS-Office

[2024 New Year Special] Excel beginner practical skills that are 10 times faster!

wonhokang902456

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

workwithdugi

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

Beginner

Business Productivity, Google Apps Script, Google Sheets

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

workwithdugi

Excel 2013 VBA: Learn it fast and easily

officetutor

Learn about tasks that can be done using Excel VBA. Learn about the basic syntax of VBA and objects, collections, properties, methods, and events, and create and use Visual Basic functions, Excel functions, and user-defined functions.

Intermediate

MS-Office, VBA

Excel 2013 VBA: Learn it fast and easily

officetutor

Useful Excel macros without coding

Masocampus

A course that covers how to conveniently handle work using the macro recorder without the burden of VBA coding! You can understand how to utilize macros in various ways through practice of simply converting data accumulated in the company into an Excel database and building a search system to find it.

Basic

Excel, excel-macro, MS-Office

Useful Excel macros without coding

Masocampus

Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts

Masocampus

Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

Beginner

ChatGPT, Excel, AI

Efficient AI Utilization That Companies Want - Conquering Excel with AI Structured Prompts

Masocampus

Master Excel Automation for Work Efficiency with ChatGPT

365ENM

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

Beginner

Generative AI, ChatGPT, Excel

Master Excel Automation for Work Efficiency with ChatGPT

365ENM

Effective business capacity enhancement, Python business data analysis expert course

Masocampus

Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

Basic

Python, Excel, Excel Power Pivot

Effective business capacity enhancement, Python business data analysis expert course

Masocampus

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

iexceller

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

Basic

Excel, VBA, ChatGPT

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

iexceller

Efficient AI Utilization That Companies Want - Practical Data Processing Secrets Conquered with Structured Prompts

Masocampus

AI Excel that automates perfectly for your work without company security concerns. From data preprocessing to visualization in just a few minutes, no coding knowledge required!

Beginner

Excel, AI, ChatGPT

Efficient AI Utilization That Companies Want - Practical Data Processing Secrets Conquered with Structured Prompts

Masocampus

Excel VBA Practical Programming

What you will gain after the course

I recommend this to these people 🙋‍♂️

Features of this course ✍

What you'll learn 📚

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

xlwhy's other courses

Similar courses

Recommended for
these people

Hello
This is