Management
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Excel VBA for Finance

5

(3)

compare button icon

$41

Visit Course

Visit Course

Offer Percent Icon

2 Coupons Available

Login To View All

Course Features

icon

Duration

7.5 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

7.5 hours

Course Description

VBA can be used to automate repetitive tasks in Excel. It is also capable of simplifying long and complex calculations. This course examines the case of a multinational corporation to demonstrate how VBA can be used to create custom functions.

This course will help you master Excel VBA. It is ideal for finance professionals who are familiar with Excel but want to improve their skills. This course will teach you the basics of Excel VBA. It will also show you when and why VBA is used. The foundation will be used to move on to more advanced topics like how to handle exceptions and errors, publish functions and share them with colleagues, setup events and automation, and working with arrays.

Course Overview

projects-img

Personlized Teaching

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Case Studies,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

FMVA® Financial Analyst Certification courses are offered 100% online, allowing you the flexibility to start the financial analyst program anytime and learn when it’s most convenient for youStudents must complete all core and elective courses (14 in total

What You Will Learn

check-card-img

Know when and why to use VBA

check-card-img

Create Custom Formulas in VBA to be used in Excel

check-card-img

Identify coding errors, and manage errors in your data

check-card-img

Publish your custom Functions and share it with your colleagues 

check-card-img

Create Events, and Automate Tasks

check-card-img

Source large datasets

Target Students

check-card-img

Investment Banking and Equity Research

check-card-img

FP&A

check-card-img

Corporate Development

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

$41

Visit Course

Visit Course

Offer Percent Icon

2 Coupons Available
Get upto 10% Discount