Closed

Excel Tutoring

This project received 12 bids from talented freelancers with an average bid price of $13 USD / hour.

Get free quotes for a project like this
Employer working
Project Budget
$8 - $15 USD / hour
Total Bids
12
Project Description

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
Conditional Formatting
Pivot Tables
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
VLOOKUP
INDEX & MATCH Lookup
Macros & VBA Programming

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online