Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Miríadax

Excel Avanzado

via Miríadax

This course may be unavailable.

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.

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

Reviews

Start your review of Excel Avanzado

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.