Excel VBA for Beginners
What you'll learn
- Register and reuse VBA macro in Excel
- Create your own VBA macros in Excel
- Understand the VBA code in Excel macros
- Generate automated reports in Excel with VBA
- Manipulate data in Excel with VBA
- Format data and worksheets in Excel with VBA
- Import and export external data from files to and from Excel using VBA
- Understand and use the VBA editor in Excel to write macros
- Understand the concepts of subroutines, functions, constants and variables in VBA for Excel
- Manage errors in VBA
- Understand and use dialog boxes e.g. msgbox and inputbox
- create interactions between worksheets in Excel using VBA
- basic knowledge of Microsoft Office products
- be familiar with computers
I created this corse since I have experienced during my live trainings and even from my students of other VBA courses that I released on the Internet, that most of my students are not IT-skilled people. They are just users of Excel and want to go beyond the basic functionalities of Excel and create automated report or automate daily tasks.
For this reason I have created a course with the right pace to make it clear to anyone.
In this course I start explaining what VBA is and why VBA. For example, if you are an user of Excel, e.g. in the Accounting Department, what VBA is and why you need it.
For this reason it is important to understand first of all the concept of object oriented programming and explain how Excel is an application structured in objects whose properties and actions/events can be managed, manipulated and updated using VBA.
I start with an overview of the Developer ribbon, which is the menu section where to record macros, execute macros, access the VBA editor and much more.
I will show and explain the structure of a VBA object and how to record a VBA macro.
Once recorded, I will explain how to read and interpret a VBA code and how to modify it for your goals.
I will show how to make the user interact with the data in the worksheets using userforms and how to format the reports automatically.
I have organized this course focusing on an example which is an Excel file or workbook composed of more worksheets.
At the end the user will be able to exchange data between the worksheets and import/export them to external text and binary files.
Begin with VBA: why VBA, understand the VBA editor, learn how to record and execute a VBA macro, learn to read and interpret the VBA code, modify the VBA code, modify the macro security level.
Understand the VBA code: the Excel objects and how and where to manage/edit their properties and actions/methods based on their events
The VBA project: what is a VBA project, how it is structure, the components, where to insert your code, how to set the properties of the objects
The VBA programming principles: variables, constants, functions and subroutines. What is the difference between private and public. What is a module. What are the variable types.
Interact with the data: read/retrieve data with loop instructions. Select data using conditional instructions. Strings and string functions.
Interact with the user: exchange data and information using userforms, msgboxes and inputboxes. Understand the VBA control objects on userforms.
VBA commands on worksheets: interact directly on a worksheet using control objects and directly on it and how to trigger actions and events.
Structure of data: understand arrays and their size, how to populate arrays and manage their size. The Type data structure to save data into records. Collections.
Manage external files with VBA: read and write to text and binary files.
Errors: manage errors caused by the interection of the user with Excel.
At the end you will find some exercise to improve your skill and verify your knowledge in VBA.
Who this course is for:
- familiarity with the function and basic use of the software
- Who is familiar with computers and the Internet
- familiarity with Windows or Mac computers
- Who owns a copy of Microsoft Office with Excel
I have 20+ years experience in IT project management, software development and software architecture.
I have led several teams of software developers as project manager, quality manager and as team leader in different companies and different countries in sectors e.g. telecommunication, research & development, travel business, Internet marketing and Internet business, consultancy and services.
I have been responsible to collect the requirements of projects, applications and processes, design the databases and specify the final objects.
During my career I have accumulated a lot of experiences dealing with processes of any kind and the need to define the tools to manage them and collect the information.
I have organized all my experiences in courses which are not only a list of functions and methods but contain also my practical experiences and considerations about how to cope with the different situations and which solutions to suggest.