Excel Tutoring/Consulting 1 hour
20
I will teach you 2-5 skills in excel that are guaranteed to help your excel efficiency. Do you spend more than 1 hour building a daily, weekly, or monthly report? I can likely help cut that significantly and show you how to do it for yourself. While learning the basic formulas will set you light years ahead, the true power of excel comes from knowing how to tie these formulas and functions together. Some of my excel skills include, but are not limited to:
Formulas:
SUM
SUMIFS
IF
COUNT
COUNTIFS
VLOOKUP
HLOOKUP
INDEX
MATCH
LEFT, RIGHT, MID
LEN
AVERAGE
AVERAGEIF
TRIM
IFERROR
Several loan/investment formulas
Several time based formulas
FUNCTIONS:
Fixed cell reference
Keyboard shortcuts
Sort and filter
Charts and graphs
Formatting
Text to columns
Conditional formatting
Pivot tables
VBA/Macros:
For all the above functions, and many others, I can show you how to get started on automating them using VBA.
*WARNING* this can take more time to teach but I can help get you started and then show you where you can get free training to help fill in the gaps so it doesn't charge you any more then the basic rate.
If you have any regular dealings with excel and don't know any of the items on the list above, you are likely missing out of very important time and accuracy savings.
Training & Qualifications
I have worked in excel almost daily for over ten years. I have trained dozens of people under my management and within my departments where I have worked. I am an analyst for a major corporation who regularly builds and audits excel documents. I have been college trained in excel and analysis at the associate, bachelors, and Masters level.
Availability & Preferences
Any time as long as planned in advance