UrbanPro
true
Vikrant C. Microsoft Excel trainer in Delhi

Vikrant C.

Excel Champ

Safdarjung, Delhi, India - 110029.

Contact
Referral Discount: Get ₹ 500 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Vikrant C.

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

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

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.

Answers by Vikrant C. (1)

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

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

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

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

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

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.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

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