Financial Data Analytics with Microsoft Excel & VBA is unfortunately unavailable

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

Special School Offer!
10% Off Extensive Business Solutions Corp. Gift Cards! Learn More >

Financial Data Analytics with Microsoft Excel & VBA

at Extensive Business Solutions Corp. - Midtown East

(16)
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.

Location:
Midtown East, Manhattan
845 3rd Ave 6th Fl
Btwn E 51st & 52nd Streets
New York, New York 10022
(Map)
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. (16)

(16 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.
Special School Offer!
10% Off Extensive Business Solutions Corp. Gift Cards! Learn More >

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

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

90 Top Choices

Virtual Excel for Beginners

This class is temporarily being offered remotely.

at Donna Sanabria - Virtual Learning via Zoom

Have you been wanting to learn Excel, but never had time for a long training course?  Do you have a project that requires Excel, but don’t know how to get started?  Are you looking to add another skill to your resume and give yourself a competitive advantage?  In this course you will learn how to get started and gain confidence with...

Thursday Aug 27th, 6pm - 10pm Eastern Time

Virtual Intermediate Excel

This class is temporarily being offered remotely.

at Julie Khidekel - Virtual Learning via Zoom

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Wednesday Aug 12th, 6:30pm - 9:30pm Eastern Time

Excel for Mac Level 1

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets...

Sunday Aug 16th, 10am - 5pm Eastern Time

Excel for Business Fundamentals - Level 1

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Sunday Aug 16th, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Thursday Aug 20th, 10am - 5pm Eastern Time

Advanced Excel for Business - Level 3

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Thursday Aug 13th, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

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

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Monday Aug 17th, 6pm - 10pm Eastern Time

  (2 sessions)
$169

2 sessions

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

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...

Wednesday Aug 19th, 10am - 6pm Eastern Time

Introduction to Excel - Learn Basics

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Thursday Aug 13th, 8:30am - 12:15pm Central Time

$164.98

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Sep 3rd, 11am - 5pm Eastern Time

Mastering Excel – Advanced

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Friday Aug 14th, 8:30am - 12:15pm Central Time

$219.99

Excel Power BI for Desktop: Data Summarization

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Full Course Name: "Excel Power BI for Desktop: Data Summarization and Visualization" In this one-day Excel for Windows session, you will learn how to use Microsoft's free Power BI for Desktop app to produce stunning interactive summarization reports full of modern charts/visuals. In class, you will connect to external data sources, create relational...

Thursday Aug 13th, 9am - 4pm Pacific Time

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Sep 3rd, 8am - 2pm Pacific Time

Mastering Excel - Intermediate

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Thursday Aug 13th, 1pm - 4:30pm Central Time

$164.99

Microsoft Excel Level 1

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

Monday Aug 17th, 9am - 4:30pm Pacific Time

VBA Excel - Introduction to Macros & VBA

This class is temporarily being offered remotely.

at Chicago Computer Classes - Online Online, Chicago, Illinois 00000

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

Friday Aug 14th, 1pm - 4:30pm Central Time

$219.99

Microsoft Excel Level 2

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

Tuesday Aug 18th, 9am - 4:30pm Pacific Time

Microsoft Excel Level 3

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Wednesday Aug 19th, 9am - 4:30pm Pacific Time

Excel Dashboard Reporting: Intro to Dashboards ..

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and troubleshooting skills. The last thirty minutes of the class...

Saturday Aug 15th, 9am - 4pm Pacific Time

Financial & Statistical Applications in Microsoft Excel

This class is temporarily being offered remotely.

at Baruch College - CAPS - Murray Hill 10010

This course is designed for Excel users who would like develop their quantitative skills for managerial decision making. Students will learn how to use present value, Internal Rate of Return, Standard Deviation and more. It features a mix of case studies, individual exercises and group activities. This course is appropriate for all students who wish...

Saturday Aug 15th, 9:30am - 5:30pm Eastern Time