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
Master all the MS Excel Macros and the basics of Excel VBAUdemy Mastery Courses - Microsoft Excel, Word, Unlock Macros & VBA
Udemy Master Microsoft Excel Macros and Excel VBA
Udemy Microsoft Excel for Scientists and Engineers
Udemy Visual Basic for Excel - Microsoft VBA Excel Tutorial
Udemy