Send Steve a message explaining your needs and you will receive a response shortly. Have you already emailed Steve or another tutor? If so, you have an account! Sign in now
If you select this option, WyzAnt will ask interested tutors to contact you by email if they are able to help. A maximum of five different tutors will email you and none of your personal information, including your email address, will be released.
New York University; Degree: Associate Arts (Mathematics)
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
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...
In spite of significant time constraints, Steve quickly got me up to speed on writing more efficient queries and subqueries. Very valuable.
Steve is a tutor with plenty of experience about programming. He can resolve your problems with practical suggestions. I will definitely recommend him to my classmates and friends who are dealing with specific technical problems on their websites.
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.
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.
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.
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.
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.
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.
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.
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.
Excel Application Development
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.
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.
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.
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.
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.
I have programmed various extensions to phpBB; I have implemented custom calendaring using the SourceForge project WebCalendar. I have debugged various PHP sites.
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.
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).
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.