Master VBA Programming [Automate Tasks in Excel]

Unit 1: Before You Begin

→ Welcome to the course
→ Motivation

Unit 2: PSeInt - Introduction to programming

→ PSeInt - Facilitating the Learning of Programming Logic
→ PSeint Installation
→ Data Types and Variables
→ Dimension - Arrangements
→ Arithmetic and Logical Operators
→ Data Input and Output

Unit 3: PSeInt - Flow control structures

→ Simple Conditional
→ Conditional with Conjunction AND
→ Conditional with Disjunction OR
→ Switch Case or According
→ Repetitive Structure - While or While
→ Repetitive Structure - Repeat or Do While
→ Repetitive Structure - For or For

Unit 4: PSeInt - Functions

→ Mathematical Functions
→ String Functions
→ Functions, Procedures or Subprocesses
→ Recursion

Unit 5: PSeInt - Matrices

→ Matrices
→ 3x3 matrices
→ Read and Display People's Login

Unit 6: PSeInt - Debugging and code debugging

→ Debugging and code debugging

Unit 7: PSeInt - Creating Programs

→ Creating a Calculator with Functions
→ Guess a Random Number

Unit 8: Introduction to VBA

→ What is Visual Basic for Applications?
→ The Importance of Learning VBA Today
→ Getting to know the VBA Editor
→ Configuring the VBA Editor

Unit 9: VBA - Modules and Procedures

→ Modules
→ Procedures Part 1
→ Procedures Part 2
→ Create and invoke our own functions

Unit 10: VBA - Variables, Operators, Arrays and Constants

→ Variables
→ Declaration of Variables
→ Matrices and Constants
→ Operators

Unit 11: VBA - Conditional Flow Structures

→ IF-ELSE conditional
→ Conditional IF-ELSEIF-ELSE
→ Conditional SELECT CASE

Unit 12: VBA - Repetitive Structures

→ DO LOOP Repetitive Structure
→ Repetitive Structure WHILE WEND
→ FOR NEXT Repetitive Structure
→ Repetitive Structure FOR EACH NEXT
→ Break Out of Control Structures

Unit 13: VBA Programming Exercises

→ Numbers from 1 to N
→ Even numbers from 1 to N
→ Addition of Numbers 1 to N
→ Average of Numbers 1 to N
→ Prime Number
→ Factorial
→ Vowels in a Word
→ Letters Words Without Vowel
→ Find the Maximum Value and Position of a Vector
→ The Maximum PAR Value and Position of a Vector
→ Total Sum Even and Odd

Unit 14: Using VBA in Excel

→ Performing Multiple Actions on One Object
→ Sort Data Table
→ Copy, Paste and Consolidate Information from 2 or More Sheets
→ Create Excel Sheets Based on a List of Names
→ Create Excel Workbooks Based on a List of Names
→ Create PDF Documents for each Sheet of a Workbook in Excel
→ Progress Bar in Excel
→ Create Random Phrases
→ Digital Clock
→ Creating Custom Invoices
→ Currency Converter
→ Automating Common Tasks in Excel with Macros

Unit 15: VBA Integrations with the Rest of Office

→ Get Outlook Emails with Excel
→ Get Outlook Emails by Date
→ Extract Outlook Attachments with Excel
→ Send Email from Excel with Attached File
→ VBA Word - Adjust the Size of Images in a Document

Course evaluation

→ This course contains a final exam

G-Tools: For Students

→ Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.

⚑ Certificate of completion

→ Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.