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

SUBMIT DATE

LAST UPDATED

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