Excel Avanzado
Offered By: MirÃadax
Course Description
Overview
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.
Syllabus
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
Taught by
Adolfo Aparicio
Related Courses
Mastering AWS CloudFormationA Cloud Guru Advanced CloudFormation: Macros
Amazon Web Services via AWS Skill Builder Advanced CloudFormation: Macros (French)
Amazon Web Services via AWS Skill Builder Advanced CloudFormation: Macros (German)
Amazon Web Services via AWS Skill Builder Advanced CloudFormation: Macros (Indonesian)
Amazon Web Services via AWS Skill Builder