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
Документы и презентации в LaTeX (Introduction to LaTeX)Higher School of Economics via Coursera Excel aplicado a los negocios (Nivel Avanzado)
Universidad Austral via Coursera Excel Skills for Business: Intermediate II
Macquarie University via Coursera Diseño de sistemas de información gerencial para intranet con Microsoft Access
Universidad del Rosario via edX Основы разработки на C++: красный пояс
Moscow Institute of Physics and Technology via Coursera