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
Requirements
Basic knowledge of Microsoft Excel
Basic knowledge of Excel VBA
Description
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
Who this course is for:
Who already knows how to use Excel and create VBA macros

Homepage

https://www.udemy.com/course/excel-vba-learn-from-real-case-studies-and-projects/

Related Downloads :

{related-news}