NEW FEATURES MORE

Search

Steve B.

New York, NY

$65/hour

Excel Applications Tutor

In-person lessons
50+ Hours
4.6 average from 7 ratings
Patient, knowledgeable and flexible tutor
— Mary, New York, NY on 1/18/17

$65/Hour


Send a message explaining your needs and Steve will reply soon.

Response time: 2 hours

Contact Steve

New York University; Degree: Associate Arts
Mathematics

Education

New York University; Degree: Associate Arts (Mathematics)

About Steve

Want to do more than just formatting and formulas? I teach you how to actually write macros for Excel through an immersive approach. I show you how to do things that most people believe are not possible to do with Excel. If you just want to learn the basics of Excel, I will be able to show you all you might need; but if you want to blow the minds of people you work with, I am the tutor you want.

I can teach you how to retrieve information from an interactive website and make a chart, all at a push of a button. Or generate a difference report for comparing comparable data. If you know how to program in C(++) (I can train you in that too...), I can show you how to write your own high speed complex functions that can be called directly from Excel.
Want to do more than just formatting and formulas? I teach you how to actually write macros for Excel through an immersive approach. I show you how to do things that most people believe are not possible to do with Excel. If you just want to learn the basics of Excel, I will be able to show you all you might need; but if you want to blow the minds Read more

Policies
Cancellation
10 hours notice required

A $10/hour discount is offered after you receive 4 hours of tutoring in a week (and a $15/hour discount after you receive 6 hours in a week), for the remainder of that week...

Travel Radius
Travels within 10 miles of New York, NY 10025
In-person lessons

"Patient, knowledgeable and flexible tutor"

- Mary, New York, NY on 1/18/17

"Excellent SQL resource!"

- James, Brooklyn, NY on 3/16/16

"Genius!"

- Rolando, New York, NY on 9/26/13

Approved subjects are in bold.

Approved subjects

In most cases, tutors gain approval in a subject by passing a proficiency exam. For some subject areas, like music and art, tutors submit written requests to demonstrate their proficiency to potential students. If a tutor is interested but not yet approved in a subject, the subject will appear in non-bold font. Tutors need to be approved in a subject prior to beginning lessons.

Accounting

I have performed accounting for a corporation. I have assisted companies manage their accounting using QuickBooks. I have created automated routines to perform accounting reconciliations for companies. I have also organized accounting expenses for companies to render in Excel using drill-down views.

Business

I was a managing partner for a computer consulting company for twenty years. I would oversee a team of developers (up to five at any time). The company would complete projects for various investment banks, sometimes on a concurrent basis.

C

I have debugged the Open Source IMAP Mail Server called "Cyrus" using the "RATS" (Rough Auditing Tool for Security). I have written XLLs for Excel. I have written Outlook Addins using C.

C++

I have written extended stored procedures for Microsoft SQL Server using C++. I have written lexical text parsers using C++. I have generated regex parsers using C++.

Computer Programming

I have worked as a teacher's assistant for two years and instructed undergraduate and graduate students to write programs. My teaching methodology takes students through a series of algorithmic challenges, starting with simple ones (binary search, "game of life", etc.) and working their way up to more complex database projects. I have also worked as a corporate trainer, instructing employees not only how to learn specific programming languages (such as VBA and C++), but also how to tackle algorithms. While a specific computer language can serve as a useful tool to learn, the language itself is not the ultimate goal of programming; the application of logic and problem-solving to computer languages constitutes the science of computer programming.

Computer Science

I have worked as a teacher's assistant at New York University, at the computer center, assisting undergraduate and graduate computer science majors complete their programming projects. I have published an article on extended stored procedures in "SQL Server Magazine". I have acted as an expert witness in litigation for a "year-2000" (Y2K) case for a law firm.

Finance

I have implemented and debugged models for financial instruments. I have performed market valuations of equity portfolios using "three dimensional" renderings in a spreadsheet. I have performed bond valuations using Net Present Value summation. I have also implemented portfolio valuations using real-time pricing in Excel.

HTML

I am knowledgeable about the different W3 (World Wide Web Consortium) standards, including XHTML-transitional. I have a lot of experience with dynamic client-side HTML generation using Javascript. I have implemented browser-only (no server) web applications using HTML and Javascript. I am quite versed in the the Document Object Model, and how to make markup adapt to browser idiosyncrasies using conditional Javascript.

Java

I have implemented Tomcat Server implementations (that use Java) that were in commercial service for ratings queries. I have performed dynamic web page parsing using the Java package "htmlUnit". I have implemented SQL database applications using specialized JDBC drivers. I am proficient with Interactive Development Environments for Java, including Aptana and Eclipse.

Linux

I have customized the "Astaro" Firewall, which is based on a hardened Linux distro originally derived from SUSE. I have set up and hardened Fedora for clients to act as an IMAP mail server. I have installed Red Hat Server for a web server for a ratings agency.

Microsoft Excel

Excel Application Development

Microsoft Outlook

I have written an Outlook VBA macro to load CSV data into Contacts in a specialized manner. I have made VBA event routines for processing programmatic mail responses based on customer Email queries. I have put together Outlook VBA macros for reformatting Contact data to remove duplicates.

Microsoft PowerPoint

I have assembled slide shows for economists using various animation effects. I instruct PowerPoint students on how to obtain good graphics and videos for their presentations for little or no cost. I also instruct students on integration of their presentations with Excel. The most important skill in PowerPoint presentations is to keep text to a minimum and let pictures and charts tell the story.

Microsoft Windows

I have used Windows operating systems since Windows 3.1 (the first version of Windows NT). I have done numerous upgrades of Windows XP to Windows Vista and Windows 7. I am extremely facile using the "Windows API" from various programming languages.

Microsoft Word

I have done extensive Word macro implementations to assist publishing operations with automated document formatting. I have made print-on-demand books using both Word and OpenOffice. I have experience integrating Word with Outlook using mail merge to generate customized email notices. I have constructed document templates to assist with office automation tasks.

Networking (Computer)

I supported Astaro Firewalls, which required significant network troubleshooting since the firewall effectively also acted as a router. I have troubleshooted Windows workstation issues. I have configured a Debian Unix box to act as a wireless on demand router for a LAN.

PHP

I have programmed various extensions to phpBB; I have implemented custom calendaring using the SourceForge project WebCalendar. I have debugged various PHP sites.

QuickBooks

I have set up businesses to operate on QuickBooks. I have helped businesses compose customized reports using both the Custom Reporting capability in QuickBooks Enterprise, and QDBC in conjunction with Excel macros. I have performed upgrades of QuickBooks systems to newer versions. I have integrated QuickBooks systems with corporate SQL server databases.

SQL

I have implemented numerous extended stored procedures in SQL. I have written a magazine article for the trade explaining how extended stored procedures in SQL work. I have set up two way replication using event triggers between SQL servers on a Wide Area Network (WAN).

UNIX

I have configured OpenBSD Unix to act as a firewall. I have configured FreeBSD Unix to act as a Samba fileserver. I have configured FreeBSD Unix to act as a network monitor node.

Visual Basic

I have done extensive and copious amounts of VBA (Visual Basic for Applications) programming. I have implemented reporting tools using VB.net. I have written various Visual Basic applications using the MSFlexGrid control.

Web Design

I have implemented a Tomcat application that generated dynamic web content. I have written extensive JavaScript routines to make for extensible web interface capabilities. I have made websites generate content dynamically on a browser-specific basis.

New York University; Degree: Associate Arts
Mathematics

Education

New York University; Degree: Associate Arts (Mathematics)

Patient, knowledgeable and flexible tutor

Steve was great, he was willing to listen, take the time to know what I needed and adjust to my needs. I felt he was able quickly grasp my situation and skill set, or lack there of....He also had an excellent plan for our next session.

— Mary, New York, NY on 1/18/17

Hourly rate

Standard Hourly Rate: $65.00

Cancellation: 10 hours notice required

A $10/hour discount is offered after you receive 4 hours of tutoring in a week (and a $15/hour discount after you receive 6 hours in a week), for the remainder of that week...

Travel policy

Steve will travel within 10 miles of New York, NY 10025.