Get 20% discount

Microsoft Excel Macro & VBA Made Easy

  • Date : Friday, February 16, 2018
  • Duration : Day(9.30 AM-5.30 PM)
  • No. of Classes/ Sessions : Day Long
  • Last Date of Registration : 14 February, 2018
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 20% Discount at bKash or Online Payment

Introduction

Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis, reporting, tools and applications are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.

How participants will benefit after the course

HANDS ON EXPERIENCES. Most widely practiced Excel topics are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the required Excel functionalities in course will ensure participants high performance in their career and academics.

Methodology

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.

Contents of Training:

Session: 1 (Day 1)
BREAKING THE EXCEL FEAR

Macros & VBA – Automate repetitive tasks
• Working with Macros
o Difference between Macros and VBA
o Record and run a macro.
o Understand and edit simple recorded macros
o Run a macro by using a shortcut key
o Creating and managing PERSONAL.XLSB
o Running Macros using Buttons
o Running Macros When a Workbook Is Opened
o Manage macro security
o Trusting Macro-enabled Workbooks

• Visual Basic Editor (VBE)
o Activating the VBE
o Understanding VBE components
o Working with the Project Window
o Adding a new VBA module
o Removing a VBA module
o Exporting and importing objects
o Working with a Code Window
o Minimizing and maximizing windows
o Creating a module
o Getting VBA code into a module
o Using the General tab
o Using the Docking tab

Session: 2 (Day 2) • Worksheet Bars & Buttons
o CheckBox
o ComboBox
o CommandButton
o Image
o Label
o ListBox
o OptionButton
o ScrollBar
o SpinButton
o TabStrip
o TextBox
o ToggleButton
• VBA Comments
• Modules, Function and Subroutines

o Modules
o Difference Between Subroutines and Functions
o Writing a Simple Subroutine
o Writing a Simple Function
o Public and Private Functions and Subroutines
o Argument Data Types
o Optional Arguments

Session: 3 (Day 3)
• Excel Object Model

o Main Objects
Workbook Object
Worksheet Object
Range Object
o Properties
o Methods
Session: 4 (Day 4)
o Events
• Understanding event sequences
• Disabling events
• Entering event-handler code
Workbook-Level Events
• Open event
• Activate event
• SheetActivate event
• NewSheet event
• BeforeSave event
• Deactivate event
• BeforeClose event
• Worksheet-Level Events
• Change event
• SelectionChange event
• Application Events
• MsgBox & Input Box

Session: 5 (Day 5)
• VBA Programming

o Variables
• Implicit Declaration
• Explicit Declaration
• Scope and Lifetime of Variables
• Local Variables
• Module-Level Variables
• Global Variables
o VBA Data Types
• Numeric Types
• String Types
o Constants
o String Manipulation
• Concatenation
• Splitting Strings
• Searching Strings
o Program Flow & Decisions Looping
• GO TO Statement
• IF THEN Statement
• SELECT CASE Statement
o Looping
• For..Next Loops
• For Each Loops
• Do Until Loops
• Early Exit of Loops

Session: 6 (Day 6)
o Operators
 Comparison Operators
 Concatenation Operator
 Logical Operators
• And Operator
• Not Operator
• Or Operator
o Functions
 Date and Time Functions
• Now
• Date
• Time
• DatePart
• DateSerial
• Day
• Month
• Year
 Conversion Functions
• CStr
• CInt
• Debugging
o Types of Errors
 Compile Errors
 Runtime Errors
 Logic Errors
o Design Time, Runtime, and Break Mode
o Breakpoints
o Using Stop Statements

Session: 7 (Day 7)
• Error Handling

o The Resume Statement
o Implications of Error Trapping
• User Form Bars & Buttons
o CheckBox
o ComboBox
o CommandButton
o Image
o Label
o ListBox
o OptionButton
o ScrollBar
o SpinButton
o TabStrip
o TextBox
o ToggleButton

Session: 8 (Day 8)
• UserForm

o When to Use a UserForm
o Inserting a new UserForm
o Adding controls to a UserForm
o Changing properties for a UserForm control
o Viewing the UserForm Code window
o Displaying a UserForm
o Using information from a UserForm
• Macro & VBA Examples & Discussions

Related Courses

Md. Shahadat Hossain
  • 25 Jan - 27 Feb 2018

100% online job placement and online earning in Digital ...

IT
Samiul Huq
  • 26 - 27 Jan 2018 (2 Days Long)

Participants will experience a first look of the latest ...

IT
Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 28 Jan - 22 Feb 2018

IT
Mostofa Monower
  • 3 - 17 Feb 2018 (5 Evenings)

This training program builds upon advanced level knowledge ...

IT

Price: Tk. 3,500+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811410862, 01926673095, 01811 487981

workshop@bdjobs.com

Executives, Managers, Teachers, Developers, Students, Researchers and people who use Microsoft Excel for their daily tasks and activities.

Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Abu Shams Mahmood Arif

Associate Director

Mr. Shams has been working in a leading multi-national bank for several years. His extensive work experiences are in Business Analytics & MIS, Process Re-engineering & Automation, Business Research & Development and Project Management.
He has graduated from North South University. After that he completed his MBA. His major accomplishments and contributions are Business Operations Analytics, BOLD (Six Sigma Initiative), CBS (Core Banking System), BEFTN (Bangladesh Electronic Fund Transfer Network). .

He has been a reputed public and corporate trainer for several years on subjects like Management Information System(MIS), Financial Analysis & Modeling, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.
For last several years, he has been a reputed public and corporate trainer on subjects like Business Analytics, Financial Analysis & Modeling, MIS, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.

Courses from this trainer 122

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.