Search 72,511 tutors
FIND TUTORS
Over 20 tutoring hours

Joseph P.

Chapel Hill, NC

$40/hr

Excel and Access Guru -- Military Officer, Natural Gas Industry

Usually responds in about 11 hours

Excel and Access Guru -- Military Officer, Natural Gas Industry

Message Joseph

Send Joseph a message explaining your needs and you will receive a response by email. Have you already emailed Joseph 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.

Seven years of experience using advanced computer techniques to achieve real goals in business administration and operations management. Four years of experience in graphic arts.

Two years of experience with Access Midstream, a pipeline company in the Marcellus Shale (Jane Lew, WV). Five years of management experience as an officer in the US Coast Guard, both afloat and in an operations center.

I'm an "Excel guy" and "Access guy" -- I've used advanced user interface design with Visual Basic for Applications to create tools that some of our extremely nontechnical pipeline workers can use to integrate field reports into business data. I've used VBA hand-in-hand with both tools. I've used CGI/Perl to build a dynamic website for a motorcycle club. I used Adobe Photoshop for years with the family publishing business and still use it regularly to add an extra flair to business presentations and personal projects.

I'm a newlywed, newly moved to Pittsburgh. I'm definitely a hobbies and crafts kind of guy. I like motorcycle riding, AMC dramas, playing piano with my church praise band, drawing comic books, reading Popular Mechanics, running, martial arts, woodworking (or really anything with power tools), and board game nights with friends. I can quote the Star Wars movies from memory. I was homeschooled through high school and am still pretty close with my eight brothers and sisters despite our geographic dispersion. My circle of friends at the moment are mostly the down-to-earth folks around my own age from church.

I grew up around computers and small business, working with my parents to publish a magazine. By the age of 18, I had sold advertisements, spoken at conventions, become proficient in graphic arts, learned a programming language, and served as editor of a magazine with a print run of 25,000 copies every two months. All that, a high school education, and even some long summer days at the neighborhood pool.

Testimonials

"Great feedback on my spreadsheet"

- Robert, Chapel Hill, NC on 11/13/14
English:
Reading,
SAT Reading,
SAT Writing, Writing
Science:
Physics
Elementary Education:
Phonics,
Reading,
Study Skills
Special Needs:
Phonics
Business:
Microsoft Excel
Test Preparation:
College Counseling,
SAT Math,
SAT Reading,
SAT Writing
Corporate Training:
College Counseling,
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.

Adobe Photoshop

I have a decade of experience in Adobe Photoshop going back to grade school. I used it in my family's magazine publishing business to retouch photographs, create headings, and more novel applications. I have continued to develop my abilities in subsequent versions of Photoshop, using it to create headers for video projects, user interface elements for database designs, and more.

I am intimately familiar with formatting for screen, web, and print, in black-and-white, grayscale, duotone, RGB, and CMYK and the associated issues. I have a good intuitive sense of how to use layers and channels to create complex effects, and the power of the Lighting Effects filter with a height mask. I can demonstrate how to use Levels, Adjustments, Hue/Saturation to color-correct against a baseline proof. I can teach how to manually create Paths with complex curves and boolean interaction and how to output the results to clip images for print. In short, I can walk a student from basic theory through advanced practice in photo retouching, logo abstract creation, and original artwork.

Algebra 1

In my mechanical engineering degree, I studied and got A's in math all the way through multivariable calculus with differential equations. In my Operations Analysis and Engineering Tech work at Access Midstream, a Marcellus Shale natural gas pipeline company, I've used algebra before the sun comes up daily for two years to solve analytical problems. More to the point, I know how to teach it. I tutored Academy classmates and I also taught many of my younger brothers and sisters (of which I have seven) mathematics from elementary through calculus 2. So I know many approaches to teach different personality types, and I know how to break it down into the basics. If you get ahead of yourself, math seems impossible. If you work up from whatever subject matter makes you feel solid and make sure you really know every step, not only is every step much easier, but you never forget it.

I can help you cram quite successfully, but my best work is after the pressure is off, when I can help you truly understand algebra. It will make every other "hard science" course for the rest of your academic career better.

Calculus

I've also had occasion from time to time to use calculus, for example using a complex double-integration to calculate the volume of natural gas liquids based on the number of inches of liquid in some difficult-shaped vessels like slanted cylinders, or analyzing financial profitability of a well connection based on the observed production decline curve.

I have an innate understanding of the concepts, as you will also once you've had the time to understand it step-by-step. I can help you cram, but my best work will be over a longer term, helping you truly understand and apply the subject.

College Counseling

My particular area of expertise is in essay planning and writing. I have decades of formal and informal writing training, dating back to editing my parents' internationally-circulated homeschooling magazine in high school, and have written hundreds of position papers for everything from fellowships and scholarships to college and graduate school applications, job applications, and much more. I've studied trends in all these fields and gone through professional writing consultants. This last year, I applied to ten MBA programs and got accepted into half of them with full tuition fellowships -- I am now an MBA student at UNC. That means that over the course of a summer, while working full-time, I wrote over 30 carefully-targeted essays, each of which highlighted the parts of my story that showed alignment between my background and the school's leadership direction. I know the difference between what you think they want to hear and what sets you apart as a unique candidate -- how to capture attention and project a certain sense of humor while keeping everything within constraints of the utmost professionality. Most importantly, I'm good at interacting to draw out your story and helping you use your voice to tell it.

Drawing

I've been drawing since the age of 10. My greatest focus is in comic book-style artwork, where I've spent years on the human form, building up from a dramatic concept to stick figure primitives, bodies, faces, hair, costumes or street clothing. Though I have always enjoyed the comic book art style, I prefer graphic novels and dramas over superheroes. I enjoy a touch of the dramatic and can show you how to focus on expressions or draw ordinary, non-super-heroic people. I also know rigorous techniques for drawing realistic architecture in perspective, and as a mechanical engineer I've honed the ability to draw both real and fantastical machinery with or without an object for reference. I know how to teach a basic concept and then give plenty of exercises to complete on your own, maximizing the use of the tutoring time. In short, I can help you out from beginning to advanced drawing, even if you think you're no good at it, and provide you quite a lot of fun in the process if you have a passion for it.

Microsoft Access

I have been through a complete range of training, Access Levels 1 through 4, with the US Coast Guard. I have then created databases with fully-developed human interface for non-technical personnel to use, augmented by Visual Basic scripting, including:
- A staff emergency recall database that restricted access based on a user's group memberships through Active Directory scripting. It had a leave calendar for critical officers, so that if a senior officer was out of town and had to be briefed, the phone number for the next in command automatically came up.
- A simple "chart check off" system for an office admin to check off which natural gas meter charts had been changed and brought in and create reports, to make sure all measurement was done for the month.
- A complex multidimensional construction tracker whereby field inspectors could enter progress on a pipeline construction project, thereby calculating the amount of dollars for which a contractor could bill the company based on Earned Value Accounting.
- A front-end system that pulled line balance data from the Oracle database at the core of the Flow-Cal gas accounting system and used VBA integration with Excel to create trend charts that enabled visual assessment of possible cause and effect trends for lost gas accounting in a pipeline system.

Microsoft Excel

I have been using Microsoft Excel on a daily basis for the last seven years in the Coast Guard and in a Marcellus Shale pipeline company. I have created complex logical sequences that translate internal spreadsheets into a radically different externally-defined format for exchange with a customer. I have used spreadsheets for myriad tasks from discrete calculation or trend-seeking in raw field data to manual double-integration of a complex calculus equation.

I can walk a student from basic theory of how to format cells for print and use number types, step-by-step, all the way through data validation with drop-downs, restricted user access, string operations, and nested HLOOKUP and VLOOKUP functions. I have used most of the built-in functions daily.

Painting

I've been an art hobbyist since 10. I haven't painted professionally, but growing up, I did occasionally use techniques with oil, watercolor, and even digital painting/airbrushing in Adobe Photoshop to produce original artwork for my parents' magazine, Practical Homeschooling. I can teach color theory, additive/subtractive/mixing theories for different types of paints, perspective, how to build up from sketched primitives into machines, buildings, landscapes, and human form, lighting, texture, fabric, calligraphy. So while I'm not a known master, I can provide plenty of fun and exercises to fuel enthusiasm for a beginning to intermediate painter.

Phonics

I was personally responsible for teaching all of my seven younger brothers and sisters to read, at ages as young as three years old. I've learned teaching techniques including songs, games with movement, read-along drills, tactile learning aids, and much more. I work well with kids, having volunteered as a leader for the parachurch organization AWANA and having volunteered with a summer school reading program last year in West Virginia. The important thing is that, upon learning your child's learning style, I know many ways to make phonics fun and effective and help him/her enjoy reading.

I grew up in a large homeschool family, helping my parents publish the magazine Practical Homeschooling and the Big Book of Home Learning. I was magazine editor at the age of 18. This experience exposed me to numerous reading curricula and approaches, good and bad, for many different learning types. I've worked with, evaluated, and reviewed many curricula including "Sing, Spell, Read & Write," "Alpha-Phonics," "Hooked On Phonics," and some more eclectic approaches including "Ball-Stick-Bird," a system designed to help unconventional learners including those with dyslexia. I can work with an existing phonics curriculum, recommend several, and also apply many of these same approaches one-on-one in a tutoring setting without curriculum.

If we can get them reading, everything else will follow.

Physics

I passed AP Physics with a 5.0. I passed calculus-based Physics 1 and 2 at the US Coast Guard Academy with A+. I tutored several classmates during my time there and helped them improve their grades as well. Since then, I've had occasion to use various physics and engineering principles in the real world as part of the analysis I performed as an engineering tech. I remain well versed in the theory and can effectively use the equations, relate them to each other through calculus, and explain the material in multiple ways to help the student "get it."

Prealgebra

I have a high level of math ability, having used algebra and often calculus daily before the sun comes up as an engineering tech with a natural gas pipeline company. I have a unique advantage, as I was homeschooled in a large family, and was editor of Practical Homeschooling magazine for several years -- I've been exposed to many ways to teach math, and to theory on many learning styles. I've had practical experience teaching my own younger brothers and sisters, which translated well to helping tutor classmates in calculus at the US Coast Guard Academy. I have a positive, personalized style. So whether the student is advanced or falling behind in school, I can help find a personal approach to teaching one-on-one that will work better than traditional classroom instruction.

Precalculus

An an MBA student with a mechanical engineering undergraduate degree and years in natural gas industry, I've been using math continuously for a decade. Not only do I know how to walk through a textbook, but I know how to explain the concepts in a way that has meaning. One of my gifts is in making my knowledge accessible. I can draw pictures and explain most concepts three or four different ways. Pre-calculus is a review of many topics you'll recognize from algebra, including geometry, cartesian and polar graphs, trigonometry, and solving multiple equations.

Most textbooks will show you a bewildering barrage of equations to solve every kind of problem there is. My approach will touch on these equations, but focuses more on a few fundamental equations that you can easily use to figure out the rest when you need them -- this method will give you a deeper understanding of the subject and also enable you, over time, to solve most equations without notes.

I'll help you find the familiarity you need with the basics, so that you can clear your mind and focus on new knowledge when you're studying calculus.

Reading

I've had the good fortune to come from a large home-schooling family, where I've been involved in teaching each of my seven younger brothers and sisters to read, many at ages as young as three years old. No two of them learned at exactly the same speed or in the same way. In my work editing a home-school magazine in the family business, I've seen many approaches to learning reading for many personality types and helped review dozens of reading products. So I understand not just the theory of reading, but also how it applies to different kinds of learners.
In more advanced reading, vocabulary, and comprehension, I have advantages including having studied Latin for three years, read literature, and of course having been an avid reader since the age of three. I can dissect legalese, news, technical writing, persuasive pieces, hidden language in advertising, dialogue written in a peculiar dialect, and so on, and I can teach you to recognize the signs as well.

I work well with children, including in groups, as demonstrated by my volunteer work with AWANA at Santa Rosa Alliance Church for five years. But I'm also a good communicator with adults. I can keep the instruction non-threatening, tailor a lesson to however much you are prepared to learn in a single day, and make sure that you make progress at your own best pace.

SAT Math

SAT math, like most placement exams, typically goes up through algebra, trigonometry, and geometry -- a level of math proficiency that I've used daily in operations analysis as an engineering tech for a natural gas pipeline company these last two years. Depending on the time available, I can focus on the test-taking skills or go more in depth with the mathematical ability required to get a top score on the SAT.

Test prep has been a valuable skill for me -- I earned a 1560 on the SAT and went on to attend the US Coast Guard Academy. Since then, I've earned a 760 on the GMAT and passed the Project Management Professional exam on my first test. While it's true that each of these exams tests certain core subjects, such as English reading, writing, and algebra, which take a long time to learn and are difficult to boost through a short course of study, each student can make significant score improvements from wherever they are academically by studying test-taking skills. Certain disciplines, such as answer choice elimination, familiarity with question types, and clock management, can be taught in a relatively short time and make a difference to the student's overall score potential. If we're studying for a test just a few weeks away, I can help you focus on the raw test-taking skills. If we have more time, I can help determine the weak points and use a targeted course of study to make real improvement in math ability.

SAT Reading

SAT Reading typically involves a focus on comprehension, comparison, and analysis of written passages and a "fill in the blank" approach to sentence completion, with questions of increasing difficulty. The test is designed to determine a student's real level of reading comprehension, which is a skill that takes time to develop. But real reading ability is only one component of the SAT reading test -- the raw skills of taking the SAT itself, which can be taught relatively quickly, are the other. The good news is that, whatever reading level you're at, I can teach test-taking strategies that will make the most of the knowledge you already have. If you have more time before the test, I can also work with you in the longer term to determine what learning style works best for you, prescribe leisure reading, and design vocabulary drills that will improve your real level of reading ability and comprehension speed.

Test prep has been a valuable skill for me -- I earned a 1560 on the SAT and went on to attend the US Coast Guard Academy. Since then, I've earned a 760 on the GMAT and passed the Project Management Professional exam on my first test. While it's true that each of these exams tests certain core subjects, such as English reading, writing, and algebra, which take a long time to learn and are difficult to boost through a short course of study, each student can make significant score improvements from wherever they are academically by studying test-taking skills. Certain disciplines, such as answer choice elimination, familiarity with question types, and clock management, can be taught in a relatively short time and make a difference to the student's overall score potential. If we're studying for a test just a few weeks away, I can help you focus on the raw test-taking skills. If we have more time, I can help determine the weak points and use a targeted course of study to make real improvement in English ability.

Study Skills

I grew up in a large homeschool family (seven younger brothers and sisters) with many different personality types and have been personally responsible not just for my own education but at various times for theirs. In addition, as editor of the magazine Practical Homeschooling for several years, I was exposed to (and in many cases wrote reviews personally of) numerous kinds of study aids, whether software, paper, audiocassettes, you name it. I discovered that, with targeted study, one could achieve a top-notch education in under four hours a day.

Based on my coursework in both fundamentals and test preparation, I was able to earn an SAT score in the mid-1500's, which helped me gain acceptance to the US Coast Guard Academy. During my four years there, I not only personally succeeded in a demanding course of Mechanical Engineering study ranging from team projects and research papers in the humanities to "hard" subjects, graduating with honors, but tutored classmates on numerous occasions. I have developed techniques of targeted study that continue to work for me, including thousands of pages of reading on the natural gas industry during the first few months of my job at Access Midstream and success at passing the Project Management Professional certification exam on the first try. I know many approaches for many circumstances, and I can find the ones that work for you.

Visual Basic

I've used VBA extensively at work in the military and natural gas industry. I can teach VBA from basic to advanced, in particular tying it in with .NET programming and the Microsoft Office Suite. Examples of my work include:
- Outlook scripts to mass-text-message senior officers with critical operations briefings.
- Database enhancements to integrate with Active Directory Users and Groups in order to lock down parts of a database based on the user's group membership.
- Advanced automated report design, pulling data through Microsoft Access and SQL queries and automatically building reports with graphs in Excel at the push of a button, both for natural gas accounting and for chemical tracer analysis on a gas well production database.

Writing

I have been writing my entire life. In high school, I spent five years working with my parents' magazine publishing business as editor (25,000 copies 6 times a year). I learned how to take apart and clean up messy writing, and how to make it readable for the average magazine audience. I continued to hone my writing ability through dozens of research papers at the U.S. Coast Guard Academy. After graduation, as an officer, I've done professional writing including hundreds of pages of legal investigations, rewritten internal policy, wireless transmitted message traffic, memorandums, technical statements of work for contracts, case summaries, recommendations, justifications, and of course thousands of emails.

I know some theories of novel writing, so I can be a critic, but I must confess that I've never written a novel. But if you want to learn writing, from the basic elementary level up to professional writing in a business or academic context, I can most certainly help.

If this work is for a child, I do work well with children. I come from a large home-schooled family -- seven younger brothers and sisters -- and I've taught all their different personality types. I was also a volunteer at Santa Rosa Alliance Church's AWANA program, where I worked with large groups of children. I kept it fun but on topic.

If this is for an adult, I am good in a professional context as well. I've tutored classmates at the US Coast Guard Academy and I've edited professional writers. I use interaction, discussion, and exercise to fix what needs to be fixed but make sure I bring out your own writing voice.

United States Coast Guard Academy

Education

United States Coast Guard Academy

Great feedback on my spreadsheet — Both the lesson and the lesson summary were great on questions and problems relating to several formulas and formats I used on a spreadsheet. After just a few lessons, Joseph has a great talent for figuring out how fast and slow explanations need to be depending upon whether I have seen that particular concept before, and how complex it is. Joseph is very professional and knowledgeable. ...

— Robert, Chapel Hill, NC on 11/13/14

Hourly fee

Standard Hourly Fee: $40.00

Travel policy

Joseph will travel within 5 miles of Chapel Hill, NC 27514.


About Joseph

Seven years of experience using advanced computer techniques to achieve real goals in business administration and operations management. Four years of experience in graphic arts.

Two years of experience with Access Midstream, a pipeline company in the Marcellus Shale (Jane Lew, WV). Five years of management experience as an officer in the US Coast Guard, both afloat and in an operations center.

I'm an "Excel guy" and "Access guy" -- I've used advanced user interface design with Visual Basic for Applications to create tools that some of our extremely nontechnical pipeline workers can use to integrate field reports into business data. I've used VBA hand-in-hand with both tools. I've used CGI/Perl to build a dynamic website for a motorcycle club. I used Adobe Photoshop for years with the family publishing business and still use it regularly to add an extra flair to business presentations and personal projects.

I'm a newlywed, newly moved to Pittsburgh. I'm definitely a hobbies and crafts kind of guy. I like motorcycle riding, AMC dramas, playing piano with my church praise band, drawing comic books, reading Popular Mechanics, running, martial arts, woodworking (or really anything with power tools), and board game nights with friends. I can quote the Star Wars movies from memory. I was homeschooled through high school and am still pretty close with my eight brothers and sisters despite our geographic dispersion. My circle of friends at the moment are mostly the down-to-earth folks around my own age from church.

I grew up around computers and small business, working with my parents to publish a magazine. By the age of 18, I had sold advertisements, spoken at conventions, become proficient in graphic arts, learned a programming language, and served as editor of a magazine with a print run of 25,000 copies every two months. All that, a high school education, and even some long summer days at the neighborhood pool.

Testimonials

"Great feedback on my spreadsheet"

- Robert, Chapel Hill, NC on 11/13/14
}

Education

United States Coast Guard Academy

Education

United States Coast Guard Academy


Tutor Policies

Travel Radius
Travels within 5 miles of Chapel Hill, NC 27514

Joseph’s Subjects

English:
Reading,
SAT Reading,
SAT Writing, Writing
Science:
Physics
Elementary Education:
Phonics,
Reading,
Study Skills
Special Needs:
Phonics
Business:
Microsoft Excel
Test Preparation:
College Counseling,
SAT Math,
SAT Reading,
SAT Writing
Corporate Training:
College Counseling,
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.


Background Check Status for Joseph P.

Joseph P. passed a background check on 3/4/13. The check was ordered by Joseph through First Advantage. For more information, please review the background check information page.

After sending a message to Joseph, 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.