The Ultimate Excel Programmer Course

Students will learn how to work with VBA, the coding language of Excel. After learning how to use VBA, you'll be capable of creating much more interactive and powerful spreadsheets. Through the course, students will be able to set up automations and macros, which make Excel handle some of the heavy lifting of data entry and allow users to tackle more projects in less time.

Program content -

• Automate and Customize data entry forms
• Choose the right Loop for each task
• Master the CELLS and RANGE objects in multiple scenarios
• Create multiple Variable styles to match your need
• Customize your VBA Editor and understand all the Toolbars and options
• Debug and Troubleshoot code like a boss!
• Record, Modify or Write Macros from scratch
• Make Custom Formulas/Functions on the fly
• Breeze through IF THEN statements and conquer all the Logical Operators
• Batch out inter-active Message Boxes, Input Boxes and give users CHOICES!
• Generate Basic Reports that can be printed
• Add filters to report menus to narrow the records
• Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more.
• Trigger code from a number of different methods – from Clicking on a cell to De-Selecting a worksheet.
• Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc...
• Manipulate User forms for data entry, report generation, editing tables/databases - ALL within your control. Restrict the flow of data OR make the User form(s) responsive, calculating, and INTUITIVE.
• Streamline your work and the work of others.

What you can gain:

• Deep knowledge in Excel
• Automation
• Extending Excel’s usage

Who will benefit:

• This Excel course is for anyone who wants to learn Automation secrets in Excel VBA. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed.
• This course is probably not for you if you’re looking to learn super advanced report authoring, which will be covered in a future course specifically on this topic. We will, however, make sure you know how to make good solid reports from your data and many tricks to make them look good.

Speaker: Harsha Wijesooriya
Chief Executive Officer of Silverlinesoft Pvt LtD

LKR 20,000 for Members, SMS or mail your CIMA Contact ID to +94 77 847 2653 | to receive your coupon within 15 minutes. Apply the coupon at check out to receive the member discount.
LKR 25,000 for Non – Members

If you wish to register only, click here

Only 15 people per batch!

Face-to-Face Sessions - 13th March, 22nd March, 3rd April and 10th April
Online Sessions - 15th March, 20th March, 27th March, 29th March and 5th April
Time: 4pm to 6pm
Venue: CIMA Auditorium 356, Elvitigala Mawatha, Colombo 05

Please find contact details below, with regards to any Omentra Ticketing inquiries.
Name    : Savin Gamalath
Mobile  : +94 77 847 2653
Email    :

Decision Supporter

Verified Supplier
Member Since
January 2018
Credit Card / Debit Card Payment
Bank Transfer


You're reviewing: The Ultimate Excel Programmer Course

How do you rate this product? *

Product Rating