Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
18 Hour(s) 55 Minute(s)
Language
English
Rating
Course Overview
Improve your knowledge in Excel VBA from real case studies of projects of my students and from my works
In this course, I have reproduced real development workflows used to design, build, and test practical solutions in Excel VBA based on both my professional experience and the projects developed together with my students.
This course represents a curated collection of high-value solutions and real use cases created and refined over the past three years. Instead of focusing only on theory, you will learn through practical examples inspired by real business challenges, allowing you to understand not only how VBA works, but also how to apply it effectively in real scenarios.
Throughout the course, new students will learn how to use Excel VBA to automate complex processes and significantly improve productivity, including how to:
Import data from external workbooks using OLE DB connections
Use VBA dictionaries to efficiently import and export data between worksheets, workbooks, and structured tables
Generate, format, and fully customize Excel tables programmatically
Create and customize complex and dynamic charts automatically
Generate dynamically created named ranges for scalable solutions
Assign and manage Excel formulas directly through VBA
Format borders, layouts, and colors of ranges automatically
Create reusable, parameterized, and generic VBA routines
Implement structured error handling for reliable applications
Define and automate data validation rules
Build advanced conditional formatting using complex formulas
By the end of this course, students will be able to design and build their own Excel-based applications using VBA, automate repetitive workflows, and generate professional automatic reports ready for real business environments.
This course is ideal for professionals, analysts, engineers, and students who want to move beyond basic Excel usage and start creating powerful automation tools that save time, reduce errors, and increase efficiency.
Course Content
- 12 section(s)
- 174 lecture(s)
- Section 1 Introduction
- Section 2 Summary of Excel VBA
- Section 3 A reporting system for a sales person using VBA dictionaries
- Section 4 A complex reporting tool including dashboards, charts and calculation sheets
- Section 5 Import data and formats of a set of Excel tables into a new workbook
- Section 6 Generate and customize the Dashboard (Part I)
- Section 7 Generate the Calculation parts for an Excel Dashboard and report in VBA
- Section 8 Complete the data table with references and conditions from other sheets
- Section 9 Import Multiple Excel Tables using dictionaries
- Section 10 Generate an Excel dashboard with navigation fields and charts with VBA
- Section 11 Enhance the dashboard with special effects
- Section 12 An Asset Management App in VBA
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
Reviews
-
RRajesh Majumdar
In every course there is many things to learn.... yes it's a good course only issue is sound of video voice is low.
-
CClaudia Eberle
I am very disappointed about this course. The instructor seems to have excellent knowldedge about VBA but he is not able at all to transmit the knowledge to the student. He does not explain the projects properly and just goes on coding without explaining properly the aim of each step. I lost track quickly and I don't see the point of just coding along with the lessons without understanding what I'm doing. The speech delivery of the instructor is very poor and it is sometimes hard to understand what he is saying as it seems that he is not speaking to the student but rather mumbling to himself. It is also difficult to read the code on the screen. The course is not a pleasant experience and needs improving. I have requested a refund.
-
PPushpendra Singh
The way of explaining is awesom
-
HHenli
Hi, I can see that the instructor has a lot of knowledge but the way he presents this course is so disappointing. He doesn't explain anything that he is doing and it sounds like he is talking to himself. Such a pity!
