Rating 3.6 out of 5 (21 ratings in Udemy)
What you'll learn- Their knowledge in Excel VBA will improve
- They will understand how to apply thier VBA knowledge to their projects
- They will be able to create Applications with VBA in Excel
- They will be able to import, export and format data into Excel tables
- They will improve their knowledge in using VBA to generate Excel formulas and references
- They will improve their knowledge in using VBA to apply conditional formatting
- They will improve …
Rating 3.6 out of 5 (21 ratings in Udemy)
What you'll learn- Their knowledge in Excel VBA will improve
- They will understand how to apply thier VBA knowledge to their projects
- They will be able to create Applications with VBA in Excel
- They will be able to import, export and format data into Excel tables
- They will improve their knowledge in using VBA to generate Excel formulas and references
- They will improve their knowledge in using VBA to apply conditional formatting
- They will improve their knowledge in using VBA to exchange data using VBA dictionaries
- They will improve their knowledge in using VBA to import/export data with OLE DB
- They will improve their knowledge in using VBA to generate, access, format Excel tables
- They will improve their knowledge in using VBA to generate, format and customize Excel charts
- They will improve their knowledge in using VBA to add ActiveX objects to Excel sheets and assign macros
DescriptionIn this course I have reproduced the works to develop and test solutions in VBA for some of my works and of my students' projects.
This is a collection of great works we did together in the last 3 years.
In details new students can learn how to use Excel VBA to:
- import data from other workbooks using OLE DB
- use VBA dictionaries to import/export data between worksheets, workbooks and tables
- generate, format and customize Excel tables in VBA
- generate and customize complex charts
- generate dynamically created named ranges
- assign Excel formulas to ranges
- format borders and colors of ranges
- create reusable, parametrized, common and generic routines
- handle errors
- define data validations
- create complex conditional formatting formulas
At the end students will be able to create their own Application using Excel and VBA and generate automatic reports
