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 close by? Here's a selection of teacher ads that you can check out.

Des Moines
MICROSOFT EXCEL: Here to help you grow your Excel knowledge base. All levels: Basic Functions, Nested Functions, Macros & More
$15
Amanda
  • (3 reviews)
1st lesson free!

My approach: - Assess your level of expierence and comfort within the given Excel topic(s) - Understand what you need from...

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
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
Boca Raton
Professional CPA experienced with Excel and PowerPoint available to assist you in learning the basics and/or intermediate skills with Microsoft products.
$45
Jennifer
1st lesson free!

My teaching method is to assist my client while they are performing the task. The best way to learn software, especially...

Lessons by webcam In-person lessons Approved profile
Las Vegas
Licensed K-Adult instructor in Las Vegas with a passion for teaching and learning. I am very student-centered and flexible with my approach to teaching!
$20
Daryl
1st lesson free!

I have a Hands approach to learning with an emphasis on real-world, vocational application. Hands on learning with an...

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
Fort Lauderdale
Increase your productivity Exponentially with Microsoft Office Software and Windows Tutoring n- Fort Lauderdale
$60
Julie
1st lesson free!

If I'm teaching a class, we have explanations and definitions of terms, a demonstration of the procedures and then students...

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
Cherry Hill
I am 25+ year IT professional master in Microsoft Office. I love to help you!
$50
David
1st lesson free!

I teach thru doing. I like to use real life examples to demonstrate concepts. I will adjust my lesson to the students...

Lessons by webcam In-person lessons Approved profile
Maricopa
Experienced Systems Engineer offering help with beginner to advanced excel concepts from formulas to macros
$14
Aaron
1st lesson free!

I base my classes on a per case basis to apply the concepts need to perform in the students specific job function. I believe...

Lessons by webcam In-person lessons Approved profile
Smithfield
Did you just get a new job at an office? Nervous about your computer skills? Let me help you learn the things you need to succeed!
$20
Oakley
1st lesson free!

I teach in a very fluid and personalized way. I’ll make sure you understand what’s being taught and go at a pace that...

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
Request a lesson