Instructor led onsite VBA Class offers Excel classes in NYC for beginners, advanced Excel training, and Excel VBA training courses. Email or Call VBA Class to learn more about Excel.
VBA Consultant New York
Email us at new_york@Qcfinance.in / (929) 356-5046
We offer onsite lessons in NY and have tutors who are working with our team to be available in New York City, including Manhattan and also uptown.
VBA Class with no Prerequisites
We also offer a VBA Class online …
Excel Visual Basic Applications Class objectives:
Macros: Strengths and Weaknesses
How to Debug and Fix Macros, How to Handle Errors when they come
How to Utilize Variables and Arrays
How to Write Programs With the Visual Basic Editor
How to Use If/Then and For/Next Conditional Control Structures to Loop from Row to Row and Sheet to Sheet and Make Decisions
How to Call Excel Functions and Write New Functions
How to Create User Forms and Call Excel Dialogs
Helpful Resources And Much More
VBA Private Training
VBA Private Training We recognize that many clients have one-time projects for which they need specific assistance. Excel Training NYC offers private VBA training upon request. Hourly rates start at $30 (mixed of online and on location). More hours would qualify for a discount! These are mixed rates for onsite and online mix in New York / Manhattan areas.
Class Tags:
New York excel
New York visual basic
Union Square classes
Manhattan classes
We Serving New York and surrounding area.
A part of classes is taken onsite at a location in New York, a part online with the help of offshore team, and most of assignments are executed on your own system.
Locations that you are request are:
Mid Town, New York
Lower Mahatten, New York City
East Village New York City
Garment District in New York City
Offerings: I might help you to outsource some of the automation, programming and analytical tasks to Qcfinance India (I am one of the co-founders of the company since 2012). QCFinance helps startups with limited resource to be more efficient by providing solution aimed to enhancing valuations of small companies (5-20). Since I am in NYC, I will make sure that you are completely satisfied, and since I was a part of the team I know the team in India very well. In India, I have worked in Captives and 3rd Party service providers for various banks like: Deutsche bank (Index quant team), Wells Fargo (CIB), XL Catlin Investments (New York team).
Demo Pricing: You may even outsource a very small pilot project / training assistance @ $30-50/hour to start with! With mix of training and project outsourcing, you can make your employees more productive, also the automation of mundane task will enhance the value of your startup! All top investment banks and companies today have their offices in India hence India has become an important place to do business more than ever.
I have a strong belief that once you understand more about the Indian outsourcing industry you will have a better chance of using it to add value to your company.
How Qcfinance.in work with small companies:
How many times have you seen problems or opportunities for improvement in your workflow and promised to fix them if you only had the time or if you only could train your employees with such expertise?
Unforeseen, undocumented, forgiven, hidden cost of issues like below are bringing your valuations down:
Poorly-understood, legacy framework mostly into excel--dilapidated on unknown, unstated assumptions
Slow process of calculations
Un-scalable excel models that are difficult to maintain, improve, replicate or extend
Increased pressure, requiring added reporting and enhanced auditing
Lack of in-house research resources for SQL and R -- both of which are open source (free -- with no extra burden)
Over-reliance on external novel untested software from vendors
QCFin provide quant automation and programming solutions for removing tech hurdles, enabling financial and consulting companies to create more value in their systems and employers which increases the valuation for the firm.
Technologies: MATLAB, R, VBA, SAS, Latex, SQL others.
Analysis: From simple office tasks like automation of excel and latex reports to more complex tasks like Monte carlo simulations
Sample course:
LEVEL 1: EXCEL FUNCTIONS
1.1: INTRODUCTION
1.2: WORKSHEET FUNCTIONS
1.3: MATH/LOOKUP FUNCTIONS
1.4: COMPOUNDING
1.5: INTEREST RATES
1.6: DISCOUNT FACTORS
1.7: BOND PRICING
1.8: OFFSET
1.9: PIVOT TABLES
1.10: HOMEWORK PREP
LEVEL 2: VBA BASICS
2.1: SUBS/FUNCTIONS
2.2: VARIABLES
2.3: VECTORS
2.4: LOOPS
2.5: BOND PRICING
2.6: STATEMENTS
2.7: LINEAR INTERPOLATION
2.8: LINEAR INTERPOLATION - CODE
2.9: FORWARD RATE CURVE
2.10: FORWARD RATE CURVE – CODE
2.11: HOMEWORK PREP
LEVEL 3: OPTION PRICING
3.1: OPTION PAYOFF MODEL
3.2: BINOMIAL ASSET PRICING MODEL
3.3: BINOMIAL ASSET PRICING MODEL - CODE
3.4: BLACK SCHOLES
3.5: HOMEWORK PREP
LEVEL 4: CLASSES
4.1: CELL VS RANGE
4.2: USER DATA TYPES
4.3: COLLECTIONS
4.4 CLASSES
4.5: PORTFOLIO ANALYSIS
4.6: VALUE AT RISK
4.7: HOMEWORK PREP
LEVEL 5: DATA STRUCTURING
5.1: SELECTION
5.2: CHARTS
5.3: FILE MANIPULATION
5.4: USERFORMS
5.5: PIVOT TABLES - CODE
5.6: SQL IN VBA
5.8: INTERVIEW TIPS
5.9: CASE STUDY
https://youtu.be/1Rk6FmpqVk0
https://youtu.be/z-EuWqEWVH8
http://www.tutoringhelp.org/tutors/NY/New-York/357241
Importing csv:
http://www.homeandlearn.org/open_a_text_file_in_vba.html
Charts:
http://www.homeandlearn.org/vba_charts_sheets.html
List of Files:
https://trumpexcel.com/list-of-file-names-from-a-folder-in-excel/
Workbook play:
https://analysistabs.com/excel-vba/open-close-existing-workbook/
Option Explicit:
https://wellsr.com/vba/excel/vba-option-explicit/
Screen Updating:
https://stackoverflow.com/questions/38122480/application-screenupdating-in-subroutine-called-within-subroutine
Run when worksheet is activated:
https://ccm.net/faq/5675-excel-run-a-macro-when-opening-a-sheet
Workbook open then activate:
https://www.mrexcel.com/forum/excel-questions/39172-auto-run-macro-when-open-worksheet.html
