YoVDO

Excel Avanzado

Offered By: Miríadax

Tags

Microsoft Excel Courses Data Analysis Courses Data Management Courses Pivot Tables Courses Macros Courses VBA Programming Courses

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