Home » Courses » MS Excel Macros with VBA – 2010/2013/2016

MS Excel Macros with VBA – 2010/2013/2016

ENQUIRE NOW
ENQUIRE NOW
Current Status
Not Enrolled
Price
$380
Get Started
ENQUIRE NOW

Course Title: MS Excel Macros with VBA- 2010/2013/2016

Methodology: Live Online Instructor-Led

Course Status– Accepting applications

Broad Aims Of This Course

This course is designed for those who are expert users of MS Excel and have comprehensive knowledge about Excel features, functions and formulae. It would enhance the users knowledge and upgrade their skills to the next level by automating their repetitive tasks or designing new functions. The course covers recording macros, VBA fundamentals, Loops and Constructs, Sub Procedures, Functions, Events, User Forms, etc.

Click the +/- (accordion) symbol below to display relevant details in collapsible content format

This level of study in Excel Macros with VBA (2010/2013/2016) has a total duration of 30 hours of Virtual Classroom Training:

Level Total weeks Hours per week Days Timings
Intermediate to Advanced 5 6 Mondays,
Tuesdays and Wednesdays

7:00-9:00 UAE time

15:00-17:00 UAE time

*Days/ timings: There are 2 different timings for you to choose to join a batch of your preference. A batch timing once selected by you will be permanent with no option of switching to the other.

  • The language of instruction for this course is English.
  • The Teacher is fluent in English, Hindi, Marathi and Malayalam.
  • The Teacher will communicate with students in English only and all activities including assessments will be conducted in English.

Participants attending this training should be proficient with Advanced Microsoft Excel.

They need to have a laptop with MS Office 2010 or above installed on it.

On the completion of the Excel Macros with VBA Course, students will be able to do
Introducing Macros
  • Add the Developer tab
  • Recording a macro
  • Recording a macro with relative references
  • Placing a macro on the Quick Access Toolbar
  • Macro Security settings
Customizing VBA environment Visual Basic Editor
  • Toolbar
  • Code window
  • Immediate window
  • Project window
Customizing VBA environment
  • Editor tab
  • Auto Syntax check option
  • Require variable Declaration option
  • Auto List Members option
  • Auto Indent Setting
VBA fundamentals
  • Objects
  • Collections
  • Properties
  • Methods
  • Object Browser
Inserting/Reading data from Excel using VBA
  • Range property
  • Cells property
  • Offset property
Programming fundamentals
  • Variables
  • Data Types
  • Constants
  • Declaring and scoping variables
  • Strings
  • Date
  • Arrays
  • Object variables
  • User Defined Data Types
  • Built in functions
  • With – End With
Loops and Constructs
  • If Then Construct
  • Select Case
  • For Next Loops
  • For Each
  • Do while Loops
  • Do Until Loops
VBA Sub Procedures
  • Declaring Sub Procedure
  • Calling and scoping procedure
  • Executing Sub Procedures
  • Passing arguments to procedures
  • Error handling
Function Procedures
  • Scoping Function Procedures
  • Executing Function Procedures
  • Array Argument
  • Debugging Function Arguments
Events
  • Types of Events
  • Event Handler Procedures
  • Workbook Events
  • Worksheet Events
User Forms
  • Custom Dialog boxes
  • Built-In Dialog Box
  • Creating a User Form
  • Adding Controls

Different learning material will be used:

  • Live Classroom Training

  • Practice Worksheets

  • Final assessment will be in the last session of the course.

  • ‘Course Completion Certificate’ will be sent to students within 2 weeks of successful completion of the course.

ENQUIRE ABOUT THIS COURSE
Buy Now
ENQUIRE NOW
ENQUIRE NOW
Previous Speak German- Beginner Level Next Microsoft Office (MS Word, Excel, PowerPoint & Outlook) – 2010/2013/2016