Course on Excel Automation.

Overview

• Project
• Project Explorer
• Menubar
• Toolbar
• Code Window
• Module
• UserForm

Programming Fundamentals Using VBA

• Procedures
• User Defined Functions
• InputBox Function
• MsgBox Function
• Variables
• Constants
• Data Types
• Working with Logical Operators
• IF Statement
• Nested IF Statement
• IF with And Or Scenarios
• Select Case
• VBA Functions
• Problem Solving Techniques Required for Programming
• Saving Macro Enabled Files
• For Loops
• Do Loops
• While...Wend Statement
• Protecting Code
• Error Handling

Running Code

• Run mode as a developer
• Running Code as end user
• Running Code to debug procedures & Functions

• Understanding Object-Based Programming
• Understanding Objects
• Working with Collection Objects
• Working with Methods
• Read & Write Properties

Programming & Automating with Excel Objects

• Excel Object
• Workbook Object
• Worksheet Object
• Cell Objects
• WorksheetFunction Object
• PivotTables Object
• Chart Objects
• Other Misc Objects

Code Automation Concepts via Excel Automation

• Calling Methods
• Passing Arguments while Calling Procedures
• Passing Arguments while Calling Functions
• Creating & Strategizing Re-usable Code Modules

• Understanding Excel Forms
• Creating Attractive User Experience with Excel Forms
• Using Forms Control
• Linking & Managing Forms Control
• Performing CRUD (Create, Retrieve, Update & Delete Records) with Excel Forms

VBA Forms

• Understanding VBA Forms
• Creating Attractive User Experience with VBA Form
• Pros & Cons of VBA Form
• Understanding Toolbox
• Using Tools Objects like Label, TextBox, ListBox, ComboBox, Option Buttons, Command Buttons, etc.
• Understanding Events
• Working with Form Events
• Performing CRUD (Create, Retrieve, Update & Delete Records) with VBA Form

• Using a Set Statement
• Understanding Object Variables
• Application Object
• Documents Object
• Table Object
• Working with Selections
• Other Misc Word Objects

Sending Emails & Reading Incoming Emails using Outlook Objects

• Outlook Object
• Items Object
• Emails Collection
• Sending emails with Plain Text & Attachments
• Sending HTML Emails
• Query to retrieve Mail From, to and CC address
• Retrieve Mail Subject and Time
• Retrieve Mail Attachment

• Creating a Database
• Understanding Tables and Creating Tables
• Querying Data
• Filtering Data
• Grouping Data
• Ordering Data
• Column Aliases
• Table Aliases
• Retrieving data with VBA
• Inserting, Updating and Deleting Data with VBA

1. Computer

• Windows operating system
• Minimum 4GB RAM (8GB or higher recommended)
• Dual-core processor or higher
• Reliable internet connection for seamless online sessions and downloads

2. Software

   • Microsoft Excel (version 2010 or later) installed on your computer
   • Microsoft Visual Basic for Applications (VBA) enabled within Excel

3. Webcam

   A working webcam is required to participate in online sessions. Please ensure it is functional and positioned properly for clear visibility.

4. Secondary Monitor (optional, but recommended)

   Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.