UrbanPro
true
true

Mukesh Chopra

Malviya Nagar, Delhi, India - 110017

Mukesh Chopra Microsoft Excel trainer in Delhi

Platinum

Mukesh Chopra

IT Professional Trainer with more than 30 years of...

Malviya Nagar, Delhi, India - 110017.

54 Students taught

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

Details verified of Mukesh Chopra

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 am an enthusiastic trainer with a total 30 years of IT-experience Believing in performing training coaching of individuals directed towards society/nation building. Provided training in companies like IBM, Capgemini US, NIIT Technologies, LG Electronics, American Express GBT, BIMS, Shapoorji Palonji, ShareKhan

Specialization in:
- Official Microsoft training
- Effective NLP Life Coaching,
- MBTI training certification,
- PMP, ITIL certified Quality project change management
- Software Solution designer using Cloud Mobility technology.

Languages Spoken

Hindi

English

Education

Delhi University 1989

Bachelor of Science (B.Sc.)

Apple 1990

Diploma in Computer Studies

Address

Malviya Nagar, Delhi, India - 110017

Verified Info

ID Verified

Education Verified

Phone Verified

Email Verified

Facebook 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

Tutor Of The Month Award Winner December 2020

For Microsoft Excel Training in Delhi

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

20

Teaches following Excel features

Excel Macro Training, Basic Excel, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

Following are the topics planned to be covered: MS Excel : Overview of Basics - Introduction to MS EXCEL - MS Excel Interface Data Management - Data Creation, - Data Editing / updation - Cell Referencing (Absolute & Relative) - Data Formatting & Conditional Formatting Data Sorting & Filtering - Sorting tables - Filtering data using Auto Filter Data Validation & Forecasting - Data Validation - What if Analysis Working with Excel Functions - Mathematical Functions - Logical Functions - including Vlookup, Hlookup etc - String Functions Working with Reports - Pivot Tables - Pivot Charts - Multiple sheets Data Consolidation - Sub-Total creation in Pivots - Creation of Dashboards Time Saving techniques in Excel - Working with Ready made Excel Templates - Using Worksheet Short Cuts

Reviews (27)

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

4.9 out of 5 27 reviews

Mukesh Chopra https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/7036504-small.jpg Malviya Nagar
4.90527
Mukesh Chopra
D

"It was nice learning experience with Mukesh. The way of teaching and the topics cover really shows great experience. Post these five days of MPP learning experience i got fully confident about project plan creation and project tracking. Good mentor having good teaching experience. Thank you Urbanpro for providing such a excellent mentor . "

Reply by Mukesh

Hi Deepak, Thank you for sharing your valuable feedback on Microsoft Project. I am glad that my training sessions supported and helped you clear your doubts. Please feel free to reach out to me in case you need any further support in the future.

Mukesh Chopra
N

"I had an amazing experience for excel classes with you. Mukesh you ensured all the doubts are cleared and not for a single time I felt you hurrying up. Infact you handled my queries so patiently. Through this classes I learnt many new shortcuts,different tools for presenting huge data,Data protection etc etc. Which will be very beneficial in my day to day work life. I highly recommend you for your knowledge. "

Reply by Mukesh

Hi Nilakshi, Thank you for sharing your valuable feedback on MS Excel. I am indeed very glad that my sessions helped you. Please feel free to reach out to me in case you need any further support. Also do recommend my training with your colleagues so that they may also benefit.

Mukesh Chopra
S

"Mukesh Sir is an amazing teacher, he made excel look easy. He makes the concept clear and provides regular assistant. "

Reply by Mukesh

Hi Sonali, Thank you for sharing your valuable feedback. I am glad and deeply satisfied to know that my sessions helped you. Please feel free to reach out to me in case you need any further support any time on the topics studied.

Mukesh Chopra
M

"The training was conducted very diligently. Mukesh's way of explaining things is lucid. He is willing to listen to questions and answer them. Never did one feel that the training is a one way street, as Mukesh always made it a point to ask for our thoughts. His demeanour is calm, cool and collected, which goes a long way in making the sessions easy to understand. I have a few humble suggestions for further enhancing the sessions and the output therefrom: 1. The training recordings should be renamed as per the topics covered during the sessions 2. If a brief schedule of all the sessions could be provided at the start, it would be a big help. It would allow the attendees to know what will.be picked up in what session and they can accordingly prepare before coming into the sessions 3. Assignments/exercises to be provided at the end of each session All in all, I believe at the training was useful for me and I will recommend Mukesh and the training to other individuals as well. "

Reply by Mukesh

Thank you Faisal for your valuable feedback and am extremely happy to know that you were able to benefit from my training. I also appreciate you sharing your candid inputs for enhancing the training program, which I shall be incorporating. Further, I would be all the more delighted to be able to share my extended support to you in the topics that we have learnt. Do keep in touch.

Have you attended any class with Mukesh? Write a Review

FAQs

1. What Excel features do you teach?

Excel Macro Training, Basic Excel and Advanced Excel

2. Which classes do you teach?

I teach Life Skill Coaching, MS Access, MS Office Software Training, MS Outlook, MS Project, MS Word, Microsoft Excel Training, Microsoft PowerPoint Training and Soft Skills Training Classes.

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 20 years.

Lessons (1)

Excel Conditional Formatting

In this video, learn about Conditional Formatting, Creating Conditional Formatting Rules, Use Conditional Formatting Presets, Managing & Removing Conditional Formatting.

06 Jul
0 0
0

Answers by Mukesh (2)

Answered on 01/12/2020 Tuition/BTech Tuition/Engineering Drawing & Graphics

Hi Priyanka, A Projection is an anticipated data that is forecasted for a specific set of conditions. As its a predicted set of information, it is not a REAL value that is currently in place. Whereas when we talk about the View, it refers to the real data that is existing and reflects the same. For... ...more

Hi Priyanka, 

Projection is an anticipated data that is forecasted for a specific set of conditions. As its a predicted set of information, it is not a REAL value that is currently in place. 

Whereas when we talk about the View, it refers to the real data that is existing and reflects the same. For instance, when you are referring about a projection on a data, its dependent on the current set of data -- for example, the projected value of population after ten years can be calculated based on the past set of information/values. Whereas when we refer about a View, we would take a particular instant and fetch the exact information and data that is currently residing, which is then reflected.

Answers 5 Comments
Dislike Bookmark

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

In A1 Cell write your Date of birth. Now in A3 Cell write the formula =DATEDIF(A1,Today(),"Y")&" Years, "&DATEDIF(A1,Today(),"YM")&" Months and "&DATEDIF(A1,Today(),"MD")&" Days" . This will give the result as "__ Years, __ Months and __ Days"
Answers 26 Comments
Dislike Bookmark
Microsoft Excel Training classes 5.0

Tutor Of The Month Award Winner December 2020

For Microsoft Excel Training in Delhi

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

20

Teaches following Excel features

Excel Macro Training, Basic Excel, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

Following are the topics planned to be covered: MS Excel : Overview of Basics - Introduction to MS EXCEL - MS Excel Interface Data Management - Data Creation, - Data Editing / updation - Cell Referencing (Absolute & Relative) - Data Formatting & Conditional Formatting Data Sorting & Filtering - Sorting tables - Filtering data using Auto Filter Data Validation & Forecasting - Data Validation - What if Analysis Working with Excel Functions - Mathematical Functions - Logical Functions - including Vlookup, Hlookup etc - String Functions Working with Reports - Pivot Tables - Pivot Charts - Multiple sheets Data Consolidation - Sub-Total creation in Pivots - Creation of Dashboards Time Saving techniques in Excel - Working with Ready made Excel Templates - Using Worksheet Short Cuts

Microsoft PowerPoint 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 PowerPoint Training classes

20

Teaching Experience in detail in Microsoft PowerPoint Training classes

Following are the topics that I shall cover in the PowerPoint Program   1. Introduction a. Getting Started with PowerPoint i. Navigate the PowerPoint Environment ii. View and Navigate a Presentation iii. Create and Save a PowerPoint Presentation iv. Use PowerPoint Help b. Developing a PowerPoint Presentation i. Select a Presentation Type ii. Edit Text iii. Build a Presentation c. Performing Advanced Text Editing Operations i. Format Characters ii. Format Paragraphs iii. Format Text Boxes 2. Intermediate a. Adding Graphical Elements to Your Presentation i. Insert Images ii. Insert Shapes iii. Create SmartArt iv. Insert Icons and 3D Models v. Arrange and Size Object b. Modifying Objects in Your Presentation i. Edit Objects ii. Format Objects iii. Format Icons iv. Format 3D Models v. Group Objects vi. Arrange Objects vii. Animate Objects viii. Customize SmartArt c. Managing Slides i. Sequencing Slides ii. Duplicating Slides iii. Deleting Slides iv. Hiding Slides 3. Advanced a. Adding Tables to Your Presentation i. Create a Table ii. Format a Table iii. Insert a Table from Other Microsoft Office Applications b. Adding Charts to Your Presentation i. Create a Chart ii. Format a Chart iii. Insert a Static Chart from Microsoft Excel iv. Insert a Live Chart from Microsoft Excel c. Applying Multimedia Effect to Your Presentation i. Apply Transitions ii. Apply Sound iii. Apply Different Animations to Individual Objects iv. Sequence & Automate Animations on Slides d. Time Saving Techniques i. Using Templates ii. Using Short-Cuts iii. Using Design Ideas e. Preparing to Deliver Your Presentation i. Review Your Presentation ii. Using the Presenter View iii. Print Your Presentation iv. Deliver Your Presentation   The course would require the following - Computer/laptop - MS PowerPoint installed on system - Dedicated Internet connection - Zoom connection This is a minimum 3-days (1-hour per day) training program for PowerPoint. You may take as many days of training that you want till you dont get confidence in the listed topics taught. I shall NOT be charging you additional fees for the additional days. After the completion of the course, I will be giving you Free lifetime support on clarification of doubts on the taught topics. In case you have specific requirements, the course content and cost can be altered / customised accordingly. Do let me know if you want any further clarification.

MS Project Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS Project Training

20

Courses in MS Project Training

MS Office Software Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS Office Software Training

20

Life Skill Coaching 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Life Skill Coaching

20

Teaching Experience in detail in Life Skill Coaching

I am a certified Life Coach and Executive Coach and I share support and knowledge about how to manage stress and take positive actions using NLP coaching techniques.

MS Access Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS Access Training

20

Teaching Experience in detail in MS Access Training

Following are the topics planned to be covered: MS Access: Overview of Basics - Introduction to MS Access - Introduction to the Screen / Interface Database Creation - Table creation - Primary and Foreign Key Creation - Database linkages using Keys - Data Management - Reporting Procedures - Use of Filters - Use of Group - DBMS Management using various SQL Commands - Data reporting process using SQL commands - Database and Table management processes The course would require the following - Computer/laptop - MS Accessinstalled on system - Dedicated Internet connection - Zoom connection This is a minimum 6-days (1-hour per day) training program for MS Access.

Soft Skills Training Classes 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Soft Skills Training Classes

20

Softskills Training Offered

Decision Making Skills Training , Creative Problem Solving Skills Training , Time Management Training , Team Building Training , Leadership Training , Body Language Training , NLP Training - Confidence Building , Goal Setting Training , Conflict Management, Behavioral Skills Training, Presentation Skills Training

MS Outlook Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS Outlook Training

20

Courses in MS Outlook Training

MS Word Training 5.0

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MS Word Training

20

Teaching Experience in detail in MS Word Training

Have been using MS Word for more than 20 years specially using all the varieties of functionalities of MS Word. For the training I would be taking following topics into consideration: MS Word : Overview of Basics - Introduction to MS Word - MS Word Interface Document Creation - Document Creation - Varieties of Documents & Design - Inserting Images, Hyperlinks - Creation and formatting of Text - Creation of Static Data & Graph representation Print Document Hand-outs Working with Documents Automation - Document Dictation Time Saving techniques in MS Word - Using MS Word Short Cuts

Courses in MS Word Training

Answers by Mukesh Chopra (2)

Answered on 01/12/2020 Tuition/BTech Tuition/Engineering Drawing & Graphics

Hi Priyanka, A Projection is an anticipated data that is forecasted for a specific set of conditions. As its a predicted set of information, it is not a REAL value that is currently in place. Whereas when we talk about the View, it refers to the real data that is existing and reflects the same. For... ...more

Hi Priyanka, 

Projection is an anticipated data that is forecasted for a specific set of conditions. As its a predicted set of information, it is not a REAL value that is currently in place. 

Whereas when we talk about the View, it refers to the real data that is existing and reflects the same. For instance, when you are referring about a projection on a data, its dependent on the current set of data -- for example, the projected value of population after ten years can be calculated based on the past set of information/values. Whereas when we refer about a View, we would take a particular instant and fetch the exact information and data that is currently residing, which is then reflected.

Answers 5 Comments
Dislike Bookmark

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

In A1 Cell write your Date of birth. Now in A3 Cell write the formula =DATEDIF(A1,Today(),"Y")&" Years, "&DATEDIF(A1,Today(),"YM")&" Months and "&DATEDIF(A1,Today(),"MD")&" Days" . This will give the result as "__ Years, __ Months and __ Days"
Answers 26 Comments
Dislike Bookmark

Lessons (1)

Excel Conditional Formatting

In this video, learn about Conditional Formatting, Creating Conditional Formatting Rules, Use Conditional Formatting Presets, Managing & Removing Conditional Formatting.

06 Jul
0 0
0

Mukesh Chopra describes himself as IT Professional Trainer with more than 30 years of experience in IT Industry. He conducts classes in Life Skill Coaching, MS Access and MS Office Software Training. Mukesh is located in Malviya Nagar, Delhi. Mukesh takes at students Home and Online Classes- via online medium. He has 20 years of teaching experience . Mukesh has completed Bachelor of Science (B.Sc.) from Delhi University in 1989. He is well versed in Hindi and English. Mukesh has got 27 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 Mukesh

Let Mukesh 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