Excel VBA - Learn from real case studies and projects

Excel VBA - Learn from real case studies and projects

In 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

Improve your knowledge in Excel VBA from real case studies of projects of my students and from my works

Url: View Details

What you will 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

Rating: 3.6

Level: Intermediate Level

Duration: 19 hours

Instructor: Daniele Protti