UrbanPro
true
Mayukh B. Microsoft Excel trainer in Kolkata

Featured

Mayukh B.

Versatile Trainer

Bonhooghly Government Colony, Kolkata, India - 700108.

Verified Certified 37 Students

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

Details verified of Mayukh B.

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 M.com and an MBA (Fin), expert in teaching Computer Basics, Ms Office, Especially on Advance Excel. I am regularly Providing Online Training in Advance Excel to various students all over India. I was also a corporate trainer and regularly conducted training in different Industries including branded MNCs. I use SKYPE as my medium of training which is very much user friendly for screen sharing and teaching. I never charge any advance payment from my student and follow only weekly payments on each weekend based on the total hours of sessions conducted for that week.
I am also teaching Commerce papers to school levels as well as college-level students. I am also a seasoned trainer of spoken English especially in corporate communication. My spoken English training is mostly over the phone which includes sharing study materials, VDOs through WhatsApp.
My ranking In Urban Pro as an Advance Excel Trainer In Kolkata is 1st.

Languages Spoken

Bengali Mother Tongue (Native)

Hindi Proficient

English Proficient

Education

Calcutta University 1988

Master of Commerce (M.Com.)

ICWA 1988

Costing - Intermediate

Udemy 2018

Top Excel Tips And Formulas In Advance Excel

Address

156/A/65, BT Rd, Dunlop, Saket Nagar, Bonhooghly Government Colony

Bonhooghly Government Colony, Kolkata, India - 700108

Landmark: Humpty Dumpty K.G School

Verified Info

ID Verified

Education Verified

Phone Verified

Email Verified

Facebook Verified

Taught Students from these Schools

A

Adamas International School

B T Road, Kolkata

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
22 Students

UrbanPro Certified Tutor

For Microsoft Excel Training

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

Basic Excel, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

I am very happy to share that I am an Experienced Corporate trainer in Basic to Advance Excel from Kolkata-West Bengal and regularly providing Online as well as offline training to my students. I use Skype as my medium of my online training. My Corporate training includes big MNCs like "ITC LTD". Most of my students are working professionals and scattered all over India. Some of them are even placed abroad. The greatest advantages of my training are as follows : 1) I always share my Excel Files at the end of my every session. 2) I provide exercises on each topic as home assignment for practice and provide the solutions later. This immensely help each of my student to understand each function of Excel in depth. 3) I am always flexible about my timings and conduct the sessions as per student's matching time. 4) My rates are Hourly and payments are on weekly basis. 5) For Online student payments may be made in advance on weekly basis. 6) I am available to my students for discussion on any topic about my shared files even after 6 months or year or so. 7) Please call me or WhatsApp me in my number for any suggestion or immediate assistance on MS Excel.

Spoken English classes
3 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Spoken English classes

5

Age groups catered to

Above 25 yrs, 16 yrs to 25 yrs

Levels of Spoken English I teach

Basic

Lived or Worked in English Speaking Country

No

Awards and Recognition

No

Certification

None

Profession

Working Professional

Language of instruction offered

Hindi to English, English to English

Curriculum Expertise

CBSE, State, ICSE/ISC

Citizen of English Speaking Country

No

Class strength catered to

Group Classes, One on one/ Private Tutions

Teaching done in

Basic Spoken English, English Grammar, Vocabulary

Teaching at

Home

Teaching Experience in detail in Spoken English classes

I am an experienced trainer of spoken English and corporate communication located at Kolkata. I am regularly providing training to my students both on face to face mode as well as over phone. I regularly conduct group classes at my residence on Wednesday, Friday and Sunday. My location is Dunlop Bridge Crossing which is well connected with Metro, Road Transport or Train communications.

Class 11 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 11 Tuition

5

Board

State, ISC/ICSE, CBSE

State boards taught

West Bengal State Board

Preferred class strength

Group Classes, One on one/ Private Tutions

ISC/ICSE Subjects taught

Commerce, Accounts, Computer Science

CBSE Subjects taught

Business Studies, Accountancy, Economics

Taught in School or College

No

State Syllabus Subjects taught

Computer Science, Statistics, Business Studies, Accountancy

Teaching Experience in detail in Class 11 Tuition

1) Maximum 2 Days in aweek having a session duration of 1-1/2 hours to 2 hrs per day. 2) Take mock tests chapter of the subject matter at regular intervals to evaluate the progress of the student. 3) Always put focus on the completion of the syllabus. 4) Providing home asssignments on regular basis which sometimes put pressure on the student. 5) Weekly payment is mandatory for every student.

Class 12 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 12 Tuition

5

Board

State, ISC/ICSE, CBSE

ISC/ICSE Subjects taught

Commerce, Accounts, EVS

CBSE Subjects taught

Accountancy, Economics

Taught in School or College

No

State Syllabus Subjects taught

Chemistry, Computer Science, Business Studies, English, Mathematics, Physics, Accountancy, Biology

Teaching Experience in detail in Class 12 Tuition

1) Maximum 2 Days in aweek having a session duration of 1-1/2 hours to 2 hrs per day. 2) Take mock tests chapter of the subject matter at regular intervals to evaluate the progress of the student. 3) Always put focus on the completion of the syllabus. 4) Providing home asssignments on regular basis which sometimes put pressure on the student. 5) Weekly payment is mandatory for every student.

Class 9 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 9 Tuition

5

Board

CBSE, State, ICSE

CBSE Subjects taught

Information and Comunication Technology, Mathematics, Accountancy, Science, Computer Practices, Elements of business

ICSE Subjects taught

Physics, Computer Application, Mathematics, Biology, Commercial Studies, Commercial Applications, Chemistry

Taught in School or College

No

State Syllabus Subjects taught

Mathematics, Science, English

Class 10 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 10 Tuition

5

Board

CBSE, State, ICSE

CBSE Subjects taught

Information and Comunication Technology, Mathematics, Accountancy, Science, Computer Practices, Elements of business

ICSE Subjects taught

Physics, Computer Application, Mathematics, Biology, Commercial Studies, Commercial Applications, Chemistry

Taught in School or College

No

State Syllabus Subjects taught

Mathematics, Science, English

Bengali Speaking classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Bengali Speaking classes

5

Teaching Experience in detail in Bengali Speaking classes

I am a native Bengali speaker. I am at the same time fluent both in English as well as in Hindi. Therefore none of my students feel uncomfortable while interacting with me. I use to take classes for both for spoken English as well as Bengali. In case of Hindi Speaking students I translate the Bengali into their own language. I provide regular face to face as well as over phone training.

Reviews (14)

5 out of 5 14 reviews

Mayukh Basu https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/4457135-small.jpg Bonhooghly Government Colony
5.00514
Mayukh Basu
S

Microsoft Excel Training

"Great teacher. Very good experience during this training session. He is very helpful and an honest man. "

Mayukh Basu
S

Microsoft Excel Training

"Level of experience in (ms excel). Great opportunity to take lessons and finished exercises daily basis. Classes are based on such project as per the daily work life huddle faces during the day to day office work. A nice person as well. "

Mayukh Basu
J

Microsoft Excel Training

"I am extremely thankful to Sir for his constant encouragement and guidance. Sirs classes comprised all the essentials - personal attention, punctuality, out of the box tips and a strategic approach to each topic which helped to make the course extremely enriching and fun. I highly recommend him if you wish to learn about MS Excel. Thank you sir for being a great mentor. "

Reply by Mayukh

Thank you Jai for your nice comments. Despite several adverse situations you have continued your sessions seriously with smiling face. I am quite confident that you will overcome all of your professional hurdles in life with big smiles at your face.

Mayukh Basu
K

Microsoft Excel Training

"Mr.Basu is an amazing teacher. Punctual, diligent and masterful having perfect command over Microsoft Excel. Learning under him has been a very enlightening and fun experience. I highly recommend Mr.Basu's guidance to everyone hoping to be efficient with MS Excel. I will Mr.Basu all the best in his future endeavours. "

Reply by Mayukh

Thanks Krishiv for your comments. Out of the whole group you appeared to me the most sharp. You grasp any concept very fast and so we have progressed so fast during sessions. I pray for your superlative success in career after completion of your ongoing course at U.K.

Have you attended any class with Mayukh? Write a Review

FAQs

1. What Excel features do you teach?

Basic Excel and Advanced Excel

2. Which classes do you teach?

I teach Bengali Speaking, Class 10 Tuition, Class 11 Tuition, Class 12 Tuition, Class 9 Tuition, Microsoft Excel Training and Spoken English Classes.

3. Do you provide a demo class?

No, I don't provide a demo class.

4. How many years of experience do you have?

I have been teaching for 20 years.

Answers by Mayukh (12)

Answered on 18/02/2019 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Dear Binayak, There are four different ways we can convert a number to a text in excel, 1) Put an Apostrophe(') to change Number to Text Format Steps : Go to the cell that contains the number. Open it in Edit mode of the cell – (Pressing F2 Key or Double click) Put an Apostrophe(‘) before... ...more

Dear Binayak,

 There are four different ways we can convert a number to a text in excel,

1) Put an Apostrophe(') to change Number to Text Format

Steps :

  1. Go to the cell that contains the number.
  2. Open it in Edit mode of the cell – (Pressing F2 Key or Double click)
  3. Put an Apostrophe(‘) before the number.

 2) Changing the Formatting of Cell option to “Text”

Steps :

  1. Select the Cell or range of cells that contains the Number
  2. Go to Number Formatting – ( Pressing Ctrl+1)
  3. Select “Text” which is 3rd from bottom in the opened dialog box and press ente.

3) Using Excel “Text” Function

Steps:

  1. If the number is in A1 Cell then go to B1 Cell in Excel
  2. Put the formula =Text(A1,”0”) in B1 Cell and press Enter.
  3. B1 Cell convers and show the Number(Contained in A1 Cell) in Text Form.
  4. The TEXT function converts a numeric value to formatted text, thus the result cannot be calculated.

4) Convert numbers to text in Excel with Text to Columns wizard:

Steps: 

  1. At first Select the column that contains the numbers.
  2. Go to the “Data Tab”
  3. Select “Text to Columns” icon from that Menu
  4. Go through that wizard and ensure that the Radio Button “ Text” must be selected.
  5. Click on Finish.
Answers 8 Comments
Dislike Bookmark

Answered on 16/12/2018 Learn IT Courses/MS Office Software Training +1 IT Courses/MS Office Software Training/Microsoft Excel Training

Ankit, Prerviously Grouping of Columns and rows were not available in Google Sheets, but from 13th April-2018 this drawback has been removed. So, now you can easily make groupng of rows or columns in Google Sheets as we are doing in Excel. That means frustration period is over. Now how to group rows... ...more

Ankit,

Prerviously Grouping of Columns and rows were not available in Google Sheets, but from 13th April-2018 this drawback has been removed. So, now you can easily make groupng of rows or columns in Google Sheets as we are doing in Excel. That means frustration period is over.  

Now how to group rows and columns in Google Sheets ? Steps are very simple like following :-

1) At first select the entire rows or colums which we want to group.

2)Then right click  and select the option "Group Row Numbers 4-15" - Say Grouping of Rows 4 to 15 or "Group Column B-E(Say)" - Say for Grouping of columns B to E. 

3) Now Click on the Minus Sign (-) to collapse the grouped rows and columns with Plus Sign(+) appearing.

4) Again click on Plus Sign (+) to expand the grouped rows or colums. 

Hope you are satisfied with the answer.

 

Answers 1 Comments
Dislike Bookmark

Answered on 05/11/2018 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Data validation is an important function available in Excel. It basically prevents any wrong input entry from the end of data entry operator or user. Most frequently used restrictions are as follows : 1) Enter the input data only through selection from a predetermined drop down list. This ensures zero... ...more

Data validation is an important function available in Excel. It basically prevents any wrong input entry from the end of data entry operator or user. Most frequently used restrictions  are as follows :

1) Enter the input data only through selection from a predetermined drop down list. This ensures zero spelling mistakes while entering.

2) Restrics data entry within a specified range of values (Say not below 10 or not more than 20). So, the said input data field rejects any input value entry which is not falling within that predefind data range.

3) Ensures Input data entry within specified dates or within a specified time period. So, the input data field acceps only the date entered which is falling in between the specified dates previously determined by the user (say within 01/01/18 to 30/09/18)

4) It ensures text data entry within a specified number of characters (Say upto 25 characters or letters).

Error message or warning messages can be displayed for any wrong input entry in data validated fields. It immensely helps the  management to minimise error at the input data entry level while the volume of entry is huge and requires large number of persons to accomplish the job.

I have tried to explain the basic features of Data Validation and its usage, however handling some practical problems will bring more clarity about the concept. 

Answers 5 Comments
Dislike Bookmark

Answered on 13/09/2018 Learn Language/Spoken English

How much are the charges per hour to teach spoken English to a group of 25 students between the age of... ...more

How much are the charges per hour to teach spoken English to a group of 25 students between the age of 16 and 19 . They are from the vernacular medium.

The question you put is about the rate per Hour for teaching Spoken English of a batch of 25 student. I presume that the student are coming from a lowercass or a lower middle class family as they are taking education in vernacuar medium ( unable to afford Convent Schools). In that case as per my suggestion... ...more

The question you put is about the rate per Hour for teaching Spoken English of a batch of 25 student. 

I presume that the student are coming from a lowercass or a lower middle class family as they are taking education in vernacuar medium ( unable to afford Convent Schools). 

In that case as per my suggestion you can fix a reasonable rate of Rs 50/hr per student. In that case even if some student has a 1 hour class perday for 5 days a week he needs to pay as low as = Rs (1x5x4x50) = Rs 1000 only. 

The teacher is earning @ 50x25x1x5x4 = Rs 25000. Which is reasonably good. 

The Rate per hour may vary from 50 to 100 depending on the size of the batch or the affordability of the student. This means if the batch size is small the rate per hour can be increased to 60 or 70 and so on. 

If your student are coming from affluent society or upper middle class family then obviously the rate will be much higher. Hope you will get a reasonable guideline from my answer.  

Answers 40 Comments
Dislike Bookmark

Answered on 29/05/2018 Learn Language/Spoken English

Dear Madam, Your problem is very common and therefore never feel any complex for that reason. Just try to adopt the following habits which I usually advise to my students: - 1) Read English News Papers daily especially the Editorial Column. 2) Practice a mock conversation with yourself (self-talking)... ...more

Dear Madam,

Your problem is very common and therefore never feel any complex for that reason. Just try to adopt the following habits which I usually advise to my students: -

1) Read English News Papers daily especially the Editorial Column.

2) Practice a mock conversation with yourself (self-talking) at least for 40-45 minutes in English in front of a mirror or inside in your room on any topic or on any assumed situation..

3)Regularly watch English VDOs from internet for improving your listening skill & pronunciation. 

4) If possible findout a friend or a relative or any of your near ones as your spoken english partner. Speak with him in english at least for 45 minutes every day.  

4) Last but not the least find out a suitable Tutor who can rectify your mistakes or modify your conversation using appropriate words or expression while speaking. 

Best of luck....happy searching...

Answers 68 Comments
Dislike Bookmark

Teaches

Microsoft Excel Training classes
22 Students

UrbanPro Certified Tutor

For Microsoft Excel Training

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

Basic Excel, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

I am very happy to share that I am an Experienced Corporate trainer in Basic to Advance Excel from Kolkata-West Bengal and regularly providing Online as well as offline training to my students. I use Skype as my medium of my online training. My Corporate training includes big MNCs like "ITC LTD". Most of my students are working professionals and scattered all over India. Some of them are even placed abroad. The greatest advantages of my training are as follows : 1) I always share my Excel Files at the end of my every session. 2) I provide exercises on each topic as home assignment for practice and provide the solutions later. This immensely help each of my student to understand each function of Excel in depth. 3) I am always flexible about my timings and conduct the sessions as per student's matching time. 4) My rates are Hourly and payments are on weekly basis. 5) For Online student payments may be made in advance on weekly basis. 6) I am available to my students for discussion on any topic about my shared files even after 6 months or year or so. 7) Please call me or WhatsApp me in my number for any suggestion or immediate assistance on MS Excel.

Spoken English classes
3 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Spoken English classes

5

Age groups catered to

Above 25 yrs, 16 yrs to 25 yrs

Levels of Spoken English I teach

Basic

Lived or Worked in English Speaking Country

No

Awards and Recognition

No

Certification

None

Profession

Working Professional

Language of instruction offered

Hindi to English, English to English

Curriculum Expertise

CBSE, State, ICSE/ISC

Citizen of English Speaking Country

No

Class strength catered to

Group Classes, One on one/ Private Tutions

Teaching done in

Basic Spoken English, English Grammar, Vocabulary

Teaching at

Home

Teaching Experience in detail in Spoken English classes

I am an experienced trainer of spoken English and corporate communication located at Kolkata. I am regularly providing training to my students both on face to face mode as well as over phone. I regularly conduct group classes at my residence on Wednesday, Friday and Sunday. My location is Dunlop Bridge Crossing which is well connected with Metro, Road Transport or Train communications.

Class 11 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 11 Tuition

5

Board

State, ISC/ICSE, CBSE

State boards taught

West Bengal State Board

Preferred class strength

Group Classes, One on one/ Private Tutions

ISC/ICSE Subjects taught

Commerce, Accounts, Computer Science

CBSE Subjects taught

Business Studies, Accountancy, Economics

Taught in School or College

No

State Syllabus Subjects taught

Computer Science, Statistics, Business Studies, Accountancy

Teaching Experience in detail in Class 11 Tuition

1) Maximum 2 Days in aweek having a session duration of 1-1/2 hours to 2 hrs per day. 2) Take mock tests chapter of the subject matter at regular intervals to evaluate the progress of the student. 3) Always put focus on the completion of the syllabus. 4) Providing home asssignments on regular basis which sometimes put pressure on the student. 5) Weekly payment is mandatory for every student.

Class 12 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 12 Tuition

5

Board

State, ISC/ICSE, CBSE

ISC/ICSE Subjects taught

Commerce, Accounts, EVS

CBSE Subjects taught

Accountancy, Economics

Taught in School or College

No

State Syllabus Subjects taught

Chemistry, Computer Science, Business Studies, English, Mathematics, Physics, Accountancy, Biology

Teaching Experience in detail in Class 12 Tuition

1) Maximum 2 Days in aweek having a session duration of 1-1/2 hours to 2 hrs per day. 2) Take mock tests chapter of the subject matter at regular intervals to evaluate the progress of the student. 3) Always put focus on the completion of the syllabus. 4) Providing home asssignments on regular basis which sometimes put pressure on the student. 5) Weekly payment is mandatory for every student.

Class 9 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 9 Tuition

5

Board

CBSE, State, ICSE

CBSE Subjects taught

Information and Comunication Technology, Mathematics, Accountancy, Science, Computer Practices, Elements of business

ICSE Subjects taught

Physics, Computer Application, Mathematics, Biology, Commercial Studies, Commercial Applications, Chemistry

Taught in School or College

No

State Syllabus Subjects taught

Mathematics, Science, English

Class 10 Tuition

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Class 10 Tuition

5

Board

CBSE, State, ICSE

CBSE Subjects taught

Information and Comunication Technology, Mathematics, Accountancy, Science, Computer Practices, Elements of business

ICSE Subjects taught

Physics, Computer Application, Mathematics, Biology, Commercial Studies, Commercial Applications, Chemistry

Taught in School or College

No

State Syllabus Subjects taught

Mathematics, Science, English

Bengali Speaking classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Bengali Speaking classes

5

Teaching Experience in detail in Bengali Speaking classes

I am a native Bengali speaker. I am at the same time fluent both in English as well as in Hindi. Therefore none of my students feel uncomfortable while interacting with me. I use to take classes for both for spoken English as well as Bengali. In case of Hindi Speaking students I translate the Bengali into their own language. I provide regular face to face as well as over phone training.

Answers by Mayukh B. (12)

Answered on 18/02/2019 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Dear Binayak, There are four different ways we can convert a number to a text in excel, 1) Put an Apostrophe(') to change Number to Text Format Steps : Go to the cell that contains the number. Open it in Edit mode of the cell – (Pressing F2 Key or Double click) Put an Apostrophe(‘) before... ...more

Dear Binayak,

 There are four different ways we can convert a number to a text in excel,

1) Put an Apostrophe(') to change Number to Text Format

Steps :

  1. Go to the cell that contains the number.
  2. Open it in Edit mode of the cell – (Pressing F2 Key or Double click)
  3. Put an Apostrophe(‘) before the number.

 2) Changing the Formatting of Cell option to “Text”

Steps :

  1. Select the Cell or range of cells that contains the Number
  2. Go to Number Formatting – ( Pressing Ctrl+1)
  3. Select “Text” which is 3rd from bottom in the opened dialog box and press ente.

3) Using Excel “Text” Function

Steps:

  1. If the number is in A1 Cell then go to B1 Cell in Excel
  2. Put the formula =Text(A1,”0”) in B1 Cell and press Enter.
  3. B1 Cell convers and show the Number(Contained in A1 Cell) in Text Form.
  4. The TEXT function converts a numeric value to formatted text, thus the result cannot be calculated.

4) Convert numbers to text in Excel with Text to Columns wizard:

Steps: 

  1. At first Select the column that contains the numbers.
  2. Go to the “Data Tab”
  3. Select “Text to Columns” icon from that Menu
  4. Go through that wizard and ensure that the Radio Button “ Text” must be selected.
  5. Click on Finish.
Answers 8 Comments
Dislike Bookmark

Answered on 16/12/2018 Learn IT Courses/MS Office Software Training +1 IT Courses/MS Office Software Training/Microsoft Excel Training

Ankit, Prerviously Grouping of Columns and rows were not available in Google Sheets, but from 13th April-2018 this drawback has been removed. So, now you can easily make groupng of rows or columns in Google Sheets as we are doing in Excel. That means frustration period is over. Now how to group rows... ...more

Ankit,

Prerviously Grouping of Columns and rows were not available in Google Sheets, but from 13th April-2018 this drawback has been removed. So, now you can easily make groupng of rows or columns in Google Sheets as we are doing in Excel. That means frustration period is over.  

Now how to group rows and columns in Google Sheets ? Steps are very simple like following :-

1) At first select the entire rows or colums which we want to group.

2)Then right click  and select the option "Group Row Numbers 4-15" - Say Grouping of Rows 4 to 15 or "Group Column B-E(Say)" - Say for Grouping of columns B to E. 

3) Now Click on the Minus Sign (-) to collapse the grouped rows and columns with Plus Sign(+) appearing.

4) Again click on Plus Sign (+) to expand the grouped rows or colums. 

Hope you are satisfied with the answer.

 

Answers 1 Comments
Dislike Bookmark

Answered on 05/11/2018 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Data validation is an important function available in Excel. It basically prevents any wrong input entry from the end of data entry operator or user. Most frequently used restrictions are as follows : 1) Enter the input data only through selection from a predetermined drop down list. This ensures zero... ...more

Data validation is an important function available in Excel. It basically prevents any wrong input entry from the end of data entry operator or user. Most frequently used restrictions  are as follows :

1) Enter the input data only through selection from a predetermined drop down list. This ensures zero spelling mistakes while entering.

2) Restrics data entry within a specified range of values (Say not below 10 or not more than 20). So, the said input data field rejects any input value entry which is not falling within that predefind data range.

3) Ensures Input data entry within specified dates or within a specified time period. So, the input data field acceps only the date entered which is falling in between the specified dates previously determined by the user (say within 01/01/18 to 30/09/18)

4) It ensures text data entry within a specified number of characters (Say upto 25 characters or letters).

Error message or warning messages can be displayed for any wrong input entry in data validated fields. It immensely helps the  management to minimise error at the input data entry level while the volume of entry is huge and requires large number of persons to accomplish the job.

I have tried to explain the basic features of Data Validation and its usage, however handling some practical problems will bring more clarity about the concept. 

Answers 5 Comments
Dislike Bookmark

Answered on 13/09/2018 Learn Language/Spoken English

How much are the charges per hour to teach spoken English to a group of 25 students between the age of... ...more

How much are the charges per hour to teach spoken English to a group of 25 students between the age of 16 and 19 . They are from the vernacular medium.

The question you put is about the rate per Hour for teaching Spoken English of a batch of 25 student. I presume that the student are coming from a lowercass or a lower middle class family as they are taking education in vernacuar medium ( unable to afford Convent Schools). In that case as per my suggestion... ...more

The question you put is about the rate per Hour for teaching Spoken English of a batch of 25 student. 

I presume that the student are coming from a lowercass or a lower middle class family as they are taking education in vernacuar medium ( unable to afford Convent Schools). 

In that case as per my suggestion you can fix a reasonable rate of Rs 50/hr per student. In that case even if some student has a 1 hour class perday for 5 days a week he needs to pay as low as = Rs (1x5x4x50) = Rs 1000 only. 

The teacher is earning @ 50x25x1x5x4 = Rs 25000. Which is reasonably good. 

The Rate per hour may vary from 50 to 100 depending on the size of the batch or the affordability of the student. This means if the batch size is small the rate per hour can be increased to 60 or 70 and so on. 

If your student are coming from affluent society or upper middle class family then obviously the rate will be much higher. Hope you will get a reasonable guideline from my answer.  

Answers 40 Comments
Dislike Bookmark

Answered on 29/05/2018 Learn Language/Spoken English

Dear Madam, Your problem is very common and therefore never feel any complex for that reason. Just try to adopt the following habits which I usually advise to my students: - 1) Read English News Papers daily especially the Editorial Column. 2) Practice a mock conversation with yourself (self-talking)... ...more

Dear Madam,

Your problem is very common and therefore never feel any complex for that reason. Just try to adopt the following habits which I usually advise to my students: -

1) Read English News Papers daily especially the Editorial Column.

2) Practice a mock conversation with yourself (self-talking) at least for 40-45 minutes in English in front of a mirror or inside in your room on any topic or on any assumed situation..

3)Regularly watch English VDOs from internet for improving your listening skill & pronunciation. 

4) If possible findout a friend or a relative or any of your near ones as your spoken english partner. Speak with him in english at least for 45 minutes every day.  

4) Last but not the least find out a suitable Tutor who can rectify your mistakes or modify your conversation using appropriate words or expression while speaking. 

Best of luck....happy searching...

Answers 68 Comments
Dislike Bookmark

Contact

Load More

Mayukh B. describes himself as Versatile Trainer. He conducts classes in Bengali Speaking, Class 10 Tuition and Class 11 Tuition. Mayukh is located in Bonhooghly Government Colony, Kolkata. Mayukh takes Regular Classes- at his Home and Online Classes- via online medium. He has 20 years of teaching experience . Mayukh has completed Master of Commerce (M.Com.) from Calcutta University in 1988. HeĀ is well versed in Hindi, Bengali and English. Mayukh has got 14 reviews till now with 100% positive feedback.

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