3.5 out of 5
3.5
20 reviews on Udemy

Excel VBA – Learn from real case studies and projects

Improve your knowledge in Excel VBA from real case studies of projects of my students and from my works
Instructor:
Daniele Protti
349 students enrolled
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

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

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.5
3.5 out of 5
20 Ratings

Detailed Rating

Stars 5
6
Stars 4
7
Stars 3
2
Stars 2
1
Stars 1
4
30-Day Money-Back Guarantee

Includes

19 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion
Excel VBA – Learn from real case studies and projects
Price:
$158.98 $119

Community

For Professionals

For Businesses

We support Sales, Marketing, Account Management and CX professionals. Learn new skills. Share your expertise. Connect with experts. Get inspired.

Community

Partnership Opportunities

Layer 1
samcx.com
Logo
Register New Account
Compare items
  • Total (0)
Compare
0