Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
Data management and graphics, databases, pivot tables, and advanced array formulas, Solver, sensitivity analysis and scenario management, forms and templates, automate processes by creating macros, introduction to programming in Visual Basic for Applications ( VBA).
Knowledge required:
Initial knowledge of Excel. No previous knowledge required of Macros.
Module 0: Introduction
Module 1: Previous concepts
Module 2: Data management and graphics
Module 3: Customizing Excel
Module 4: Databases
Module 5: Advanced Formulae 1
Module 6: Advanced Formulae 2
Module 7: Data Analysis
Module 8: Dynamic Tables 1
Module 9: Dynamic Tables 2
Module 10: Creating Macros
Module 11: VBA Programming 1
Module 12: VBA Programming 2
Closing the course
Adolfo Aparicio
Get personalized course recommendations, track subjects and courses with reminders, and more.
