Search 73,941 tutors
FIND TUTORS
Over 50 tutoring hours

Jeff W.

Microsoft Office Expert: Excel Pivot Tables Power Pivot

Tucson, AZ (85747)

Travel radius
40 miles
Hourly fee
$40.00
Email Jeff W.

You don't pay for tutoring
unless you find a good fit!

Background Check Status for Jeff W.

Jeff W. has not yet had a background check. After sending a message to Jeff, you will be able to order a background check for $7.99. The check will be processed by First Advantage. For more information, please review the background check information page.

As part of your tutor selection process, we encourage you to run updated background checks. Please also review the safety tips for hiring tutors.

Hello:

My name is Jeff Wilson, and I am a 52 year old self-employed individual who has been working with computers and I have developed an deep aptitude for quite a number of software packages and would like to share that with prospective students and also the business community

In the computer world, I have been an active user and consultant on Microsoft Office since its introduction to the PC world in 1987. My top two modules are Excel and Access. Now with the introduction of EXCEL 2010, I have become a huge advocate for PowerPivot, the free add-in that in my opinion takes data analysis to a new plane. It virtually render Access redundant. PowerPivot makes it possible to create relational spreadsheets. The possibility that opens up is exciting. Let me show you the new technology! It is reasonable to work with large data sets in Power Pivot or to do regular Pivot Tables in either 2007 or 2010. No 2003 support unless upgrading out. I can teach someone how to do it or do it myself. It is my preference to do it by the job to build a solution first and on a subsequent visit show the user the necessary step to effectively use the solution.

Does the IF function intimidate you? Does VLookup make you break out in hives? Do custom measures in Power Pivot and Fiscal reporting in Pivot tables blow your brains to bits? I'm mentioned in Rob Collie’s book on Power Pivot as a member of flash mob of Power Pivot devotees.

In academics, I am extremely well-versed in History, especially American, as well as Government Law and Politics and Political Science. I was a Criminal Justice Major so I able to tutor on the Courts etc. My interest in these areas has continued post-graduation. WyzAnt requires active billing be on file but your card is not charged until a lesson occurs and the first lesson is 100% refundable.

Give me a try. I do my best to make even the mundane seem interesting and compelling.
Billing terms are extremely flexible, especially in a project oriented situation.

Email Jeff

Jeff’s subjects

Math:
Probability
English:
ACT English, ACT Reading, Bible Studies, English, Grammar, Literature, Proofreading, Public Speaking, Reading, SAT Reading, Vocabulary, Writing
Science:
Biostatistics, Pharmacology, Philosophy, Psychology, Sociology
Computer:
Computer Science, Desktop Publishing, DOS, General Computer, Macintosh, Microsoft Access, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Microsoft Windows, Microsoft Word, QuickBooks
Language:
Speech
History:
American History, Criminal Justice, Geography, Government & Politics, Religion, Social Studies, World History
Elementary Education:
Grammar, Reading, Spelling, Study Skills, Vocabulary
Business:
Business, Career Development, Economics, Law, Marketing, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Public Speaking, QuickBooks, Tax Preparation
Homeschool:
Economics, English, Reading, SAT Reading, Study Skills, Writing
Test Preparation:
ACT English, ACT Reading, ASVAB, Career Development, CFA, College Counseling, GED, SAT Reading, Series 7
Sports/Recreation:
Baseball, Basketball, Football, Golf, Poker, Softball
Corporate Training:
Business, Career Development, College Counseling, Criminal Justice, Economics, General Computer, Grammar, Law, Microsoft Excel, Microsoft Word, Proofreading, Public Speaking

Business

I have run my own consulting business for 20+ years, and have studied aspects of management, accounting, finance, business law and marketing. I was actively involved in sales as well. I used the business knowledge along with my computer knowledge to be able to design solutions for businesses in Microsoft Excel and Microsoft access.

I am also an active viewer and reader of CNBC, Forbes Magazine, Investor's Business Daily, The Wall Street Journal, and the Fox Business Network.

Criminal Justice

My college major was Criminal Justice through the Sociology Department of Northern Illinois University. My subspecialty was Law Enforcement, I am extremely strong on any Criminal Law, Constitutional Law, or Police Procedure classes. I worked during school and for the first 3 years after graduation in the security field ranging from contract guard work during school time, to director of off campus security in a major dormitory to corporate security with Standard OIL at their world HQ in Cleveland. I scored very well on any written test that I took with any Law Enforcement Agency during my years at Standard Oil.

I can help anyone throughout this field with their coursework. I have been a student of the Constitution and its legal implications since Government Law and Politics that I had as a senior in high school fanned the flames and I tutored many high school students in my graduating class in an Illinois High School both the US and Illinois Constitution which were required tests for graduation. On police subject matter I am comfortable teaching an individual and/or a large group in one setting, and then even following up with individuals like a study group first which is typical in a law school/CJ situation.

Something like the Kitty Genovese case where at the time they believed 38 people heard the murder of Kitty and no one did anything to help and then later it was learned on a 20/20 that as many as 70 may have heard her screams for help and this case created the bystander principle of psychology that was a hallmark of both my abnormal Psych my Social Psych classes that were part of the Sociology department that parented our CJ degrees. Give me a try - you wont be disappointed

Football

I am a football historian and an absolute fanatic of the game. I helped my brother-in-law coach freshman and JV football by being a spotter in the booth and compiled the stats for the team for 3 years. I called it in to local media in Wisconsin so he could speak to the appropriate journalist. I have been a fan of the Green Bay Packers since 1966. I know the game, its strategies, the roles of all 22 on the field playing the game and the roles of the referee, umpire, field judge,side judge, back judge and line judges. I know the officials' signals for penalties including some you rarely see like tripping and leg whipping. I know the difference between winning the coin toss and deferring to the 2nd half or taking the ball to open the game. I know the reasons why a coach makes that decision.

General Computer

Experienced since 1985 on computers, virtually all self taught. Vast array of skills. Can help anyone on a computer from novice to expert

Macintosh

As someone who has used computer applications extensively for over 25 years, I am very familiar with the Mac in addition to the PC and feel that I can teach a user well on them

Microsoft Access

Microsoft Access is the relational database that is within the Office Suite. I first began using Microsoft Access out of the Office95 suite, so I have 15 years of experience with it.

a relational database has tables and within those tables fields and there is typically a one to many relationship for example a business can have many customers and many orders in a given day and that goes without saying, however once you individualize the customer by using something like Customer ID and then they have a unique number, they become the ONE and all of THEIR Orders become the MANY as long as in the Customer table there is a field that creates a relationship to the ORDER table. I keep it simple and use Customer_ID in both. Access is very powerful and a great tool, sometimes though is the database is flat file it is best to have it in EXCEL and use PIVOT TABLES - the best analysis tool in the Office Suite by far

Microsoft Excel

I am proficient in Excel 2010 especially in the areas of PowerPivot, Pivot tables and using formulas. Also will work on 2007. ABSOLUTELY no SUPPORT FOR 2003. Its being phased out support from Microsoft has been gone since 2009 and in 2014 the .XLS will go the way of the old Lotus .wks into the abyss.

Microsoft Outlook

I use Outlook everyday to manage my email and contacts for my personal life and for my business as a Microsoft Office consultant. I use distribution lists, flag incoming emails from particular sources and many other features that I would love to pass on.

Microsoft Windows

Having used every version of Windows since 1987 with the exception of Windows 7, I am very well qualified to help users become familiar with the operating system. I use it every single day.

QuickBooks

I have done numerous accounting setups for businesses over the years using primarily Quickbooks as my software of choice.

Series 7

I took and passed the Series 65 - Registered Investment Advisor licensing test in 2003. As such, the Series 7 is a less comprehensive and less intensive exam and I am certain I can provide the tutoring necessary for an individual to do better on the test.

Sociology

My Criminal Justice major went through the Department of Sociology so I am very familiar with all the social psychology, social theory and social thought courses that were part of the core curriculum for my major.

Study Skills

I have taken numerous tests over the years including : Real Estate Licensing Exam, Series 65 Registered Investment Advisor.

I have utilized many study techniques including neural association for memory, however the best study technique is to master the fundamentals and then extrapolate those concepts to higher level concepts.

A good understanding of the basics is key to at the very least making informed and educated guesses on multiple choice tests. By eliminating possible answers you narrow your choices and increase your chance of success. That is a win-win strategy to doing better on any multiple choice test.

Writing

I am an excellent writer especially in the area of persuasive writing. I love to write opinion pieces

Read all subject qualifications »

Email Jeff

back to top

Education

Northern Illinois University (Criminal Justice)

Hourly fee

Standard Hourly Fee: $40.00

Travel policy

Jeff will travel within 40 miles of Tucson, AZ 85747.

Email Jeff

Usually responds in about 7 hours

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

(ex: algebra, chemistry)
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 selected, 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.