Homepage Help
Help Tutoring jobs
$7/h
First lesson is free!
Pending approval
Response Time 24h
Lessons offered by Anurupika
  • Individual
  • In group
The lessons will be held
  • at his home
  • By webcam
Taught subjects
  • Microsoft Excel
Levels
  • Proficient

Learn Microsoft Advance Excel at home and become advance excel expert quickly

Methodology

Learn Basic and Advance excel tools - Vlookup, Pivot, Sorting, Formatting, Keyboard shortcuts, Use of countif, Countifs, Sumif, Sumifs, Freeze panes, filters.
Easy to make report , graph and statistical presentation, dashboard & power pivot table in Microsoft advanced Excel and live project

Background

Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Lookup & Reference Functions:- VLookup,

Rates

Rate for online lessons : $7/h
Rate for 5 hours of lessons : $36
Rate for 10 hours of lessons : $73
Lessons offered by Anurupika
Individual
In group
The lessons will be held
at his home
webcam
Taught subjects
  • Microsoft Excel
Levels
  • Proficient

Rates

Rate for online lessons : $7/h
Rate for 5 hours of lessons : $36
Rate for 10 hours of lessons : $73

Similar teachers

microsoft excel lessons closeby? Here's a selection of teacher ads that you can check out.

San Diego
I can teach / help in completing projects / assignments related to any programming language or databases
$30
Vivek
  • (3 reviews)
First lesson is free!
Lessons by webcam Approved profile
Milford
I am a technical writer, I work from home for IT and financial industries.
$15
Jyoti
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Ankeny
Simple Computer Techniques to Take Your Skills to the Next Level and Impress your Friends and Colleagues
$23
Austin
First lesson is free!
Lessons by webcam In-person lessons Approved profile
North Miami Beach
Computer Lessons for all ages and levels, Quickbooks, Excel, Office in English and Spanish
$30
Karina
  • (1 reviews)
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Fayetteville
Don't ask Siri! Ask Me! The Tech Teacher from Fayetteville, NC. Fluent in Mac and Windows
$15
ShaKira
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Ossining
Excel and Microsoft Office Expert available world-wide - 20+ years experience with Microsoft
$12
Ben
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Hunlock Creek
College student certified in Microsoft Excel offering tutoring services to all ages
$15
Sydney
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Kentwood
Tutor in all aspects of Computer Information Systems Grand Rapids, MI & Online
$50
Georgina
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Sugar Land
College student studying Management Information Systems and Philosophy teaching technology, data, and writing in Houston
$25
Afshad
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Los Angeles
ESL Teacher with 20 years of experience gives IELTS Review, ESL, Basic Computer, Basic Math and GED.
$26
Orlean
First lesson is free!
Lessons by webcam In-person lessons Approved profile
Onsted
Cybersecurity instructor willing to work with anyone interested in learning Office products.
$20
Wayne
First lesson is free!
Lessons by webcam In-person lessons Approved profile
at his home at your home By webcam
1 hour $7 Not available $7
5 hours $36 Not available $36
10 hours $73 Not available $73
Reserve a lesson