Excel com VBA - Faculdade ESEG

Fill out the form below and proceed to purchase.

Your data is safe.

Excel with VBA

Learn how to use VBA (Visual Basic for Applications) to automate repetitive tasks in Excel and develop customized solutions applied to your business environment.

8 Modules

Online

About the course

The ESEG Excel with VBA course teaches you how to use Visual Basic for Applications to automate routines in Excel and create tailored solutions for your business. You will learn everything from recording simple macros to developing custom scripts, forms, and automated reports.

The course is taught by a production engineer graduated from USP (University of São Paulo) with over six years of experience in VBA programming. With practical and progressive content, you will learn to improve spreadsheet functionalities, create more complete forms, streamline data organization and analysis, and automatically generate intelligent reports.

labor market

Process automation is one of the biggest trends in today's job market. Professionals who know how to automate tasks in Excel with VBA eliminate hours of manual work, reduce errors, and deliver more results in less time—becoming key players in the teams where they work.

VBA is widely used in areas such as finance, controlling, logistics, human resources, and operations, where large volumes of data need to be processed quickly and accurately. Professionals with this skill are highly valued, receive greater responsibilities, and have a solid competitive advantage in the market.

Course modules

Overview of the Microsoft Office environment for VBA. How to navigate between worksheets, workbooks, and Excel objects using code. First macros recorded and edited.

Repetition structures in VBA: For…Next, For Each, Do While, and Do Until. How to automate tasks that repeat on lists and datasets.

Conditional logic in VBA for making decisions in code. How to create intelligent automations that adapt to different data conditions and scenarios.

Differences between recorded macros and manually written VBA code. How to use macro recording as a starting point and evolve towards programmed solutions with more control.

Efficient techniques for referencing, reading, writing, and formatting cells and ranges with VBA. How to work with dynamic selections and automate spreadsheet navigation.

Development of graphical user interfaces (UserForms) for data entry. Creation of customized forms integrated with spreadsheets for more efficient processes.

Access to the code editor (VBE), environment configuration, object-oriented programming concepts, and initial contact with the VBA language in the context of Excel.

How to research solutions in VBA, debug errors, organize code, and maintain automation projects. Final considerations and next steps to continue evolving in programming.

Professor of the course

Stefano of Larmelina

Graduated in Production Engineering from USP (University of São Paulo), with over six years of experience working with VBA programming. He deepened his programming knowledge during an exchange program in Sweden, at Linköping University.

Course value

12 installments of R$ 22.95

or R$ 230.00 cash

Professional Growth

Advance your career quickly and strategically.

At ESEG College, you can take short online courses focused on the skills most valued by the market.

Learn in a practical way, but with a solid foundation of knowledge, and be ready to seize new opportunities.

Who we are

Education for those who want to evolve with purpose and a vision for the future.

At ESEG College, we train professionals prepared for the real challenges of the market.

We combine a solid academic foundation, applied practice, and connections with companies to transform knowledge into a successful career.

We work from initial training to ongoing professional development, always focusing on innovation, employability, and human growth.

Testimonials

What they say about us

“I’ve been an entrepreneur for years, but I’ve always struggled to communicate the essence of my business. With the practical lessons and inspiring examples from the course, I gained a new perspective on how to tell stories to connect emotionally with my clients.”

Helena Martins

São Paulo

“I am a psychology student and I decided to complement my education with this course. I was impressed by the applicability of the information in both professional and personal contexts. I learned so much about the cognitive processes involved in purchasing decisions and now I can even better understand my own choices.”

Lucas Oliveira

Curitiba

“"Despite it being a complex topic, the professor managed to make it easy to understand. I learned data analysis techniques that I never imagined I could master, and now I feel prepared to face any challenge in the world of statistics."”