Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Microsoft Excel Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: google hangout,skype.teamviewer

Course ID: 20115

Course type: Online Instructor led Course

Platform: google hangout,skype.teamviewer

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

About the Course

********************************************
Learn From Industry Expert.

If you want to excel in MS-Excel, then you should know Formula and Functions are basic building block to MS-Excel.

In this training session, I am going to cover, how you can improve work performance by using numerous formulas and functions in MS- Excel.

How to use formula with other formulas?
What component can be replaced with other components?
How to write formulas to avoid error?
Evaluation of formula.
And 20 MOST IMPORTANT SHORTCUT KEYS IN EXCEL 2007 and EXCEL 2010.

NOTE:
Excel Training is all about hands-on session.
Guided learning.
Practice Exercises.
Post Training Support.
Don't hesitate to clear your queries.

Topics Covered

Module 1: Overview of the Basics
Difference between Excel 2003 and Excel 2007 Screen
Interacting with Excel(2007) screen
Special feature in MS-Excel that can help you excel.

Module 2: Cell Reference and its usage in formulas
Absolute and Relative and Mixed cells reference
Preferred References in Formula

Module 3 A: Working with Functions
Writing conditional expressions (using IF, NESTED IF)
Using logical functions (AND, OR, NOT, COMPOUND IF)
Other Functions:

Date and time functions:
Date
Today
Now
Day
Month
Year
Time
Hour
Minute
Second
Weekday
DateDif
Networkdays
WORKDAY

Text Functions:
Upper
Lower
Proper
Left
Right
Mid
Concatenate
Len
Exact
Search
Find
Clean
Replace
Substitute
Char
Code
Dollar
T
TEXT

Database functions:
DAVERAGE
DSUM
DCOUNT
DCOUNTA
DGET
DMAX
DMIN

Mathematical Functions:
Abs
Int
Mod
Sqrt
Power
Round
Trunc
Fixed
Sum
Sumif
Count


Statistical Functions
CountA
Countblank
Min
Max
Small
Large

Information Functions
IsBlank
IsError
Isnumber
Istext


VLOOKUP, HLOOKUP, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH

Module 3 B: Evaluation of Formula
Understanding Formula Evaluation concept
Using "Evaluate Formula"

Module 4: Handling Errors
Types of Error
Ways of handling Errors

Module 5: 20 Shortcut keys combination for professionals

Who should attend

Who should attend

Management Professional
BPO/KPO employee
HR, MIS personnel
Business person
Commerce field, Would be C.A.
Sales/HR.

Pre-requisites

----

What you need to bring

Laptop-if you have one.
Not necessary"""

Key Takeaways

Knowledge to manage your data.
Knowledge specific to Business Solution no matter which field you are in.

Date and Time

Not decided yet.

About the Trainer

Harish Arekar picture

Avg Rating

Reviews

Students

Courses

Harish Arekar

Master of Science ( Information technology )

Currently working as Senior Software Engineer in one of the well renowned MNC.
Have taken private tutions for rubik's cube

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more