Search 72,532 tutors
FIND TUTORS

Arthur H.

Newton, MA

$60/hr

Excel expert teaches/shares Excel VBA macros.

Background check passed as of 10/4/12
Usually responds in about 1 hour

Excel expert teaches/shares Excel VBA macros.

Message Arthur

Send Arthur a message explaining your needs and you will receive a response by email. Have you already emailed Arthur or another tutor? If so, you have an account! Sign in now

Please enter the tutor's email address.
Please enter the student's email address.
Please describe how you heard about us.

Receive responses from additional tutors

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.

Rather than travel to the site where tutoring is needed, I prefer methods that are more efficient and more productive: Answering questions sent to me by email or cell phone, visiting the student's computer remotely by using the GoToAssist service, and by emailing some files containing macros that I think will benefit the client.

I developed a spreadsheet that is now known as the Forecaster.xls Purchase Order Generator.
It generates purchase orders that are balanced so that the department tends to run low on everything at once. Side effects are typically that inventory is reduced by 25 percent while driving stockouts to nearly zero.

As I developed one app after another, I accumulated a growing library of VBA macros that I port from one app to the next, to speed development. Using it, I have developed an introductory one-size-fits-all app named AppTemplate.xls. It provides macros that perform automatically many useful chores that otherwise would be done manually or not at all. Building a database in Excel is now almost as easy as operating a typewriter.

Computer:
Microsoft Excel
Business:
Microsoft Excel
Corporate Training:
Microsoft Excel

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.

Microsoft Excel

I warn prospective students that they will learn Excel best if they ask me to help them write a specific program in which they have an interest. Just reading a book on Excel won't work; so says John Walkenbach, author of "Microsoft Excel 2010 Power Programming with VBA" (Wiley, $50).

Most employers are NOT looking for Excel users who know how to write VBA MACROS. Learn the =Sum() formula and move on to learn a little of PowerPoint and Word. That is what you need to be a Secretary (Administrative Assistant) who is in high demand via the temporary employment agencies. Excel is used much more than Access is. Skip Access and clones like ALPHA5 version eleven.

Arthur’s Resources

Tutors have the ability to create educational resources and share them with the WyzAnt community. Here are some of the resources created by Arthur. View all of Arthur’s resources

In December of 2010 I discovered that apps that I develop in 32-bit Excel (in particular Excel 2003, 2007) can be uploaded as .xls files to Google Sheets (of Google Docs) where the formulas and macros may continue to function. I view my uploads by browsing in Internet Explorer to docs.google.com and signing in with my gmail email and by entering my password. Maybe you can access the files that... read more

Tufts University
Bryant & Stratton Computer Institute
Master's

Education

Tufts University

Bryant & Stratton Computer Institute (Master's)

Hourly fee

Standard Hourly Fee: $60.00

Cancellation: 24 hours notice required

Travel policy

Arthur will travel within 1 miles of Newton, MA 02458.


About Arthur

Rather than travel to the site where tutoring is needed, I prefer methods that are more efficient and more productive: Answering questions sent to me by email or cell phone, visiting the student's computer remotely by using the GoToAssist service, and by emailing some files containing macros that I think will benefit the client.

I developed a spreadsheet that is now known as the Forecaster.xls Purchase Order Generator.
It generates purchase orders that are balanced so that the department tends to run low on everything at once. Side effects are typically that inventory is reduced by 25 percent while driving stockouts to nearly zero.

As I developed one app after another, I accumulated a growing library of VBA macros that I port from one app to the next, to speed development. Using it, I have developed an introductory one-size-fits-all app named AppTemplate.xls. It provides macros that perform automatically many useful chores that otherwise would be done manually or not at all. Building a database in Excel is now almost as easy as operating a typewriter.

Education

Tufts University
Bryant & Stratton Computer Institute
Master's

Education

Tufts University

Bryant & Stratton Computer Institute (Master's)


Tutor Policies

Cancellation
24 hours notice required
Travel Radius
Travels within 1 miles of Newton, MA 02458

Arthur’s Subjects

Computer:
Microsoft Excel
Business:
Microsoft Excel
Corporate Training:
Microsoft Excel

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.


Arthur’s Resources

Tutors have the ability to create educational resources and share them with the WyzAnt community. Here are some of the resources created by Arthur. View all of Arthur’s resources

In December of 2010 I discovered that apps that I develop in 32-bit Excel (in particular Excel 2003, 2007) can be uploaded as .xls files to Google Sheets (of Google Docs) where the formulas and macros may continue to function. I view my uploads by browsing in Internet Explorer to docs.google.com and signing in with my gmail email and by entering my password. Maybe you can access the files that... read more


Background Check Status for Arthur H.

Arthur H. passed a background check on 10/4/12. The check was ordered by another user through First Advantage. For more information, please review the background check information page.

After sending a message to Arthur, you will be able to order a new background check for $7.99. As part of your tutor selection process, we encourage you to run updated background checks. Please also review the safety tips for hiring tutors.