You have chosen to sponsor your bid up to a maximum amount of .
We are looking for tutors who can teach Excel over Skype, from the basics all the way to advanced levels. The list of topics expected to be covered are included below. VBA knowledge is a plus, and can earn you extra hours at a higher rate.
Classes are expected to be conducted from 2pm to 11pm Eastern Standard Time (US & Canada)
You will be expected to bring your own teaching materials and lesson plans. These are quite easily available elsewhere; you may use whichever reference books you like, as long as the clients are receiving high quality instruction.
TOPICS EXPECTED TO BE COVERED:
Basic Formatting Techniques
Absolute and Relative Cell Referencing (i.e. the $ sign)
Math & Statistical Functions (e.g. SUM, AVERAGE)
Date & Time Functions (e.g. TODAY, MONTH)
Text Functions (e.g. LEN, CONCATENATE)
Group / Ungroup Rows & Columns
Alternative to Merged Cells (Includes Removing Gridlines)
Extract List From Data With Duplicate Values Removed
Logical Functions (e.g. IF, AND)
Lookup & Reference Functions (e.g. VLOOKUP, MATCH)
Naming Ranges and Cells
Data Validation with In-Cell Drop-Down List
Auto-Filter and Advanced Data Filtering
Creating and Designing Charts (including Sparklines)
Introduction to Tables
Information Functions (e.g. CELL, ISNUMBER)
Formula Auditing & Formula Evaluation
INDEX & MATCH Lookup
Macros & VBA Programming