Visual Basics Using Excel

Guest Profile: Amit Kumar Singh is a seasoned engineering leader with over 16 years of experience in
building and managing complex e-commerce and fintech products. With a strong background in design
and architecture, Amit has led high-performance teams of engineers and effectively managed projects in
fast-paced environments. His expertise spans across various domains, including e-commerce, fintech,
and digital transformation. Amit showcases his ability to adapt and excel in diverse environments as an
exceptional technical leader.

Qualification- Motilal Nehru National Institute of Technology, MCA
Experience- Analyst, Senior Technical Consultant, Technical Architect, Software
Development Manager.

Introduction:
The guest lecture on “Visual Basics Using Excel” was held on 6 th April 2023. The guest lecture
has been organized by Program Manager of MBA, Mr. Madan Gowda to provide the knowledge
of Visual Basics Using Excel. The students of Business Analytics, HR and Marketing of MBA
Department attended the lecture.


Overview:
The lecture began with an introduction to the basics of Visual Basic for Applications (VBA)
programming language, highlighting the importance of automating repetitive tasks in Excel
spreadsheets. The speaker then demonstrated how to open the VBA editor and create a new module to
write VBA code.

Main Points:
The lecture covered the following main points:

Understanding VBA syntax: The speaker explained the basic syntax and structure of VBA code,
including variables, data types, and operators. The attendees were also introduced to the object model
of Excel and the use of objects, properties, and methods in VBA code.
Recording and editing macros: The speaker demonstrated how to use Excel’s built-in macro recorder
to record a series of actions, and how to edit the resulting VBA code to modify or enhance the
recorded macro. Attendees learned how to assign a macro to a button or keyboard shortcut to run it
quickly and easily.
Writing custom VBA code: The speaker showed how to write custom VBA code to perform specific
tasks in Excel, such as formatting cells, manipulating data, and generating reports. Attendees were
introduced to various programming constructs, such as loops, conditional statements, and functions,
and how to use them in VBA code.
Using the Speak Excel feature: The speaker demonstrated how to use the Speak Excel feature in
VBA code to have Excel speak the contents of a cell or range of cells. This is a useful feature for
visually impaired users, or for those who prefer to have data read aloud.
Debugging and error handling: The speaker emphasized the importance of debugging VBA code
and handling errors that may arise during execution, and demonstrated various techniques for doing so.
Attendees learned how to use the Debugging tools in the VBA editor, how to set breakpoints, and how
to handle errors gracefully.
Advanced topics: The lecture covered some advanced topics, such as using arrays and collections in
VBA code, working with external data sources, and interacting with other Office applications using
VBA code.
Key Takeaways:
The lecture provided attendees with the following key takeaways:
 Understanding of the basics of VBA syntax and structure, and the object model of Excel.
 Knowledge of how to record and edit macros in Excel, and how to assign them to buttons or
keyboard shortcuts.
 Ability to write custom VBA code to automate tasks in Excel, using programming constructs
such as loops, conditional statements, and functions.
 Understanding of how to use the Speak Excel feature in VBA code, to have Excel speak the
contents of cells or ranges of cells.
 Techniques for debugging and error handling in VBA code, using the Debugging tools in the
VBA editor and handling errors gracefully.
 Familiarity with some advanced topics in VBA programming, such as using arrays and
collections, working with external data sources, and interacting with other Office applications.

Conclusion:
Overall, the lecture provided a comprehensive overview of Visual Basics using Excel, Macros, and
Speak Excel. Attendees gained a solid foundation in VBA programming, and learned how to automate
tasks in Excel using macros and custom VBA code. The speaker was knowledgeable and engaging,
and the audience had several opportunities to ask questions and receive feedback.

About ISBR: ISBR Business School, Bangalore-based, Top Class B School for PGDM or MBA, Consistently ranked as best B School in India, AICTE-CII Platinum Category, with multiple specializations