Financial Data Analytics with Microsoft Excel & VBA is unfortunately unavailable

Thankfully we have 54 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Financial Data Analytics with Microsoft Excel & VBA

at Extensive Business Solutions Corp. - Midtown East

(5)
Course Details
Price:
$1,560
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Booking for 6+?
Location:
Midtown East, Manhattan
845 3rd Ave 6th Fl
Btwn E 51st & 52nd Streets
New York, New York 10022
(Map)
Share:
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 1
Teacher: Shivgan Joshi

What you'll learn in this excel class:

Learn how to build quantitative and financial models using Microsoft Excel. Learn to analyze stock data or cryptocurrency/blockchain data.

Topics:

  • What is a Macro?
  • Recording Macros
  • Writing Macros
  • Introduction to VBA for Data Analytics
  • VBA Data Types
  • VBA Editor
  • Formatting worksheets
  • Introduction to variables
  • Decision Control (If, then, else, select)
  • Loops
  • Flow Control
  • Functions
  • Arrays
  • Error handling and debugging
  • Multiple Linear Regression
  • Logistic Regression
  • Monte Carlo Simulation
  • Scrape finance data from the Internet

Prerequisites: Basic knowledge of Microsoft Excel.

Bring your laptop with minimum 8GB ram and Chrome installed on it.

Still have questions? Ask the community.

Refund Policy

  • If you enroll for a course that is scheduled to begin in under 7 days, you must request cancellation via email within the first 24 hours after enrollment in order to receive a full refund - less $50 processing fee.
  • For cancellations, we must receive a cancellation request or notice via email at least 10 days prior to the first scheduled session in order to issue a full refund – less a $50 processing fee.
  • You may also cancel 3 to 10 days prior to the first scheduled session and receive a 50% refund. 
  • If you cancel less than 3 days prior to the first scheduled session you will be required to pay the full amount for the course. 
  • All refunds will be processed within 30 business days. 

Map

Google Map

Extensive Business Solutions Corp.

All classes at this location

Easy access from E, M, 6 train at Lexington 53rd Street, take 3rd Avenue 53rd Street Exit, then 1 min walk towards downtown.

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 15600 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Extensive Business Solutions Corp. (5)

(5 Reviews)
Financial Data Analytics with Microsoft Excel & VBA
Reviewed by Zifan L. on 8/19/2019
loading...

School: Extensive Business Solutions Corp.

Extensive Business Solutions Corp.

EBS Corp aims to empower executive-level, business, and working professionals with our technical
skills development programs. Our programs focus...

Read more about Extensive Business Solutions Corp.

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

54 Top Choices

Beginner Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel Training Course Overview - Level 1 The Career Center, hands on, instructor-led, Beginner Excel training class in New York City will teach you to organize, calculate, analyze, revise, and present your data. Our basic Excel training course is classroom based instruction, with a live instructor, to introduce the basic look and feel...

Friday Sep 20th, 10am - 5pm

Excel for Business Fundamentals

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial...

Friday Sep 20th, 10am - 5pm

Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate Microsoft Excel 2016 Class Overview The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal...

Saturday Sep 21st, 10am - 5pm

Excel Programming with VBA

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The Excel Power Programming with VBA concentrates on how to automate repetitious Excel tasks and reports. By the end of this course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase...

Saturday Sep 21st, 9:30am - 5:30pm

  (2 sessions)
$595

2 sessions

Intermediate Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Intermediate Excel for Business Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database...

Monday Sep 23rd, 10am - 5pm

Microsoft Excel Expert (Level 3)

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Friday Sep 20th, 10am - 6pm

Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Course. The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our Small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.  This is a great course for...

Thursday Sep 19th, 10am - 6pm

Advanced Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Advanced Excel for Business Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions,...

Friday Oct 4th, 10am - 5pm

Excel for Mac Level 1

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Mac covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate...

Friday Sep 20th, 10am - 5pm

Intermediate Excel: Formulas & Functions

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. Given that there lacks an enforceable prerequisite, the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions and...

Wednesday Sep 25th, 6:30pm - 9:30pm

Excel VBA Macros Level I

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel VBA Macros Level I Class Overview Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is...

Saturday Sep 21st, 9:30am - 5:30pm

Excel Training for Beginners

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Students will gain an understanding of the application designed for the user whom is typically intimidated by spreadsheets. They will understand it's unique function from Word and appreciate it's ability to manage data, from the simple to complex. Using their new found confidence, students will begin to explore the formatting and data capabilities...

Wednesday Sep 18th, 6:30pm - 9:30pm

Excel Genius 9 : String Functions and Goal Seek

at The New York Public Library (Tech) - Manhattan 188 Madison Ave, New York, New York 10016

This class will cover how to use functions to modify strings, how to import and scrub data, and how to use goal seek to solve common problems.  We will then bring together all of the skills from previous classes to work on real world projects. Skill required:   Must have taken Excel Genius Classes 1-6, or understand all topics covered...

Thursday Sep 19th, 10:15am - 12:15pm

Free

Excel Bootcamp

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Saturday Sep 28th, 10am - 4pm

Excel 2016: Basic

at Baruch College - CAPS - Murray Hill 17 Lexington Ave, New York, New York 10010

Designed for people who "learned on the job" as well as those who have never used spreadsheet programs before, this course teaches functions and features of Excel 2013 which will enable you to create financial models. After an introduction to spreadsheet terminology, you will learn how to navigate worksheets, enter and edit text, values, formulas,...

Wednesday Sep 18th, 6:15pm - 8:35pm

  (3 sessions)
$265

3 sessions

Intermediate MS Excel 2010

at The New York Public Library - Fordham Heights 310 E Kingsbridge Rd, Bronx, New York 10458

Explore more advanced features of Microsoft Excel 2010. Topics include using formulas and functions, data sorting and conditional formatting.  Skill Prerequisites: Beginners Excel

Tuesday Sep 24th, 1pm - 3pm

Free

Excel VBA Macros Level II

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel VBA Macros Level II Class Overview Our Advanced Excel VBA Training will teach you to automate tasks, and streamline workflow, using Macros. Excel VBA Macros Level 2 is our advanced class, which assumes a familiarity with the basic Macro concepts, introduced in our Level 1 Excel VBA Class. An understanding of the skills...

Sunday Sep 22nd, 9:30am - 5:30pm

Advanced Excel Training

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Sep 30th, 6:30pm - 9:30pm

10 Advanced Excel Charts for Business Presentations

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Appealing, focused, and easy to understand graphics can be the deciding factor on how your presentation is received. In more stark terms, making bad data visualizations can diminish your credibility as a business or data professional. In this bootcamp, we will learn how to create 10 Advanced Excel charts that will take your data analysis presentations...

Saturday Sep 21st, 10am - 4pm

Advanced Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Advanced Microsoft Excel 2016 The Career Center Advanced Excel training in New York City is a hands on, instructor-led class that will teach you more advanced techniques to organize, calculate, analyze, revise, and present your data. This classroom based live Excel class with a live instructor will cover topics such as Using Multiple Worksheet and...

Friday Oct 4th, 10am - 5pm