UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕
true

Overview

I have 6 years of experience and working as an senior data analyst in Gurgaon in MNC company and stay in green park Delhi and having an excellent knowledge of the Excel features and advance excel functions like vlookup,hlookup,index,match,offset etc,Pivot tables automating excel files using Vba macros.
Knowledge of useful shortcuts in excel and more then 100 functions in excel and Formula merging and making excel data models.
Data designing, data formatting, more than 100 advance excel functions, advance filter, sorting, validation, formula merging, automation of reports, raw data or sample data to practice each function, test papers to practice for interviews.

Languages Spoken

English

Hindi

Punjabi

Education

Lovely Professional University Jalandhar 2010

Bachelor of Computer Applications (B.C.A.)

Address

Safdarjung, Delhi, India - 110029

Verified Info

Phone Verified

Email Verified

Report this Profile

✕
x

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Teaches

Microsoft Excel Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

6

Teaches following Excel features

Excel Macro Training

Reviews

No Reviews yet!

FAQs

1. What Excel features do you teach?

Excel Macro Training

2. Which classes do you teach?

I teach Microsoft Excel Training Class.

3. Do you provide a demo class?

Yes, I provide a free demo class.

4. How many years of experience do you have?

I have been teaching for 6 years.

Contact

Answers by Vikrant C. (1)

Answered on 17/12/2015 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

How to use the h look up in excel worksheet ???

Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. SYNTAX:=HLOOKUP(lookup_value, table_array, row_index_num, ) Evrything will be same as vlook up except a difference that it works horizontally and vlook... ...more
Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. SYNTAX:=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Evrything will be same as vlook up except a difference that it works horizontally and vlook up works vertically.
Answers 32 Comments
Dislike Bookmark

Contact

Teaches

Microsoft Excel Training classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

6

Teaches following Excel features

Excel Macro Training

No Reviews yet!

Answers by Vikrant C. (1)

Answered on 17/12/2015 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

How to use the h look up in excel worksheet ???

Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. SYNTAX:=HLOOKUP(lookup_value, table_array, row_index_num, ) Evrything will be same as vlook up except a difference that it works horizontally and vlook... ...more
Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. SYNTAX:=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Evrything will be same as vlook up except a difference that it works horizontally and vlook up works vertically.
Answers 32 Comments
Dislike Bookmark

Contact

Vikrant C. describes himself as Excel Champ. He conducts classes in Microsoft Excel Training. Vikrant is located in Safdarjung, Delhi. Vikrant takes at students Home and Regular Classes- at his Home. He has 6 years of teaching experience . Vikrant has completed Bachelor of Computer Applications (B.C.A.) from Lovely Professional University Jalandhar in 2010. He is well versed in English, Hindi and Punjabi.

X
X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Vikrant C.

Let Vikrant C. know you are interested in their class

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved