Thursday, June 22, 2017

Excel VBA Class in Manahttan

Below are the list of classes I found in Manhattan.

Active - First
421 7th Ave, New York, NY 10001
Phone: 212-537-6125
Address: 421 7th Avenue, 4th Floor

Sam - not small but not that big also
1723 E 12th St, Brooklyn, NY 11229

Moribound 2nd:
545 8th Ave
Suite 1530
New York, NY 10018
Phone: 212-564-2351

Wednesday, June 21, 2017

Quant /Math Tutoring in NYC areas close to Ozone Queens

To be checked: - Closest - down in Brooklyn - Closest - Close to Iskon -  Close

Tuesday, June 20, 2017

Data Science Programs in New York

Python for Data Science & Machine learning
Course by

Skills that you will GAIN
  • Python Programming Language
  • Statistical Hypothesis Testing
  • IPython
  • Hypothesis-testing
  • NetworkX
  • Matplotlib
  • Numpy
  • Pandas
  • Scipy
  • Python Lambdas
  • Python Regular Expressions
Python Basics
An introduction to the basic concepts of Python. Learn how to use Python both interactively and through a script. Create your first variables and acquaint yourself with Python's basic data types.
Learn to store, access and manipulate data in lists: the first step towards efficiently working with huge amounts of data.
Functions and Packages
To leverage the code that brilliant Python developers have written, you'll learn about using functions, methods and packages. This will help you to reduce the amount of code you need to solve challenging problems!
NumPy is a Python package to efficiently do data science. Learn to work with the NumPy array, a faster and more powerful alternative to the list, and take your first steps in data exploration.
Course Syllabus
Section 1: Python Basics
Take your first steps in the world of Python. Discover the different data types and create your first variable.
Section 2: Python Lists
Get the know the first way to store many different data points under a single name. Create, subset and manipulate Lists in all sorts of ways.
Section 3: Functions and Packages & Control flow and Pandas
Learn how to get the most out of other people's efforts by importing Python packages and calling functions.
Write conditional constructs to tweak the execution of your scripts and get to know the Pandas DataFrame: the key data structure for Data Science in Python.
Section 4: Numpy and Matplotlib
Write superfast code with Numerical Python, a package to efficiently store and do calculations with huge amounts of data.
Create different types of visualizations depending on the message you want to convey. Learn how to build complex and customized plots based on real data.
Collection of powerful, open-source, tools needed to analyze data and to conduct data science. Specifically, you’ll learn how to use:
  • python
  • jupyter notebooks
  • pandas
  • numpy
  • matplotlib
  • git
  • and many other tools.
We'll cover the machine learning and data mining techniques real employers are looking for, including:
  • Regression analysis
  • K-Means Clustering
  • Principal Component Analysis
  • Train/Test and cross validation
  • Bayesian Methods
  • Decision Trees and Random Forests
  • Multivariate Regression
  • Multi-Level Models
  • Support Vector Machines
  • Reinforcement Learning
  • Collaborative Filtering
  • K-Nearest Neighbor
  • Bias/Variance Tradeoff
  • Ensemble Learning
  • Term Frequency / Inverse Document Frequency
  • Experimental Design and A/B Tests
Statistics and Probability Refresher, and Python
  • Bayes' Theorem
  • Predictive Models
  • Linear Regression
  • Polynomial Regression
  • Multivariate Regression, and Predicting Car Prices
  • Multi-Level Models
  • Machine Learning with Python
  • Supervised vs. Unsupervised Learning, and Train/Test
  • Using Train/Test to Prevent Overfitting a Polynomial Regression
  • Bayesian Methods: Concepts
  • Implementing a Spam Classifier with Naive Bayes
  • K-Means Clustering
  • Clustering people based on income and age
  • Measuring Entropy
  • Install GraphViz
  • Decision Trees: Concepts
  • Decision Trees: Predicting Hiring Decisions
  • Ensemble Learning
  • Support Vector Machines (SVM) Overview
  • Using SVM to cluster people using scikit-learn
  • User-Based Collaborative Filtering
  • Item-Based Collaborative Filtering
  • Finding Movie Similarities
  • Improving the Results of Movie Similarities
  • Making Movie Recommendations to People
  • Improve the recommender's results
  • More Data Mining and Machine Learning Techniques
  • K-Nearest-Neighbors: Concepts
  • Using KNN to predict a rating for a movie
  • Dimensionality Reduction; Principal Component Analysis
  • PCA Example with the Iris data set
  • Data Warehousing Overview: ETL and ELT
  • Reinforcement Learning
  • Dealing with Real-World Data
  • Bias/Variance Tradeoff
  • K-Fold Cross-Validation to avoid overfitting
  • Data Cleaning and Normalization
  • Cleaning web log data
  • Normalizing numerical data
  • Detecting outliers
  • –Apache Spark: Machine Learning on Big Data
  • Installing Spark - Part
  • Spark Introduction
  • Spark and the Resilient Distributed Dataset (RDD)
  • Introducing MLLib
  • Decision Trees in Spark
  • K-Means Clustering in Spark
  • TF / IDF
  • Searching Wikipedia with Spark
  • Using the Spark 2.0 DataFrame API for MLLib
  • Experimental Design
  • A/B Testing Concepts
  • T-Tests and P-Values
  • Hands-on With T-Tests
  • Determining How Long to Run an Experiment
  • A/B Test Gotchas
Please email to know more information.

Some links from online search:

www.skilledup [dot] com/articles/list-data-science-bootcamps


Sunday, June 18, 2017

Data Analytics courses in NY


This unique comprehensive course provides solid knowledge in Data Analysis and Statistical Software. Through a combination of lectures and exercises, students will learn the key techniques and approaches necessary to be an effective Data Analyst.
Students will learn fundamentals of Data Analysis with Python programming, advanced Excel techniques and VBA macros, basics of SQL Server Databases In the end of the course students will polish their knowledge practicing Data Analysis projects.


1. Statistics for Business. Overview – students will review basic concepts and terminology in Statistics, including: Mean, Mode, Range, Standard Deviation, Normal Distribution, T-Distribution, Hypothesis Testing, Chi Square Test, A-B Testing etc.
2. Python Programming Fundamentals – the module includes following topics: Basic Data Types (Basic Data Types, Variables, Operators, Functions and Modules), Compound Data Types (Lists, Strings,  Sets, Dictionaries), Flow control (Conditional expressions, Loops, Iterators), Working with files, Working with functions, OOP Concepts, Benefits of Standard Library.

3. Data Analysis and Visualization with Python – module provides solid fundamentals of Data Analysis and Data Visualization using Python Libraries: Numpy, Pandas and Seaborn. Students will learn Machine Learning (Linear Regression, Logic Regression etc) and Data Visualization with Histograms, Kernel Density Plots, Box and Violin Plots, Clustered Matrices, Regression Plots etc.

4. Advanced Excel Techniques – in this module students will learn Excel advanced techniques, including Math Functions, Logical Functions, Statistical Functions, Lookup, Sort/Filter Data, Pivot Tables and Pivot Charts, Data Analysis Tools etc.

5. VBA Programming Fundamentals – this module provides VBA Programming fundamentals, including VBA Sub Procedures, VBA Function Procedures, Excel Objects, and using Macros. VBA is simple but powerful scripting language that will help to analyze data, work with objects and develop automated procedures.

6. Microsoft Access. Overview – this module student reviews fundamental functions of Microsoft Access, such as Tables and Datasheets, Lookups, Forms, Reporting etc.

7. Introduction to SQL Server Databases – this module provides students with the understanding of database concepts and the essentials of relational database with the SQL language. Through a series of hands-on activities students will learn data selection and manipulation using multi-vendor compliant SQL syntax and writing simple queries. The module includses: data types, table structure, essential SQL commands, retrieving data, queries, group functions, data manipulation, control transactions etc.

8. Data Visualization with R – in this module students learn fundamental, intermediate and some advanced techniques for Data Visualization and Business Intelligence. The module starts with the following topics: using the R interface/paradigm to create data visualizations, creating basic calculations (arithmetic, custom aggregations/ratios, date math, and quick table calculations), building Dashboards to share visualizations. After this module students will know how to build some advanced chart types and visualization, complex calculations to manipulate data, use statistical techniques to analyze data, implement advanced geographic mapping techniques and visualizations of non-geographic data, prep data for analysis, combine data sources using data blending.

9. Data Analysis Projects Workshop – at the end of the course students will polish their knowledge practicing Data Analysis and Data Visualization with Excel, Access, Python and R.

180 instructor-led class hours, plus labs

Basics of Statistics and Excel. Related education or work experience is a plus.

Recording a Macro
Running a Macro
Running a Macro from the Macros Dialog Box
Creating a Short-cut key to run a macro
Running a Macro with a Shortcut key
Assigning a Macro to a Menu or Toolbar
Editing a Macro with Visual Basic
Programming Tools
The Menu Bar
Using the Project Explorer
Excel Constants
Variable Constants
Objects, Properties and Methods
Getting & Setting Properties
Calling Methods
Passing Arguments
Singular Objects & Collections of Objects
InputBox Function
MsgBox Function
Using a Set Statement
If Then Janision Structures
Logical Operators
Select Case Janision Structures
Case Else
Comparison Operators with Select Case Structure
For Loops
Do Loops
While...Wend Statement
Run mode and Design mode
Running Code from the development environment
Running Code from the host application
Changing a Property
Dimensioning a variable
Using variables in routines
Object Variables
Designing & Creating Forms
Working with Controls
Creating Custom Dialog Boxes
Userform Properties Methods & Events
Developing Excel Utilities with VBA
Error Handling
Using In-Built Excel Features in VBA
Working with Pivot Tables
Working with Charts
Understanding Excel's Events
Interacting with Other Applications
Creating and Using Add-Ins
Working with the Ribbon
Working with Shortcut Menus
Providing Help for Your Applications
Developing User Oriented Applications
VBA Editing & Debugging
Auto Macros
Error Handling

Saturday, June 17, 2017

VBA Consultancy in NYC

Excel VBA Course Lesson 1: Introduction to VBA and Recording Macros
 Lesson 2: The VB Editor
Lesson 3: Writing VB Code - Introduction to Variables, Decision and Looping Controls Lesson
4: Graceful Error Handling Lesson
5: Excel Functions, User Defined Functions, and Workbook Events Lesson
6: Object Variables, Array Variables, Indefinite Loops Lesson
7: User Forms and Controls Lesson
8: Excel Resources

Vba (Visual Basic) Programming.
Custom Access Database Design And Development.
Spreadsheet Design And Editing.
We Can Build Your Solution In Excel, Access, Mssql, Mysql, Oracle, And More.
Output Reports In Almost Any Format. (Pdf , Excel, Word, Etc)
Automate Time-Consuming Process In Excel Or Access
With Macros And Vba (Visual Basic For Applications)
Routines, Saving You Hours Of Time Doing Labor Intensive

We Assist Small Businesses By Creating Solutions In Microsoft Excel And Access.
• Automate Reporting
• Write Macros To Improve Your Workflow
• Cleanup Outdated Data
• Create Custom Forms Or Surveys (For Internal Or External Use)
• Build Customer Relationship Management (Crm) Systems
• Build Databases

Over Five Years' Experience Creating Solutions For Companies Large And Small.

Successful Projects Include Building A Tracking Database For A Start-Up Drug-Testing Laboratory, Creating A Customer Relationship Management System For An Oil & Gas Services Company, And Developing A Custom Macro To Assist With The Collection Of Data And Automation Of Processes.

Key Words: Excel, Access, Word, Outlook, Vba, Sql, Programming, Programmer, Customized, Ms, Mso, Microsoft, Solutions, Graph, Chart, Module, Report, Designer, Design, Writing, Report Writing, Automate, Workbook, Worksheet, Database, Code, Function, Consultant, Free-Lance, Macro, Analysis, Query, Spreadsheet, Tool, Table, Crm, Customer Relationship Management

Do you need your business to run more efficiently?

I have been developing custom Microsoft Access datatbase and SQL Server database applications in and around the New York area for over 15 years. From small businesses to Not For Profit Organizations to large corporations, my work has saved my client's time and money. I have done work for such companies as ABC, among others. I have experience in the following fields: Accounting, CRM Systems, Hedge Funds, Trading Systems, Budgeting, Inventory, Medical Recordkeeping, and many other diversified experiences.

Many companies have their business spread out in different formats using different programs. I will combine your business into one program, thus making your business run more efficiently. A professionally developed client server Access application can save your company time and money.

For most small and medium projects, Access provides all the tools and facilitates rapid development. Many times companies try to develop these type of applications in-house and run into multiple problems. I can take a project that was started and complete it in a timely fashion. I can develop applications from scratch, or upgrade existing applications, or convert a current program into Access.

My applications are solidly coded using object-oriented VBA techniques, DAO, ADO, ODBC, etc. not a collection of macros. This includes installation of the program and I will provide training and documentation if requested.

My work will save your company time and money and that is the bottom line. Also include a brief description of your project.

*** Automatic emails sent utilizing excel and outlook with the ability to send 100s at a time.
*** Macros to reduce daily processes spent on timely tasks.
*** Customized, automated, & streamlined reporting from small and large data sets

*** Financial modeling and analysis
*** Preparing business analysis and building valuation models to receive capital
*** Quoting and pricing tools that incorporate the use of forms

*** Projects and assignment
*** Prove-It Tests
*** Tutoring

Tutoring/Learning/Sessions/Class on: Learn how to convert Excel/VBA to Google Sheets GAP (Google App Script)

Tutoring/Learning/Sessions/Class on: Learn how to convert Excel/VBA to Google Sheets GAP (Google App Script)

Seasoned tutor with excellent attitude to help new learners.
I am teaching a course on VBA to GAS conversions. Have experience in training tutoring mentoring 100s of students in analytics. Taken courses and developed courses for various online course providers.

Class 1 Topic of Teaching/tutoring:
Can you run macros on Google Sheets?
You can run macros in Google Sheets, as long as they're written in Google Apps Script, a JavaScript-based language built into Google Apps.
You cannot directly run Excel macros in Google Sheets. Although, You can rewrite the scripts in Google Apps Script.

Class 2: Application of GAS for Cloud Engineering & Changing of Investment Analytics

Class 3:
VBA vs Google Sheet programming and Automation - evolving landscape
Batch file / Command line - simultaneous editing of tens of thousands of files on Google drive
Access the spreadsheet and run macro on any device
Cloud compiling and parallel editing of data - Code to be compiled and parallely on the cloud
Scraping of Data from Internet (Like Factset S&P) and putting it on Cloud or using Google finance or apps
Automation and Volatility trading - changing volatility and portfolio balancing

Class 4: Custom class based on students requirement: Is your company switching from Office to Google Docs and you want to learn it?
Example topics for the tutoring session:
Customer 1: I had this (several) code I want to use in Google Spreadsheets but I have no idea on how to do that.
Customer 2: Had great problems when I wrote about starting my effort to convert a complex VBA project to Google Apps Script. Just wanted to emulate a few VBA functions and do a little tweaking.

Class 5: Summary, revision an samples:
Migrating Excel VBA Macros to Google Sheets/Apps Script: Data reshaping in columns and rows.
One of the things to remember when moving from the Excel to the Google Sheets is that:
Every interaction you make with a spreadsheet comes with a performance hit.
Also Apps Script has a 5-10 minute execution limit and other quotas to consider.

Email me at

Thursday, June 15, 2017

office automation excel consultant


Saturday, June 3, 2017

Calling Python from Java Script

Calling Python from Java Script

Wednesday, May 31, 2017


Google developer - play with it while you made the changes

Create contact with Google Sheets

Project to Make data tables from google sheets

Friday, May 26, 2017

Partnership for providing Investment/Risk Analytics Service for your Investment Fund in New York

Looking for Small size Investment Funds in New York

Need of our Services: For any small size investment fund competing with global players where span of funds are generally very short, tactical victories becomes the most important for its survival. Your competition is global (and not local) with innovative companies in USA/EU/India and companies that are taking advantage of cost arbitrage. Automation of VBA-Excel-SQL-R-Python gives the Analyst more time to look at the market and focus on their core expertise. The new areas to contemplate are computations and compilations moving on cloud, storing unstructured large data, and parallel editing.
Moreover, at the time when attrition is a problem (all time low unemployment with toughest skill immigration environment) , a well documented automated setup not only saves time for the current person but also makes it easy to transfer knowledge to new persons joining the team or expansion.

Power of Open Source: Use of SQL/R/VBA/Python/Latex helps to have better data handling and analytic capability. These open source technologies and come with no extra software cost and we provide training to develop the source code to enhance it into the future. Batch files process / shell programming can help you automate lot of manual processes.

Access to Talent in India: Our team at will not only help you in automation but also help you to get access to the 2nd biggest place to find programming talent on the globe after the US. Most of the big analytics research team outside US is located in Bangalore / Bombay and there is always a possibility to get the very right talent / small team / partnership in India at substantially low cost. Wrongly implemented offshoring model often destroys value rather than saving cost.

Criticality of Time: For a small investment startup (2-10 people), the most valuable thing is TIME and hence we help you to tactically get the mundane task out of system, revisit the bottleneck, and hence you can then focus on the main product / strategy that makes your startup special.

Cost Benefit and Agility: We are comprehensively more affordable than any other Analytics consultancy due to our size and expenses. We can start with a very small project (duration & cost) and then move ahead if things get going. We are looking to focus only on one fund for a duration of 6-12m.

Technologies: MATLAB, R, VBA, SAS, Latex, SQL, Python, MongoDB others.

Almost all of the small funds have problems or opportunities for improvement in your workflow. Senior Analyst can fix them if they had the time or could train their employees with such expertise?

Here are the list of problems that we handle:
  • Unforeseen, undocumented, forgiven, hidden cost of issues like below are bringing your profits
  • 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
  • Not using the power of Google Cloud (other cloud) for sharing files and parallel editing models and documentations
  • Cloud based Google Spreadsheet programming

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.

Domain of Analysis: From simple office tasks like automation of excel to more complex tasks like Monte Carlo simulations

About us: India is a vibrant startup and we are a small team (of three) working on Financial Analytics and have been in operation for over four years with a vast library of training videos, code and experience in Investment Projects and Automation. We have presence in NY and India making us aware of deficiencies, strengths and arbitrages that exist. We are looking for a right partner to form a tactical joint venture 6m-12m.
Team of Six: Two Senior Analyst (TBD), Shivgan Joshi (NYC), Ankit Virakta (NYC), Piyush L (Indore, India), Arpit Soni (Indore, India), other contractors based out of Indore, India and NY..
Bandwidth (per week): 40-80 hours onsite at NYC, 40-250 hours Indore, India. We commit to only one fund at one time for a time ranging from 6-18 months.
Pricing: 6-12 month Service Agreement.

Yours Sincerely,
Piyush L
International Business Development in New York, India