Loading
Loading Events

« All Events

  • This event has passed.

VBA in Excel Training by Bob Umlas, MVP

November 21 @ 5:00 pm - 8:00 pm UTC+0

PKR5000

VBA IN EXCEL TRAINING COURSE

Register Now | Pay Now

Visual Basic for Applications (VBA), commonly known as Macros are most powerful tool to automate the Excel’s boring and repetitive work without human intervention. In this Training we will cover a wide range of concepts and techniques which are applicable to most daily spreadsheet task.

What you will learn:

  • Recording macros
  • Exploration of the VBE (Visual Basic Environment — what are we looking at)
  • Messaging the user
  • Asking the user for input
  • examining the Immediate window
  • The Range object — most common thing to reference
  • Scoping variables
  • Practical examples
  • Adding a record to a form
  • Creating User-defined functions
  •  Structure of:
     Case
     If/Then/Else
     And/Or
     Loops
     While, Do, Loop, For/Next
  • Adding to a database
  • Event coding
  • User forms

When & Where

• Saturday, November 21, 2020
• From 5:00 to 8:00pm (PST) GMT+5
• From 4:00 to 7:00pm (UAE Time)
• From 3:00 to 6:00pm (KSA Time)

Program deliverables

• Live interactive 03 hours Training
• Practical Training Material
• Comprehensive Examples
• E-Certificate

Program fee:

Training Fee: PKR 5000 or USD 30

Discount:

10% discount on training fee for member of IFA, IPA, ICAP, ICMPA, PIPFA, ACCA, CIMA or group of 3 participants
Program schedule

Trainer: Mr. Bob Umlas, MVP from New York, USA

Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1993-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called “Maximizing Excel Development Using Array Formulas” at Microsoft’s Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City. He has also led two Excel sessions (Array Formulas, Tips & Tricks) at the Advisor’s Developer Conference in San Francisco in February 1998.

He has led 5 sessions at an Excel User Conference in Atlantic City on Tips & Tricks, Array formulas, VBA, Formulas, and Userforms. He has led at about 7-8 of these user conferences since 2005.
He is also the author of “This isn’t Excel, it’s Magic!” which is available from http://www.iil.com/publishing as well as from Amazon.com. (There are 2 versions of this book: One for Excel 2003, and one for Excel 2007). Another book, “Excel Outside the Box” is available from http://www.mrexcel.com and is for the very advanced Excel user. Another book, “More Excel Outside the Box” is also available from mrexcel.com. Lastly, published October 17 for Kindle, is “Excel Preschool: Finally Understanding what Excel is all About” – a book for the very beginner!

He has co-authored several chapters in many books on Excel and has done the technical editing for 4 new books for Excel 2019, as well as about 12 books for prior versions of Excel.

Register Now | Pay Now

Details

Date:
November 21
Time:
5:00 pm - 8:00 pm UTC
Cost:
PKR5000
Event Category:
Website:
www.lexicon.edu.pk

Organizer

LEXICON
Email:
info@lexicon.edu.pk
Website:
www.lexicon.edu.pk
Shopping Basket
Open chat