Udemybeginnerpt

Programando em VBA (Excel)

Learn Excel automation with VBA! Boost productivity by creating custom macros and automating tasks. Perfect for Excel users of all levels.

4.8(13)
47students
4h 12m
Certificate
Eliezer Cesar de Carvalho
Eliezer Cesar de CarvalhoInstrutor na Udemy

Course Content

Programando em VBA (Excel) is a beginner-level Udemy course taught by Eliezer Cesar de Carvalho. It runs 4h 12m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 13 reviews, with 47 students enrolled. It is a paid course, first published January 2025.

Unlock the power of VBA for enhanced productivity! This comprehensive course guides you from activating the VBA developer environment to crafting powerful automation routines. Gain the skills to streamline daily tasks and focus on critical analysis.

The course is structured into six strategically designed modules to maximize your learning experience:

  • Module 1: Course Structure & Introduction: Get acquainted with the course layout and essential components.
  • Module 2: Mastering the Developer Environment:
    • Enabling the Developer Tab: Learn how to activate the VBA editor in your Excel or other Office application.
    • VBA Project, Module, and UserForm: Understand the fundamental building blocks of VBA projects.
    • Developer Environment Overview: Explore the interface, including Option Explicit, creating subroutines, and utilizing the Properties Window.
    • Module & UserForm Import/Export: Learn to manage and share your VBA code.
    • Customizing the Developer Tab: Personalize your development environment for optimal workflow.
    • Best Practices: Discover the importance of code commenting, proper indentation, debugging techniques, and understanding command syntax.
  • Module 3: VBA Tips & Tricks:
    • Library vs. Macro Recording: Understand the differences and when to use each approach.
    • Finding VBA Commands: Learn effective methods for researching VBA syntax and commands.
  • Module 4: Hands-on VBA – Part 1:
    • Variable Types: Learn to declare and utilize different data types in your VBA code.
    • Cell Manipulation: Master Range selection, Offset, and Selection for precise cell referencing.
    • Conditional Logic: Utilize the If and ElseIf statements for decision-making in your code.
  • Module 5: Hands-on VBA – Part 2:
    • Looping Structures: Implement Do While loops for repetitive tasks based on conditions.
    • Formula Syntax with Macros: Automate formula creation and manipulation using VBA.
  • Module 6: Hands-on VBA – Part 3:
    • Error Handling: Implement On Error GoTo and Resume Next for robust error management.
    • Date & Time Functions: Utilize the Date and Now commands for working with dates and times.
    • Message Boxes: Display informative messages to the user using MsgBox.
    • Sub & Module Calls: Learn to call and organize your VBA code.
    • Workbook & Sheet Commands: Manipulate workbooks and worksheets effectively.
    • File Operations: Open and close workbooks using Workbook commands.
    • Creating Command Buttons: Implement user-friendly command buttons for triggering VBA actions.
    • Code Protection: Secure your VBA code from unauthorized access.
    • UserForm Application: Design and implement custom UserForms for interactive data entry and control.

By mastering these VBA techniques, you'll significantly boost your efficiency and gain a competitive edge in data management and process automation.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

Crie um Dashboard com Excel sem Complicação

by Roberto Sabino (OfficeResolve)

5.0(73)
1h 29m
intermediate
5.0(1)
4h 57m
beginner
5.0(2)
32m
beginner

Excel Intermédio e Avançado

by Bento Gregório Maria

5.0(3)
1h 7m
intermediate
5.0(20)
2h 6m
beginner