Homepage Help
Help Tutoring jobs
$7/h
1st lesson free!
Pending approval
Response Time 24h
Lessons offered by Anurupika
  • Individual
  • In group
The lessons will be held
  • Chez le professeur
  • 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
Lessons offered by Anurupika
Individual
In group
The lessons will be held
Chez le professeur
webcam
Taught subjects
  • Microsoft Excel
Levels
  • Proficient

Similar teachers

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

Ankeny
Simple Computer Techniques to Take Your Skills to the Next Level and Impress your Friends and Colleagues
$23
Austin
1st lesson free!

I am self taught with Excel but I've used it so many times that I've been considered a wizard. It has always come natural to...

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)
1st lesson free!

I first asses the current knowledge of my student and make sure that learning goals are aligned with their needs. Based on...

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
1st lesson free!

I approach teaching by assessing what you already know. Finding out do you want to know, or what goals you have? Coming up...

Lessons by webcam In-person lessons Approved profile
Hunlock Creek
College student certified in Microsoft Excel offering tutoring services to all ages
$15
Sydney
1st lesson free!

My teaching method is hands-on. I teach as the students are doing the work. There for any questions they have can be...

Lessons by webcam In-person lessons Approved profile
Kentwood
Tutor in all aspects of Computer Information Systems Grand Rapids, MI & Online
$50
Georgina
1st lesson free!

I believe in hands on learning. Lab work where you not only learn the steps but actually do them is important when learning...

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
1st lesson free!

Hi! My name is Orlean. I'm an ESL teacher. I'm teaching English to students who are non- native speakers.I finished my...

Lessons by webcam In-person lessons Approved profile
Onsted
Cybersecurity instructor willing to work with anyone interested in learning Office products.
$20
Wayne
1st lesson free!

My classes are based on work ethic, passion, and desire to become an IT specialist. We use hands on training and virtual...

Lessons by webcam In-person lessons Approved profile
Pueblo
I teach concepts regarding computer information systems and how to properly program them.
$30
Bret
1st lesson free!

I have found there to be a big gap between your experience in school as opposed to the actual real world. There is such a...

Lessons by webcam In-person lessons Approved profile
at his home at your home By webcam
1 hour $7 Not available $7
Reserve a lesson