UrbanPro
true
true

Ankur Sharma

Magarpatta City, Hadapsar, Pune, India - 411013

Ankur Sharma Microsoft Excel trainer in Pune

Featured

Ankur Sharma

Facilitator - I am an Experienced Facilitator Committed...

Magarpatta City, Hadapsar, Pune, India - 411013.

17 Students taught

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

Details verified of Ankur Sharma

Identity

Education

Know how UrbanPro verifies Tutor details

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

Overview

(1) 11+ Years of Professional Experience - from MNCs to Entrepreneurship to Start-ups
(2) Years of hands-on Experience of using MS Excel
(3) 6 Professional Certifications in MS Excel
(4) Curriculum will be designed as per Your current MS Excel knowledge status and Your requirement
(5) Less Theory and More Practice during Sessions
(6) Support During Training and After Training.

Languages Spoken

Hindi Mother Tongue (Native)

English Proficient

Education

Lucknow Christian College (Lucknow University) 2004

Bachelor of Commerce (B.Com.)

simplilearn 2017

Business Analytics with Excel

.in Learning 2017

Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

edX 2017

EX101x: Data Analysis: Take it to the MAX()

edX 2017

Data Analysis: Visualization and Dashboard Design

Udemy 2018

Excel Dashboards: Build a Dashboard from Scratch

Udemy 2019

Excel VBA: Macros foundations for Beginners

Udemy 2020

Advanced Sql + MySql for Analytics Business Intelligence

Address

Magarpatta City, Hadapsar, Pune, India - 411013

Verified Info

ID Verified

Education Verified

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

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

Advanced Excel, Basic Excel

Teaching Experience in detail in Microsoft Excel Training classes

(1) Creating Customized Training Curriculum (2) Creating Reference Notes (3) Imparting Training

Documents (5)

Certificate: Data Analysis (Take...

Certificate: Data Analysis (Visualization...

Certificate: Cert Prep Excel-2016...

Certificate: Business Analytics...

Certificate: Build a Dashboard from...

Reviews (9)

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

5 out of 5 9 reviews

Ankur Sharma https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/5812077-small.jpg Magarpatta City, Hadapsar
5.0059
Ankur Sharma
P

"Amazing learning experience, examples given during sessions were very informative and comprehensive conceptually very strong, would highly recommend. "

Ankur Sharma
N

"Mr Ankur, is a excellent trainer, i love the way he is teaching If anyone wants to learn excel I would recommend them to try out one session with him. He tailor the pace and content based on the need of the learner. "

Ankur Sharma
K

"Thank you Sir for your hard work in helping me to develop my skills in MS-EXCEL.Your patience and commitment have been of a great help. Your expertise in teaching has put my mind at ease.You have a great talent of putting things straight into the head of student.The notes you provide are incomparable.The knowledge you provide besides the class is something which I really appreciate.Thank-you for putting so much effort and making new assignments,notes and what not.You have made me so comfortable with Excel.And u have always tried to maintain a comfort zone in between the classes.Always being prepared before the class with new assignments is really a commendable job.Your work shows your hardwork. "

Ankur Sharma
V

"I took classes with Ankur sir, and trust me he’s the best teacher when it comes to excelling. His way of teaching is amazing as he creates an atmosphere which fosters learning along with making it comfortable for us to grasp all the knowledge. All the efforts put by him into making questions, notes and problem solving are really commendable. He makes you feel confident about yourself and the subject by proving ample innovative questions to solve and providing the important sources along with. So, if you want to learn excel comprehensively, Ankur sir is the best. "

Have you attended any class with Ankur? Write a Review

FAQs

1. What Excel features do you teach?

Advanced Excel and Basic Excel

2. Which classes do you teach?

I teach Microsoft Excel Training Class.

3. Do you provide a demo class?

Yes, I provide a paid demo class.

4. How many years of experience do you have?

I have been teaching for 6 years.

Lessons (13)

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

02/07/2020
1 0
0
Tips - How to put PivotTable Field List back at its Original Position?

Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...

01/04/2020
2 0
1
Hide Duplicate Values & Apply Borders Using Conditional Formatting

Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

02/01/2020
1 0
0

Answers by Ankur (2)

Answered on 10/04/2020 IT Courses/MS Office Software Training/Microsoft Excel Training

Hi Hemant, Few Professionals have already quoted Timeline, Cost to Learn MS Excel. I will share that is in addition to Time and Cost. Point 1) Through Offline OR Online medium, You could be Introduced to MS Excel. As applicable to most Professional Courses, the Learning will, however, continue even after... ...more

Hi Hemant,

Few Professionals have already quoted Timeline, Cost to Learn MS Excel. I will share that is in addition to Time and Cost.

Point 1) Through Offline OR Online medium, You could be Introduced to MS Excel.

As applicable to most Professional Courses, the Learning will, however, continue even after You are introduced to MS Excel. MS Excel is Vast. MS Excel is Deep.

Point 2) Hemant, when You are Learning MS Excel, please focus on one aspect. It, in My humble opinion, is essential:

Do Not just focus on learning VLOOKUP, HLOOKUP, XLOOKUP, IF etc.

i) Focus on KNOWING MS Excel - MS Excel में क्या किया जा सकता है

ii) Focus on Knowing the Immense Possibilities of MS Excel - MS Excel की असीम संभावनाओं को जानने की कोशिश करना

Hemant, solutions to most Qs are available free-of-cost on Google. The Day You Come to Know the Immense Possibilities of MS Excel, You would have found Solution to most of Your Qs in MS Excel.

(i) Go on Google

(ii) Type the Correct Question

(iii) You get the Solution to Your Q

Point 3) To be able to gain Proficiency in MS Excel:

i) When You are working on MS Excel, always ask

- Is there a more efficient way to complete this task?

- Is there any other way this task could be achieved?

- What else could be done to add value to this task?

ii) You got to have good Logical Aptitude

- Sudoku

- Rubik's Cube

- Puzzles, etc. help in developing Logical Aptitude.

MS Excel is Fun, Engaging, Challenging!

ALL the BEST!

Answers 60 Comments
Dislike Bookmark

Answered on 26/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How do I put a password to an excel sheet?

Hi Ashish, Step 1) click on Review tab Step 2) in Changes group, click on Protect Sheet Step 3) enter Password Step 4) re-enter Password Note: in Step 2, You can select Option(s) for the User of the worksheet For more support on MS Excel, please refer https://support.office.com/ Hope, this helps. Thank... ...more

Hi Ashish,

Step 1) click on Review tab

Step 2) in Changes group, click on Protect Sheet

Step 3) enter Password

Step 4) re-enter Password

Note: in Step 2, You can select Option(s) for the User of the worksheet

For more support on MS Excel, please refer https://support.office.com/

Hope, this helps.

Thank You!

Answers 2 Comments
Dislike Bookmark
Microsoft Excel Training classes 5.0

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

Advanced Excel, Basic Excel

Teaching Experience in detail in Microsoft Excel Training classes

(1) Creating Customized Training Curriculum (2) Creating Reference Notes (3) Imparting Training

Answers by Ankur Sharma (2)

Answered on 10/04/2020 IT Courses/MS Office Software Training/Microsoft Excel Training

Hi Hemant, Few Professionals have already quoted Timeline, Cost to Learn MS Excel. I will share that is in addition to Time and Cost. Point 1) Through Offline OR Online medium, You could be Introduced to MS Excel. As applicable to most Professional Courses, the Learning will, however, continue even after... ...more

Hi Hemant,

Few Professionals have already quoted Timeline, Cost to Learn MS Excel. I will share that is in addition to Time and Cost.

Point 1) Through Offline OR Online medium, You could be Introduced to MS Excel.

As applicable to most Professional Courses, the Learning will, however, continue even after You are introduced to MS Excel. MS Excel is Vast. MS Excel is Deep.

Point 2) Hemant, when You are Learning MS Excel, please focus on one aspect. It, in My humble opinion, is essential:

Do Not just focus on learning VLOOKUP, HLOOKUP, XLOOKUP, IF etc.

i) Focus on KNOWING MS Excel - MS Excel में क्या किया जा सकता है

ii) Focus on Knowing the Immense Possibilities of MS Excel - MS Excel की असीम संभावनाओं को जानने की कोशिश करना

Hemant, solutions to most Qs are available free-of-cost on Google. The Day You Come to Know the Immense Possibilities of MS Excel, You would have found Solution to most of Your Qs in MS Excel.

(i) Go on Google

(ii) Type the Correct Question

(iii) You get the Solution to Your Q

Point 3) To be able to gain Proficiency in MS Excel:

i) When You are working on MS Excel, always ask

- Is there a more efficient way to complete this task?

- Is there any other way this task could be achieved?

- What else could be done to add value to this task?

ii) You got to have good Logical Aptitude

- Sudoku

- Rubik's Cube

- Puzzles, etc. help in developing Logical Aptitude.

MS Excel is Fun, Engaging, Challenging!

ALL the BEST!

Answers 60 Comments
Dislike Bookmark

Answered on 26/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

How do I put a password to an excel sheet?

Hi Ashish, Step 1) click on Review tab Step 2) in Changes group, click on Protect Sheet Step 3) enter Password Step 4) re-enter Password Note: in Step 2, You can select Option(s) for the User of the worksheet For more support on MS Excel, please refer https://support.office.com/ Hope, this helps. Thank... ...more

Hi Ashish,

Step 1) click on Review tab

Step 2) in Changes group, click on Protect Sheet

Step 3) enter Password

Step 4) re-enter Password

Note: in Step 2, You can select Option(s) for the User of the worksheet

For more support on MS Excel, please refer https://support.office.com/

Hope, this helps.

Thank You!

Answers 2 Comments
Dislike Bookmark

Lessons (13)

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

02/07/2020
1 0
0
Tips - How to put PivotTable Field List back at its Original Position?

Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...

01/04/2020
2 0
1
Hide Duplicate Values & Apply Borders Using Conditional Formatting

Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

02/01/2020
1 0
0

Contact

Load More

Ankur Sharma describes himself as Facilitator - I am an Experienced Facilitator Committed to Your Learning!. He conducts classes in Microsoft Excel Training. Ankur is located in Magarpatta City, Hadapsar, Pune. Ankur takes Regular Classes- at his Home and Online Classes- via online medium. He has 6 years of teaching experience . Ankur has completed Bachelor of Commerce (B.Com.) from Lucknow Christian College (Lucknow University) in 2004. He is well versed in English and Hindi. Ankur has got 9 reviews till now with 100% positive feedback.

X
X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Ankur

Let Ankur 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.

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