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
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
Silver Springs
Ms excel is a very important tool for professional life and without it we can’t present our report and can’t move towards progress
$14
Muhammad Salman
1st lesson free!

I only focused with practical mostly institute focused on theory but I focused on practical which helps you your career...

Lessons by webcam 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
Crete
University/College/High School Information Technology Instructor with more than 25 years of Educational Experience
$25
Norval
1st lesson free!

I base my teaching methodology on student’s ability to learn difficult technical information, retain and apply what they...

Lessons by webcam In-person lessons Approved profile
Marrero
Specialist in Web Design, Mobile App Development, and Digital Marketing coupled with vanguard business intelligence. If I can be of any assistance to you or just want to chat between professionals..
$8
Braxston
1st lesson free!

My teaching methodology is simple..read-write-recite. My most notable name or alias is Braxston Lamar Rousell. However, I am...

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
at his home at your home By webcam
1 hour $7 Not available $7
Reserve a lesson